Example #1
0
        public static List <Nj_Detail> PrintClients(string Search = "", string id = "", string sDate = "", string eDate = "")
        {
            Nj_Detail obj = new Nj_Detail();
            var       nj  = obj.ClientList(Search, id, sDate, eDate);

            return(nj);
        }
Example #2
0
        public static List <Nj_Detail> UserDetailsbyEmployeeAdded(string Search = "", string id = "", int PageIndex = 0, string sDate = "", string eDate = "")
        {
            Nj_Detail obj = new Nj_Detail();
            var       nj  = obj.ClientList(Search, id, sDate, eDate);

            int              PageSize  = 15;
            int              skip      = PageIndex * PageSize;
            double           PageCount = Convert.ToDouble(Math.Ceiling((double)((double)nj.Count() / (double)PageSize)));
            List <Nj_Detail> query     = nj.Skip(skip).Take(PageSize).ToList();

            return(query);
        }
Example #3
0
        public static List <Nj_Detail> DropdownList(string Search = "", string id = "", string sDate = "", string eDate = "")
        {
            Nj_Detail obj = new Nj_Detail();
            var       nj  = obj.ClientList(Search, id, sDate, eDate);

            //  List<Nj_Detail> distinct = nj.GroupBy(n => n.IsAddedBy).Select(g => g.First()).ToList();


            List <Nj_Detail> result = nj.GroupBy(l => l.IsAddedBy).Select(cl => new Nj_Detail
            {
                IsAddedBy          = cl.First().IsAddedBy,
                IsaddedbyFirstName = cl.First().IsaddedbyFirstName,
                Payment_Balance    = cl.Sum(c => c.Payment_Balance),
                Payment_Paid       = cl.Sum(c => c.Payment_Paid),
                Payment_Total      = cl.Sum(c => c.Payment_Total),
            }).ToList();


            return(result);
        }
Example #4
0
        public static string ClientTodayReport(string Search = "")
        {
            Nj_Detail obj     = new Nj_Detail();
            var       nj      = obj.ClientList(Search);
            DataSet   p_dsSrc = new DataSet();
            DataTable dt      = new DataTable("MyTable");

            //dt.Columns.Add(new DataColumn("id", typeof(int)));
            dt.Columns.Add(new DataColumn("FirstName", typeof(string)));
            dt.Columns.Add(new DataColumn("LastName", typeof(string)));
            //dt.Columns.Add(new DataColumn("State", typeof(string)));
            dt.Columns.Add(new DataColumn("City", typeof(string)));
            dt.Columns.Add(new DataColumn("TotalPayment", typeof(float)));
            dt.Columns.Add(new DataColumn("Paid", typeof(float)));
            dt.Columns.Add(new DataColumn("Balance", typeof(float)));
            dt.Columns.Add(new DataColumn("AddedBy", typeof(string)));
            //dt.Columns.Add(new DataColumn("Source of communication", typeof(string)));
            DataRow dr             = dt.NewRow();
            double  PaymentTotal   = 0;
            double  PaymentPaid    = 0;
            double  PaymentBalance = 0;

            foreach (var item in nj)
            {
                dr = dt.NewRow();
                dr["FirstName"] = item.F_Name;
                dr["LastName"]  = item.L_Name;
                //dr["State"] = item.ST;
                dr["City"]    = item.Muncipality;
                dr["AddedBy"] = item.IsaddedbyFirstName;
                //dr["Source of communication"] = item.SourceComm;
                if (item.Payment_Total != null)
                {
                    dr["TotalPayment"] = item.Payment_Total;
                    PaymentTotal       = PaymentTotal + Convert.ToDouble(item.Payment_Total);
                }
                else
                {
                    dr["TotalPayment"] = 0;
                }
                if (item.Payment_Paid != null)
                {
                    PaymentPaid = PaymentPaid + Convert.ToDouble(item.Payment_Paid);
                    dr["Paid"]  = item.Payment_Paid;
                }
                else
                {
                    dr["Paid"] = 0;
                }
                if (item.Payment_Balance != null)
                {
                    PaymentBalance = PaymentBalance + Convert.ToDouble(item.Payment_Balance);
                    dr["Balance"]  = item.Payment_Balance;
                }
                else
                {
                    dr["Balance"] = 0;
                }
                dt.Rows.Add(dr);
            }

            for (int i = 0; i <= 4; i++)
            {
                if (i < 4)
                {
                    dt.Rows.Add();
                }
                else
                {
                    dr                 = dt.NewRow();
                    dr["City"]         = "Total";
                    dr["TotalPayment"] = PaymentTotal;
                    dr["Paid"]         = PaymentPaid;
                    dr["Balance"]      = PaymentBalance;
                    dt.Rows.Add(dr);
                }
            }
            p_dsSrc.Tables.Add(dt);
            Clients objClients  = new Clients();
            int     GetTotalRow = nj.Count();

            GetTotalRow = GetTotalRow + 6;
            string Filepath = objClients.GenrateEcelTodayReport(p_dsSrc, GetTotalRow);
            string Result   = objClients.SendClientsEmail(Filepath);

            return(Result);
        }