C#

• Properties (C# Programming Guide)[^]
• Using Properties (C# Programming Guide)[^]

public void WardList()
        {
            #region Load Values...
            int count = 1;
            List WWList = new List();
            Engine E = new Engine();
            SQLiteCommand CMD = new SQLiteCommand(E.SelectSQL("WARDS") + " ORDER BY [WARDNUMBER];", E.Conn);
            SQLiteDataReader RDR = CMD.ExecuteReader();
 
            while (RDR.Read())
            {
                WardWise WW = new WardWise();
                WW.Serial = count;
                WW.WardNumber = Convert.ToInt32(RDR["WARDNUMBER"]);
                WW.WardCount = WardCount(WW.WardNumber);
                WW.Name = RDR["NAME"].ToString();
                WW.Manager = RDR["MANAGER"].ToString();
                WW.TotalTax = WardExists(WW.WardNumber) ? WardWiseTax(WW.WardNumber) : 0;
                WW.TotalPaid = WardExists(WW.WardNumber) ? WardWiseTax(WW.WardNumber, false) : 0;
                WW.Balance = WW.TotalTax - WW.TotalPaid;
                count++;
                WWList.Add(WW);
            }
            #endregion

            using (ExcelPackage EP = new ExcelPackage(Masters, Template))
            {
                double hook = 8;
                ExcelWorksheet Sheet = EP.Workbook.Worksheets["AWW"];
 
                foreach (WardWise WW in WWList)
                {
                    Sheet.Cells["A" + hook].Value = WW.Serial;
                    Sheet.Cells["B" + hook].Value = WW.WardNumber + " [" + WW.WardCount + "]";
                    Sheet.Cells["C" + hook].Value = WW.Name;
                    Sheet.Cells["D" + hook].Value = WW.Manager;
                    Sheet.Cells["E" + hook].Value = WW.TotalTax;
                    Sheet.Cells["F" + hook].Value = WW.TotalPaid;
                    Sheet.Cells["G" + hook].Formula = ("E" + hook) + "-" + ("F" + hook);
                    hook++;
                }
                Sheet.Cells["A8:G" + (hook - 1)].Style.Border.Top.Style =
                    Sheet.Cells["A8:G" + (hook - 1)].Style.Border.Bottom.Style =
                    Sheet.Cells["A8:G" + (hook - 1)].Style.Border.Left.Style =
                    Sheet.Cells["A8:G" + (hook - 1)].Style.Border.Right.Style = ExcelBorderStyle.Thin;
 
                Sheet.Cells["G" + (hook + 1)].Formula = string.Format("SUM(G8:G{0})", hook - 1);
                Sheet.Cells["G" + (hook + 1)].Style.Font.Bold = true;
                Sheet.Cells["G" + (hook + 1)].Style.Border.Top.Style =
                    Sheet.Cells["G" + (hook + 1)].Style.Border.Bottom.Style =
                    Sheet.Cells["G" + (hook + 1)].Style.Border.Left.Style =
                    Sheet.Cells["G" + (hook + 1)].Style.Border.Right.Style = ExcelBorderStyle.Thick;
 
                EP.Save();
            }
            Process P = Process.Start(MastersFile);
            handle = P.MainWindowHandle;
            SetForegroundWindow(handle);
        }

private static readonly string TemplatesFile =
            Path.Combine(Directories.CurrentDirectory, "Reports", "ReportsTemplate.xlsx");
        private static readonly string MastersFile =
            Path.Combine(Directories.CurrentDirectory, "Reports", "Master.xlsx");
        private static FileInfo Template = new FileInfo(TemplatesFile);
        private static FileInfo Masters;

A first chance exception of type 'System.ObjectDisposedException' occurred in System.Data.SQLite.dll

ERROR: Cannot access a disposed object.
Object name: 'SQLiteConnection'. TARGET: Void CheckDisposed() STACK TRACE: at System.Data.SQLite.SQLiteConnection.CheckDisposed()
   at System.Data.SQLite.SQLiteConnection.get_State()
   at System.Data.SQLite.SQLiteDataReader.CheckClosed()
   at System.Data.SQLite.SQLiteDataReader.Read()
   at PTMS.Classes.Reports.Reporting.WardWiseTax(Int32 WardNumber) in Reporting.cs:line 209
19/09/2015 12:18:39 PM : ERROR: Cannot access a disposed object.
Object name: 'SQLiteConnection'. TARGET: Void CheckDisposed() STACK TRACE: at System.Data.SQLite.SQLiteConnection.CheckDisposed()
   at System.Data.SQLite.SQLiteConnection.get_State()
   at System.Data.SQLite.SQLiteDataReader.CheckClosed()
   at System.Data.SQLite.SQLiteDataReader.Read()
   at PTMS.Classes.Reports.Reporting.WardWiseTax(Int32 WardNumber, Boolean TotalPaid) in Reporting.cs:line 231

private double WardWiseTax(Int32 WardNumber)
        {
            double TT = 0;
            try
            {
                Engine E = new Engine();
                SQLiteCommand CUSTCMD = new SQLiteCommand(E.SelectSQL("CUSTOMERS", "WARDNUMBER"), E.Conn);
                CUSTCMD.Parameters.AddWithValue("WARDNUMBER", WardNumber);
                SQLiteDataReader CUSTRDR = CUSTCMD.ExecuteReader();
                Calculate CT = new Calculate();

                while (CUSTRDR.Read()) // Here is the error (209)
                    TT += CT.LedgerBalance(CUSTRDR["DEMAND"].ToString())[1];

                CUSTCMD.Dispose();
                CUSTRDR.Dispose();
                CT.Dispose();

                return TT;
            }
            catch (Exception ex) { LogEvent.WriteErrorLog(ex); return 0; }
        }
        private double WardWiseTax(Int32 WardNumber, bool TotalPaid)
        {
            double TT = 0;
            try
            {
                Engine E = new Engine();
                SQLiteCommand CUSTCMD = new SQLiteCommand(E.SelectSQL("CUSTOMERS", "WARDNUMBER"), E.Conn);
                CUSTCMD.Parameters.AddWithValue("WARDNUMBER", WardNumber);
                SQLiteDataReader CUSTRDR = CUSTCMD.ExecuteReader();
                Calculate CT = new Calculate();

                while (CUSTRDR.Read()) // Here is the error (231)
                {
                    TT += CT.LedgerBalance(CUSTRDR["DEMAND"].ToString())[2];
                }

                CUSTCMD.Dispose();
                CUSTRDR.Dispose();
                CT.Dispose();

                return (TotalPaid) ? TT : 0;
            }
            catch (Exception ex) { LogEvent.WriteErrorLog(ex); return 0; }
        }