public IEnumerable <EvaluationReport> getEvaluationreport(int EID) { using (ClubDBEntities club = new ClubDBEntities()) { var re = (from o in club.Evaluations where o.ID == EID select o).First(); EvaluationReport report = new EvaluationReport(); report.Assessment = re.Assessment; report.Diagnosis = re.Diagnosis; report.DOB = re.Client.DOB.ToString(); report.EmpName = re.Employee.Name; report.FileID = re.ClientID.ToString(); report.Goals = re.Goals; report.History = re.History; report.Nation = re.Client.Nationality; report.Objective = re.Objective; report.PatientName = re.Client.FullName(); report.Phone = re.Client.Phone.ToString(); report.Date = re.Date.ToString("dd/MM/yyyy"); report.Treatment = re.Treatment; List <EvaluationReport> ll = new List <EvaluationReport>(); ll.Add(report); return(ll.AsEnumerable()); } }
public IEnumerable <EvaluationReport> getEvaluationreport(string EID) { using (ClubDBEntities club = new ClubDBEntities()) { int id = Convert.ToInt32(EID); var result = club.Evaluations.Where(a => a.ClientID == id).ToList().Select(re => new EvaluationReport() { Assessment = re.Assessment, Diagnosis = re.Diagnosis, DOB = re.Client.DOB.ToString(), EmpName = re.Employee.Name, FileID = re.ClientID.ToString(), Goals = re.Goals, History = re.History, Nation = re.Client.Nationality, Objective = re.Objective, PatientName = re.Client.FullName(), Phone = re.Client.Phone.ToString(), Date = re.Date.ToString("dd/MM/yyyy"), ID = re.ID.ToString(), Treatment = re.Treatment, }).ToList(); return(result); } }
public IEnumerable <VisitReport> getVisitReport(int subID) { using (ClubDBEntities club = new ClubDBEntities()) { var visitResult = club.Visits.Where(a => a.SubID == subID).ToList().Select(s => new VisitReport() { DateOfVisit = s.Date.ToShortDateString(), SigninTime = s.SigninTime.ToString(), SizeAfter = s.SizeAfter, SizeBefore = s.SizeBefore }).ToList(); var rest = (from o in club.Subscribtions where o.SubID == subID select new { serviceName = o.Service.Name, fileID = o.ClientID, clientName = o.Client.FirstName + " " + o.Client.SecondName + " " + o.Client.LastName + " " + o.Client.FamilyName, dateOfSub = o.Date }).First(); int index = 1; foreach (var row in visitResult) { row.DateOfSub = rest.dateOfSub.ToShortDateString(); row.FileID = rest.fileID.ToString(); row.Name = rest.clientName; row.ServiceName = rest.serviceName; row.Ser = index.ToString(); index++; } return(visitResult.AsEnumerable()); } }
public IEnumerable <DischargeReport> getDischargeReport(string EID) { using (ClubDBEntities club = new ClubDBEntities()) { int id = Convert.ToInt32(EID); var re = club.Discharges.Where(a => a.ClientID == id).ToList().Select(a => new DischargeReport() { Diagnosis = a.Diagnosis, DOB = a.Client.DOB.ToString(), EmpName = a.Employee.Name, FileID = a.ClientID.ToString(), Goals = a.Goals, Nation = a.Client.Nationality, PatientName = a.Client.FullName(), Phone = a.Client.Phone.ToString(), Date = a.Date.ToString("dd/MM/yyyy"), Comments = a.Comments, Discharge = a.Discharge1, FinalSession = a.FinalSession, GoalsBool = a.GoalsBool, InitialSession = a.InitialSession, PreReferral = a.PreReferral, TotalSessions = a.TotalNSession, Treatment = a.Treatment, ID = a.ID.ToString(), }).ToList(); return(re); } }
public IEnumerable <DischargeReport> getDischargeReport(int EID) { using (ClubDBEntities club = new ClubDBEntities()) { var re = (from o in club.Discharges where o.ID == EID select o).First(); DischargeReport report = new DischargeReport(); report.Diagnosis = re.Diagnosis; report.DOB = re.Client.DOB.ToString(); report.EmpName = re.Employee.Name; report.FileID = re.ClientID.ToString(); report.Goals = re.Goals; report.Nation = re.Client.Nationality; report.PatientName = re.Client.FullName(); report.Phone = re.Client.Phone.ToString(); report.Date = re.Date.ToString("dd/MM/yyyy"); report.Comments = re.Comments; report.Discharge = re.Discharge1; report.FinalSession = re.FinalSession; report.GoalsBool = re.GoalsBool; report.InitialSession = re.InitialSession; report.PreReferral = re.PreReferral; report.TotalSessions = re.TotalNSession; report.Treatment = re.Treatment; List <DischargeReport> ll = new List <DischargeReport>(); ll.Add(report); return(ll.AsEnumerable()); } }
public IEnumerable <InvoiceReport> getInvoiceHeader(int invID) { using (ClubDBEntities club = new ClubDBEntities()) { //var result = club.InvoiceHeaders.Where(a => a.InvID == invID); // get the services var result = club.InvoiceServices.Where(a => a.InvID == invID).ToList().Select( a => new InvoiceReport { ServiceName = a.Service.Name, ServicePrice = a.Service.Price.ToString("0.00") }).ToList();; var invoice = club.InvoiceHeaders.Where(a => a.InvID == invID).First(); var paid = club.Deposits.Where(a => a.InvID == invID).Count() == 0 ? 0 : club.Deposits.Where(a => a.InvID == invID).Sum(a => a.Amount); var remain = invoice.FinalAmount - paid; foreach (var row in result) { row.ClientName = invoice.Client.FullName(); row.Date = invoice.Date.ToString("dd/MM/yyyy"); row.Discount = invoice.Discount.ToString(); row.FileID = invoice.ClientID.ToString(); row.FinalAmount = invoice.FinalAmount.ToString("0.00"); row.InvoiceID = invoice.InvID.ToString(); row.PaidAmount = paid.ToString("0.00"); row.Receptionist = invoice.RecepName; row.RemainAmount = remain.ToString("0.00"); row.TotalAmount = invoice.TotalAmount.ToString("0.00"); row.Notes = invoice.Notes; } return(result); } }
public IEnumerable <IncomeReport> getIncomeReport(DateTime date) { using (ClubDBEntities club = new ClubDBEntities()) { int month = date.Month; int year = date.Year; DateTime start = new DateTime(year, month, 1); DateTime end = start.AddMonths(1).AddDays(-1); CultureInfo cul = new CultureInfo("ar-SA"); List <IncomeReport> result = new List <IncomeReport>(); IncomeReport one; int index = 1; for (DateTime d = start; d <= end; d = d.AddDays(1)) { one = new IncomeReport(); one.Ser = index.ToString(); one.Date = d.ToString("yyyy/MM/dd"); one.Income = club.Deposits.Where(a => a.Date == d).Count() == 0 ? "0" : club.Deposits.Where(a => a.Date == d).Sum(a => a.Amount).ToString("0.00"); one.Day = cul.DateTimeFormat.DayNames[(int)d.DayOfWeek]; one.Withdrawl = club.Withdraws.Where(a => a.Date == d && a.BankID == null).Sum(a => (decimal?)a.Amount) == null ? "0" : club.Withdraws.Where(a => a.Date == d && a.BankID == null).Sum(a => (decimal)a.Amount).ToString("0.00"); one.Total = (Convert.ToDecimal(one.Income) - Convert.ToDecimal(one.Withdrawl)).ToString(); result.Add(one); index++; } return(result); } }
public string FullName() { using (ClubDBEntities club = new ClubDBEntities()) { string name = FirstName + " " + SecondName + " " + LastName + " " + FamilyName; return(name); } }
public IEnumerable <JointReport> getMovReportWithCash(DateTime date) { using (ClubDBEntities club = new ClubDBEntities()) { var result = club.Deposits.Where(i => i.Date == date).ToList().Select(i => new JointReport() { ClientName = i.InvoiceHeader.Client.FullName(), FileID = i.InvoiceHeader.ClientID.ToString(), Phone = i.InvoiceHeader.Client.Phone.ToString(), InvNum = i.InvID.ToString(), VoucherNum = i.ID.ToString(), Amount = i.InvoiceHeader.FinalAmount.ToString("0.00"), Services = arrayToString(club.InvoiceServices.Where(p => p.InvID == i.InvoiceHeader.InvID).Select(o => o.Service.Name)), Notes = i.Notes, Paid = i.Amount.ToString("0.00"), Date = date.ToString("dd/MM/yyyy"), }).ToList(); int index = 1; var cresult = (from o in club.CashMovs where o.Date == date select o).FirstOrDefault(); foreach (var row in result) { if (cresult != null) { //row.Date = date.ToString("yyyy/MM/dd"); row.CBalance = cresult.Balance.ToString("0.00"); row.CBank = cresult.Bank.ToString("0.00"); row.CExpenses = cresult.Expenses.ToString("0.00"); row.CInvIncome = cresult.InvIncome.ToString("0.00"); row.CMigBalance = cresult.MigBalance.ToString("0.00"); row.CPreBalance = cresult.PreBalance.ToString("0.00"); } row.Ser = index.ToString(); index++; int invNum = Convert.ToInt32(row.InvNum); var r = (from o in club.Deposits where o.Date != date && o.InvID == invNum select o.Amount); if (r.Count() <= 0) { row.PrePaid = "0"; } else { row.PrePaid = r.Sum().ToString(); } row.Remain = (Convert.ToDecimal(row.Amount) - Convert.ToDecimal(row.PrePaid) - Convert.ToDecimal(row.Paid)).ToString(); } return(result); } }
public IEnumerable <WithTypeReport> getWithTypes() { using (ClubDBEntities club = new ClubDBEntities()) { var result = club.WithTypes.OrderBy(a => a.Department).ToList().Select(a => new WithTypeReport() { ID = a.ID.ToString(), Name = a.Name, Department = a.Department1.Name, }).ToList(); return(result); } }
public IEnumerable <SubsOfTheDay> getSubsOfTheDay() { using (ClubDBEntities club = new ClubDBEntities()) { DateTime date = DateTime.Now.Date; var result = club.Subscribtions.Where(a => a.Date == date).ToList().GroupBy(k => k.ClientID).Select(a => new SubsOfTheDay() { ClientName = club.Clients.Where(p => p.ClientID == a.Key).First().FullName(), FileID = a.Key.ToString(), Services = arrayToString(a.Select(p => p.Service.Name)), }).ToList(); return(result); } }
public IEnumerable <EmpReport> getEmployees() { using (ClubDBEntities club = new ClubDBEntities()) { var result = club.Employees.ToList().Select(a => new EmpReport() { Name = a.Name, ID = a.EmpID.ToString(), Phone = a.PhoneNum.ToString(), Dep = a.Type == "Manager"? "إدارة":"عيادات", }).ToList(); return(result.AsEnumerable()); } }
public IEnumerable <TodayVisits> getVisitsByDate(DateTime date) { using (ClubDBEntities club = new ClubDBEntities()) { var result = club.Visits.Where(a => a.Date == date).ToList().Select(a => new TodayVisits() { ClientID = a.ClientID.ToString(), ClientName = a.Client.FullName(), Sub = a.Subscribtion.Service.Name, Time = a.SigninTime.ToString() }).ToList(); return(result); } }
public IEnumerable <BuffetReport> getBuffetExpenseReport(DateTime date) { using (ClubDBEntities club = new ClubDBEntities()) { var bresult = (from o in club.BuffetMovs where o.Date == date select o).FirstOrDefault(); var cresult = (from o in club.CashMovs where o.Date == date select o).FirstOrDefault(); var eresult = (from o in club.ExpensesMovs where o.Date == date select o).FirstOrDefault(); BuffetReport buffet = new BuffetReport(); if (eresult != null) { buffet.Date = date.ToString("yyyy/MM/dd"); buffet.EBalance = eresult.Balance.ToString("0.00"); buffet.EExpenses = eresult.Expenses.ToString("0.00"); buffet.EMigBalance = eresult.MigBalance.ToString("0.00"); buffet.EPlusBalance = eresult.PlusBalance.ToString("0.00"); buffet.EPreBalance = eresult.PreBalance.ToString("0.00"); } if (cresult != null) { buffet.Date = date.ToString("yyyy/MM/dd"); buffet.CBalance = cresult.Balance.ToString("0.00"); buffet.CBank = cresult.Bank.ToString("0.00"); buffet.CBuffetIncome = cresult.BuffetIncome.ToString("0.00"); buffet.CExpenses = cresult.Expenses.ToString("0.00"); buffet.CInvIncome = cresult.InvIncome.ToString("0.00"); buffet.CMigBalance = cresult.MigBalance.ToString("0.00"); buffet.CPreBalance = cresult.PreBalance.ToString("0.00"); } if (bresult != null) { buffet.Date = date.ToString("yyyy/MM/dd"); buffet.BBalance = bresult.Balance.ToString("0.00"); buffet.BMigBalance = bresult.MigBalance.ToString("0.00"); buffet.BPreBalance = bresult.PreBalance.ToString("0.00"); buffet.BPurchase = bresult.Purchase.ToString("0.00"); buffet.BSales = bresult.Sales.ToString("0.00"); } List <BuffetReport> ii = new List <BuffetReport>(); ii.Add(buffet); return(ii.AsEnumerable()); } }
public IEnumerable <ServiceReport> getServices() { using (ClubDBEntities club = new ClubDBEntities()) { var result = club.Services.Where(a => a.Deleted == false).OrderBy(a => new { a.DepID, a.Name }).ToList().Select(a => new ServiceReport() { ID = a.ServiceID.ToString(), Name = a.Name, Price = a.Price.ToString(), Dep = a.Department.Name, SubDays = a.TotalDays.ToString(), SubType = a.Sub ? "اشتراك شهري" : "جلسة واحدة", }).ToList(); return(result.AsEnumerable()); } }
public List <Subs> getSubs(int ClientID) { ClubDBEntities club = new ClubDBEntities(); var sub = club.Subscribtions.Include("Service") .Where(i => i.ClientID == ClientID) .ToList() .Select(item => new Subs { ServiceName = item.Service.Name, DaysLeft = item.LeftDays, SubDate = item.Date, SubID = item.SubID }).ToList(); return(sub); }
public IEnumerable <IncompleteInv> getIncompleteInvoices() { using (ClubDBEntities club = new ClubDBEntities()) { var result = club.InvoiceHeaders.Where(a => a.FinalAmount > club.Deposits.Where(o => o.InvID == a.InvID).Sum(l => (int?)l.Amount)).ToList().Select(i => new IncompleteInv() { InvID = i.InvID.ToString(), FileID = i.ClientID.ToString(), Date = i.Date.ToString("dd/MM/yyyy"), ClientName = i.Client.FullName(), Amount = i.FinalAmount.ToString("0.00"), EmpName = i.RecepName, Remain = (i.FinalAmount - club.Deposits.Where(a => a.InvID == i.InvID).Sum(o => o.Amount)).ToString() }).ToList(); return(result); } }
public IEnumerable <TRequestReport> getTRequestReport(DateTime EID) { using (ClubDBEntities club = new ClubDBEntities()) { var o = club.TReaquests.Where(a => a.Date == EID).ToList().Select(re => new TRequestReport() { Diagnosis = re.Diagnosis, EmpName = re.Employee.Name, FileID = re.ClientID.ToString(), PatientName = re.Client.FullName(), Phone = re.Client.Phone.ToString(), Date = re.ID.ToString(), }).ToList(); return(o); } }
public IEnumerable <TransReport> getTransReport(int month, int year) { CultureInfo cul = new CultureInfo("ar-SA"); using (ClubDBEntities club = new ClubDBEntities()) { var result = club.Withdraws.Where(a => a.Date.Month == month && a.Date.Year == year && a.BankID == null).OrderBy(a => a.Date).GroupBy(a => new { a.Date, a.WithType1 }).ToList().Select(a => new TransReport() { Date = a.Key.Date, Day = a.Key.Date.ToString("yyyy/MM/dd"), //cul.DateTimeFormat.DayNames[(int)a.Key.Date.DayOfWeek] + " - " + a.Key.Date.ToString("yyyy/MM/dd"), Type = a.Key.WithType1.Name, //club.WithTypes.Where(o=>o.ID == a.Key.WithType1).Select(o=>o.Name).FirstOrDefault(), Expense = club.Withdraws.Where(i => i.Date == a.Key.Date && i.BankID == null).Sum(i => i.Amount).ToString("0.00"), Income = club.Deposits.Where(i => i.Date == a.Key.Date).Count() == 0 ? "0" : club.Deposits.Where(i => i.Date == a.Key.Date).Sum(i => i.Amount).ToString(), Value = club.Withdraws.Where(i => i.Date == a.Key.Date && i.BankID == null && i.WithType == a.Key.WithType1.ID).Select(i => i.Amount).Sum(), }).ToList(); return(result); } }
public IEnumerable <TRequestReport> getTRequestReport(string EID) { using (ClubDBEntities club = new ClubDBEntities()) { int id = Convert.ToInt32(EID); var o = club.TReaquests.Where(a => a.ClientID == id).ToList().Select(re => new TRequestReport() { Diagnosis = re.Diagnosis, EmpName = re.Employee.Name, FileID = re.ClientID.ToString(), PatientName = re.Client.FullName(), Phone = re.Client.Phone.ToString(), Date = re.Date.ToString("dd/MM/yyyy"), ID = re.ID.ToString(), }).ToList(); return(o); } }
public IEnumerable <EandIReport> getEandIReport(int month, int year, int dep) { using (ClubDBEntities club = new ClubDBEntities()) { // get the expenses from withdrawal var withResult = club.Withdraws.Where(a => a.Date.Month == month && a.Date.Year == year && a.BankID == null).Where(a => a.WithType1.Department == dep).GroupBy(a => a.WithType).ToList().Select(a => new EandIReport() { Expenses = club.WithTypes.Where(o => o.ID == a.Key).Select(o => o.Name).First(), ExpenseAmount = a.Sum(o => o.Amount).ToString("0.00"), Month = month.ToString(), Year = year.ToString(), }).ToList(); if (withResult.Count == 0) { withResult = new List <EandIReport>(); EandIReport re = new EandIReport(); re.Month = month.ToString(); re.Year = year.ToString(); re.ExpenseAmount = "لايوجد مصاريف"; withResult.Add(re); } // TODO: // get the paid amount of each service in the Invoice Services Table var income = club.Deposits.Where(a => a.Date.Month == month).Where(a => a.Date.Year == year) .Where(a => a.InvoiceHeader.InvoiceServices.Any(p => p.Service.DepID == dep)) .Sum(a => (decimal?)a.Amount * (a.InvoiceHeader.InvoiceServices.Where(p => p.InvID == a.InvID).Where(p => p.Service.DepID == dep).Sum(p => (decimal?)p.Percentage))); decimal incomeResult = 0; if (income != null) { incomeResult = Math.Round(Convert.ToDecimal(income)); } //var incomeResult = club.Deposits.Where(a => a.Date.Year == year && a.Date.Month == month) // .Where(a => a.InvoiceHeader.Dep == dep).Count() == 0 ? 0 : club.Deposits.Where(a => a.Date.Year == year && a.Date.Month == month) // .Where(a => a.InvoiceHeader.Dep == dep).Sum(a => a.Amount); string depname = club.Departments.Where(a => a.DepID == dep).Select(a => a.Name).First(); foreach (var i in withResult) { i.Income = incomeResult.ToString(); i.Dep = depname; } return(withResult); } }
public IEnumerable <SubDetails> getSubDetails(int subID) { using (ClubDBEntities club = new ClubDBEntities()) { var result = club.Subscribtions.Where(a => a.SubID == subID).ToList() .Select(item => new SubDetails { ServiceName = item.Service.Name, SubDate = item.Date, TotalDays = item.SubDays, AttDays = item.AttDays, LeftDays = item.LeftDays, Measurements = item.Measurements, Diagnosis = item.Diagnosis, History = item.History, }).First(); // get rest of data if there is any var nut = (from n in club.NutSubs where n.SubID == subID select n).FirstOrDefault(); var iint = (from n in club.IntSubs where n.SubID == subID select n).FirstOrDefault(); if (!(nut == null)) { result.Fat = nut.Fat; result.Hieght = nut.Hight; result.Weight = nut.Weight; } else if (!(iint == null)) { result.BPressure = iint.BloodPressure; result.BSugar = iint.BloodSugar; } List <SubDetails> ii = new List <SubDetails>(); ii.Add(result); return(ii.AsEnumerable()); } }
public IEnumerable <WithdrawReport> getWithReport(int WithID) { using (ClubDBEntities club = new ClubDBEntities()) { var result = club.Withdraws.Where(a => a.ID == WithID).ToList().Select(o => new WithdrawReport() { Amount = o.Amount.ToString("0.00"), AmountW = o.AmountW, Bank = o.BankName, CheckNum = o.CheckNum.ToString(), Date = o.Date.ToString("dd/MM/yyyy"), EmployeeName = o.Employee.Name, ID = o.ID.ToString(), Notes = o.Notes, ToPerson = o.ToPerson, }).ToList(); return(result.AsEnumerable()); } }
public IEnumerable <WithdrawReport> getDepositReport(int depID) { using (ClubDBEntities club = new ClubDBEntities()) { var result = club.Deposits.Where(a => a.ID == depID).ToList().Select(o => new WithdrawReport() { Amount = o.Amount.ToString("0.00"), AmountW = o.AmountW, Bank = o.Bank, CheckNum = o.CheckNum.ToString(), Date = o.Date.ToShortDateString(), EmployeeName = o.Employee, ID = o.ID.ToString(), Notes = o.Notes, ToPerson = o.InvoiceHeader.Client.FullName(), }).ToList(); return(result.AsEnumerable()); } }
public IEnumerable <BankStatement> getBankStatemnet(DateTime from, DateTime to) { using (ClubDBEntities club = new ClubDBEntities()) { var sum = club.BankTrans.Where(a => a.Date < from).Sum(a => (decimal?)a.Amount); if (sum == null) { sum = 0; } var result = club.BankTrans.Where(a => a.Date >= from && a.Date <= to).ToList().Select(a => new BankStatement() { Date = a.Date.ToString("yyyy/MM/dd"), Debit = a.Amount < 0?a.Amount.ToString("0.00"):"0", Credit = a.Amount >= 0?a.Amount.ToString("0.00"):"0", Note = a.Note, Balance = (sum = sum + a.Amount).ToString(), }).ToList(); return(result); } }
public IEnumerable <InvoiceReport> getInvoice(int invID) { using (ClubDBEntities club = new ClubDBEntities()) { var result = club.InvoiceHeaders.Where(a => a.InvID == invID).ToList().Select(o => new InvoiceReport() { ClientName = o.Client.FullName(), Date = o.Date.ToString("dd/MM/yyyy"), Discount = o.Discount.ToString(), FileID = o.ClientID.ToString(), FinalAmount = o.FinalAmount.ToString("0.00"), InvoiceID = o.InvID.ToString(), PaidAmount = club.Deposits.Where(a => a.InvID == o.InvID).Count() == 0 ? "0" : club.Deposits.Where(a => a.InvID == o.InvID).Sum(a => a.Amount).ToString("0.00"), Receptionist = o.RecepName, RemainAmount = (o.FinalAmount - (club.Deposits.Where(a => a.InvID == o.InvID).Count() == 0? 0 : club.Deposits.Where(a => a.InvID == o.InvID).Sum(a => a.Amount))).ToString("0.00"), TotalAmount = o.TotalAmount.ToString("0.00"), Notes = o.Notes, }).ToList(); return(result.AsEnumerable()); } }
public IEnumerable <WithdrawReport> getDepositReport(int depID) { using (ClubDBEntities club = new ClubDBEntities()) { var result = club.Deposits.Where(a => a.ID == depID).ToList().Select(o => new WithdrawReport() { Amount = o.Amount.ToString("0.00"), AmountW = o.AmountW, Bank = o.Bank, InvNum = o.InvID.ToString(), PrePaid = club.Deposits.Where(a => a.InvID == o.InvID && a.ID != depID && a.Date < o.Date).Sum(a => (decimal?)a.Amount).HasValue ? club.Deposits.Where(a => a.InvID == o.InvID && a.ID != depID && a.Date < o.Date).Sum(a => a.Amount).ToString() : "0", CheckNum = o.CheckNum.ToString(), Date = o.Date.ToString("yyyy/MM/dd"), EmployeeName = o.Employee, ID = o.ID.ToString(), Notes = o.Notes, ToPerson = o.InvoiceHeader.Client.FullName(), }).ToList(); return(result.AsEnumerable()); } }
public IEnumerable <MovReport> getMovReport(DateTime date) { using (ClubDBEntities club = new ClubDBEntities()) { var result = club.Deposits.Where(i => i.Date == date).ToList().Select(i => new MovReport() { ClientName = i.InvoiceHeader.Client.FullName(), Phone = i.InvoiceHeader.Client.Phone.ToString(), InvNum = i.InvID.ToString(), VoucherNum = i.ID.ToString(), Amount = i.InvoiceHeader.FinalAmount.ToString("0.00"), Services = arrayToString(club.InvoiceServices.Where(p => p.InvID == i.InvoiceHeader.InvID).Select(o => o.Service.Name)), Notes = i.Notes, Paid = i.Amount.ToString("0.00"), Date = date.ToString("dd/MM/yyyy"), }).ToList(); int index = 1; foreach (var row in result) { row.Ser = index.ToString(); index++; int invNum = Convert.ToInt32(row.InvNum); var r = (from o in club.Deposits where o.Date != date && o.InvID == invNum select o.Amount); if (r.Count() <= 0) { row.PrePaid = "0"; } else { row.PrePaid = r.Sum().ToString(); } row.Remain = (Convert.ToDecimal(row.Amount) - Convert.ToDecimal(row.PrePaid) - Convert.ToDecimal(row.Paid)).ToString(); } return(result); } }
public IEnumerable <TRequestReport> getTRequestReport(int EID) { using (ClubDBEntities club = new ClubDBEntities()) { var re = (from o in club.TReaquests where o.ID == EID select o).First(); TRequestReport report = new TRequestReport(); report.Diagnosis = re.Diagnosis; report.DOB = re.Client.DOB.ToString(); report.EmpName = re.Employee.Name; report.FileID = re.ClientID.ToString(); report.Goals = re.Goals; report.Precaution = re.Precautions; report.Nation = re.Client.Nationality; report.PatientName = re.Client.FullName(); report.Phone = re.Client.Phone.ToString(); report.Date = re.Date.ToString("dd/MM/yyyy"); List <TRequestReport> ll = new List <TRequestReport>(); ll.Add(report); return(ll.AsEnumerable()); } }
public IEnumerable <ExpenseReport> getExpenseReport(DateTime date) { using (ClubDBEntities club = new ClubDBEntities()) { int month = date.Month; int year = date.Year; CultureInfo cul = new CultureInfo("ar-SA"); var result = club.Withdraws.Where(a => a.Date.Month == month && a.Date.Year == year && a.BankID == null).OrderBy(q => q.Date).ToList().Select(i => new ExpenseReport() { Date = i.Date.ToString("yyyy/MM/dd"), Day = cul.DateTimeFormat.DayNames[(int)i.Date.DayOfWeek], InvNum = i.ID.ToString(), InvAmount = i.Amount.ToString("0.00"), Note = i.Notes }).ToList(); int index = 1; foreach (var row in result) { row.Ser = index.ToString(); index++; } return(result); } }