using System;

using System.Collections.Generic;

using Microsoft.SharePoint.Client;

​

public class UInvoice

{

    public double Rate { get; set; }

​

    public double Rate2 { get; set; }

​

    public double amount { get; set; }

​

    public double amount2 { get; set; }

​

    public int year { get; set; }

}

​

public class Program

{

    public static void Main()

    {

        Microsoft.SharePoint.Client.ListItem item = null;

        List<UInvoice> invoices = getInvUInvoiceoiceCollection(1159, 499, 2562, 600, 2021, 25, 2, 3, 3, 0.03, item);

    }

​

    public static List<UInvoice> getInvUInvoiceoiceCollection(int irmsid, int AXID, int Area, int Area2, int ContractYear, int ContractPeriod, int GracePeriod, double Rate, double Rate2, double AG, Microsoft.SharePoint.Client.ListItem item)

    {

        List<UInvoice> invoices = new List<UInvoice>();

        double totalDue = 0.00;

        double prev_rate = 0.00;

        double prev_rate2 = 0.00;

        double prev_year_rate = 0.00;

        DateTime dt;

        for (int year = ContractYear; year <= ContractYear + ContractPeriod; year++)

        {

            string SignatureDate = string.Empty;

            double Curr_year_rate = 0;

            double Curr_year_rate2 = 0.00;

            int i = 1;

            if (year < (ContractYear + GracePeriod))

            {

                //set total amount zero for 

                totalDue = 0;

                prev_rate = 0.00;

                prev_rate2 = 0.00;

                Curr_year_rate = 0;

            }

            else

            {

                Console.WriteLine("Year:" + year + "Cond:" + (ContractYear + GracePeriod) + "\tRate:" + Rate + "prev rate:" + prev_year_rate);

                if (i == 1 || prev_year_rate != Rate)

                {

                    prev_rate = Rate;

                    prev_rate2 = Rate2;

                }

                else

                {

                    Curr_year_rate = (1 + AG) * prev_rate;

                    Curr_year_rate2 = (1 + AG) * prev_rate2;

                }

​

                if (i == 1 || prev_year_rate != Rate)

                {

                    Curr_year_rate = Rate;

                    Curr_year_rate2 = Rate2;

                }

                else

                {

                    Curr_year_rate = (1 + AG) * prev_rate;

                    Curr_year_rate2 = (1 + AG) * prev_rate2;

                }

                i += 1;

                prev_rate2 = Curr_year_rate2;

                prev_rate = Curr_year_rate;

                double curr_year_Due = Curr_year_rate * Area;

                double curr_year_Due2 = Curr_year_rate2 * Area2;

                // string pp = Convert.ToString(item["Penalty_x0020_Percentage"]).Replace("%", "");

                if (year == DateTime.Now.Year)

                {

                    prev_year_rate = Rate;

                //  SignatureDate = Convert.ToString(item["Signature_x0020_Date"]);

                //  dt = DateTime.Parse(SignatureDate);

                 //  CreateInvoiceItem(AXID.ToString(), Area, Rate, 0, year, curr_year_Due, irmsid, dt.ToString(), pp, Area2.ToString(), Rate2.ToString(), curr_year_Due2);

                }

                else

                {

                }

​

                UInvoice ui = new UInvoice();

                ui.amount = curr_year_Due;

                ui.amount2 = curr_year_Due2;

                ui.Rate = Curr_year_rate;

                ui.Rate2 = Curr_year_rate2;

                ui.year = year;

                invoices.Add(ui);

    }

        }

        return invoices;

    }

    }

​