public void GetClientBill(ClientBill clientBill) { this.clientBill = clientBill; this.ClientNameStr = clientBill.ClientName; this.MonthStr = clientBill.yearAndMonth.Month + "/" + clientBill.yearAndMonth.Year; this.PriceStr = clientBill.TotalBill.ToString(); }
public ActionResult BillPament(int?id) { int ab = Convert.ToInt32(Session["id"]); int bc = Convert.ToInt32(Session["Designation"]); if (ab != 0 && bc == 1) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ClientBill clientbill = db.ClientBills.Find(id); if (clientbill == null) { return(HttpNotFound()); } // ViewBag.ClientId = new SelectList(db.ClientBills, "ClientId", "ClietName"); ViewBag.payment = 00; return(View(clientbill)); } else { FormsAuthentication.SignOut(); return(RedirectToAction("Login", "Login")); } }
public BillWindow(ClientBill clientBill, YearAndMonth date) { InitializeComponent(); viewModel = CrmContianer.container.GetInstance <IBillViewModel>(); DataContext = viewModel; viewModel.GetClientBill(clientBill); viewModel.GetGridFromWindow(DynamicGrid); }
// GET: ClientBills/Details/5 public ActionResult Details(int?id) { ViewBag.error = id == null; ClientBill clientBill = db.ClientBills.Find(id); ViewBag.ClientError = clientBill == null; return(View(clientBill)); }
public ActionResult RetentionReport(int?id) { if (id != null) { ClientBill clientbill = db.SingleOrDefault <ClientBill>("select * from ClientBill where CBillID =@0", id); clientbill.RetentionAmtIsPaid = true; base.BaseSave <ClientBill>(clientbill, true); } return(View("RetentionReport", base.BaseIndex <ClientDet>(null, " * ", "ClientBill cb inner join Client c on cb.ClientID = c.ClientID where RetentionAmtIsPaid = '0' "))); }
public ActionResult NewServiceAdd(Client client, int?ServiceId, int?ScheduleTimeId, int?EmployeeId) { int er = 0; if (ServiceId == null) { er++; ViewBag.Service = "Select One Item"; } if (ScheduleTimeId == null) { er++; ViewBag.ScheduleTime = "Select One Item"; } if (EmployeeId == null) { er++; ViewBag.Employee = "Select One Item"; } if (er > 0) { ViewBag.ServiceId = new SelectList(db.Servicesses, "ServiceId", "ServiceName"); ViewBag.EmployeeId = new SelectList(db.Employees, "EmployeeId", "EmployeeName"); ViewBag.ScheduleTimeId = new SelectList(db.ScheduleTimes, "ScheduleTimeId", "ScheduleName"); return(View(client)); } else { ClientServiceList list = new ClientServiceList(); list.ClientId = client.ClientId; list.ServiceId = Convert.ToInt32(ServiceId); list.Service_Status = true; db.ClientServiceLists.Add(list); ClientBill bill = new ClientBill(); bill.ClientId = client.ClientId; bill.BillMonth = client.ClientGymStart; bill.BillStatus = false; var serviceprice = db.Servicesses.Where(x => x.ServiceId == ServiceId).FirstOrDefault().ServieAmount; bill.BillAmount = Convert.ToInt16(serviceprice); bill.DueStatus = 0; db.ClientBills.Add(bill); Schedule schedule = new Schedule(); schedule.ClientId = client.ClientId; schedule.EmployeeId = Convert.ToInt32(EmployeeId); schedule.ScheduleTimeId = Convert.ToInt32(ScheduleTimeId); db.Schedules.Add(schedule); db.SaveChanges(); ViewBag.Message = "Service Add Sucessful"; return(RedirectToAction("ClientInformation")); } }
private void customerItem_Load(object sender, EventArgs e) { labelControl5.Text = ucDisplayBills.SetValueForText1; //SupplierBill x = context.SupplierBills.Where(d => d.billID == int.Parse(ucDisplayBills.SetValueForText1)).FirstOrDefault(); ClientBill xc = context.ClientBills.Find(z); labelControl6.Text = (xc.billDate.ToString()).Substring(0, 10); labelControl16.Text = xc.Client.clientName; labelControl15.Text = " "; labelControl14.Text = xc.Client.clientPhoneNumber; clientBillItemBindingSource.DataSource = context.ClientBillItems.Where(v => v.billID == z).ToList(); itemBindingSource.DataSource = context.Items.ToList(); }
public object Generate(ClientBill clientBill) { this.clientBill = clientBill; Document doc = new Document(PageSize.A4); string fileName = clientBill.ClientName + clientBill.yearAndMonth.Month + "-" + clientBill.yearAndMonth.Year + "-" + clientBill.Recepits.Count + ".pdf"; string folder = (clientBill.ClientName); var output = new FileStream(MainConfigs.BaseSaveAdrressForPdf + folder + @"\" + fileName, FileMode.Create); var writer = PdfWriter.GetInstance(doc, output); doc.Open(); PdfPTable table1 = createBillConstTable(clientBill); doc.Add(table1); for (int i = 0; i < clientBill.Recepits.Count; i++) { PdfPTable table2 = createLineTable(clientBill.Recepits[i]); doc.Add(table2); } doc.Close(); return(doc); }
private void Calculate(object obj) { List <string> Checkedlines = new List <string>(); foreach (var item in cbObjects) { if (item.IsSelected) { Checkedlines.Add(item.ObjectData.Number); } } YearAndMonth selectedDate = new YearAndMonth(SelectedYear, SelectedMonth); BillRequestModel billRequestModel = new BillRequestModel(currentClient.ID, Checkedlines, selectedDate); Tuple <object, HttpStatusCode> returnTuple1 = httpClient.PostRequest(ApiConfigs.CheckIfLineExistedRoute, billRequestModel); if (returnTuple1.Item2 == HttpStatusCode.OK) { if ((bool)returnTuple1.Item1) { Tuple <object, HttpStatusCode> returnTuple = httpClient.PostRequest(ApiConfigs.GetSpecficLinesBillRoute, billRequestModel); if (returnTuple.Item2 == HttpStatusCode.OK) { JObject jObject = new JObject(); jObject = (JObject)returnTuple.Item1; ClientBill clientBill = jObject.ToObject <ClientBill>(); BillWindow billWindow = new BillWindow(clientBill, selectedDate); billWindow.Show(); CloseThisWindow(); } } else { logger.Print("One or more of the selected lines didnt exist in the selected date"); } } else { logger.Print(returnTuple1.Item2.ToString()); } }
private PdfPTable createBillConstTable(ClientBill clientBill) { /////////////const data///////////////////// PdfPTable table = new PdfPTable(2); //table1.DefaultCell.Border = 0; table.WidthPercentage = 100; PdfPCell cell11 = new PdfPCell(); cell11.Colspan = 1; cell11.AddElement(new Paragraph("Client Name: " + clientBill.ClientName, new Font())); cell11.AddElement(new Paragraph("Date: " + clientBill.yearAndMonth.Month + "/" + clientBill.yearAndMonth.Year, new Font())); cell11.VerticalAlignment = Element.ALIGN_LEFT; PdfPCell cell12 = new PdfPCell(); cell12.AddElement(new Paragraph("Total Price: " + clientBill.TotalBill, new Font())); cell12.VerticalAlignment = Element.ALIGN_CENTER; table.AddCell(cell11); table.AddCell(cell12); return(table); }
public object Generate(ClientBill clientBill) { this.clientBill = clientBill; ExcelPackage excel = new ExcelPackage(); excel.Workbook.Worksheets.Add("Worksheet1"); var headerRow = new List <string[]>() { new string[] { "client name:", clientBill.ClientName, "Date:", clientBill.yearAndMonth.Month + "/" + clientBill.yearAndMonth.Month, "Total price:", clientBill.TotalBill.ToString() } }; // Determine the header range (e.g. A1:D1) string headerRange = "A1:" + Char.ConvertFromUtf32(headerRow[0].Length + 64) + "1"; // Target a worksheet var worksheet = excel.Workbook.Worksheets["Worksheet1"]; // Popular header row data worksheet.Cells[headerRange].LoadFromArrays(headerRow); for (int i = 0; i < clientBill.Recepits.Count; i++) { List <string[]> lineChunk = createLineChunk(clientBill.Recepits[i]); worksheet.Cells[3, 1 + (4 * i)].LoadFromArrays(lineChunk); } return(excel); }
public ActionResult ClientRegistration(Client client, int?ServiceId, int?ClientIdNumber, string ClientPassword, int?EmployeeId, int?ScheduleTimeId) { int er = 0; if (ServiceId == null) { ViewBag.ename = "Select Service Name"; er++; } if (ClientPassword == "") { er++; ViewBag.password = "******"; } if (EmployeeId == null) { er++; ViewBag.Employee = "Select Employee Name "; } if (ScheduleTimeId == null) { er++; ViewBag.ScheduleTime = "Select Schedule Name "; } bool isThisIdExist = db.Clients.ToList().Exists(a => a.ClientIdNumber == client.ClientIdNumber); //int a = Convert.ToInt32(ClientIdNumber); //var idnumber = db.Clients.Where(x => x.ClientId == a).FirstOrDefault(); if (isThisIdExist) { er++; ViewBag.idnumber = "This id is already here"; } bool isThisUsenameExist = db.Clients.ToList().Exists(a => a.ClientUserName == client.ClientUserName); if (isThisUsenameExist) { er++; ViewBag.username = "******"; } if (er > 0) { //idnumber = 0; ViewBag.ServiceId = new SelectList(db.Servicesses, "ServiceId", "ServiceName"); ViewBag.ScheduleTimeId = new SelectList(db.ScheduleTimes, "ScheduleTimeId", "ScheduleName"); ViewBag.EmployeeId = new SelectList(db.Employees, "EmployeeId", "EmployeeName"); return(View()); } else { if (ModelState.IsValid) { var id = db.Clients.Max(p => p.ClientIdNumber); client.ClientIdNumber = id + 1; db.Clients.Add(client); ClientServiceList list = new ClientServiceList(); list.ClientId = client.ClientId; list.ServiceId = Convert.ToInt32(ServiceId); list.Service_Status = true; db.ClientServiceLists.Add(list); ClientBill bill = new ClientBill(); bill.ClientId = client.ClientId; bill.BillMonth = client.ClientGymStart; bill.BillStatus = false; var serviceprice = db.Servicesses.Where(x => x.ServiceId == ServiceId).FirstOrDefault().ServieAmount; bill.BillAmount = Convert.ToInt16(serviceprice); bill.DueStatus = 0; db.ClientBills.Add(bill); Schedule schedule = new Schedule(); schedule.EmployeeId = Convert.ToInt32(EmployeeId); schedule.ScheduleTimeId = Convert.ToInt32(ScheduleTimeId); schedule.ClientId = client.ClientId; db.Schedules.Add(schedule); db.SaveChanges(); //ViewBag.Message = "Registration Sucessful"; TempData["Success"] = "Registration Successfully!"; // ViewBag.clientid = client.ClientId; return(RedirectToAction(actionName: "ClientRegistrationprint", routeValues: new { id = client.ClientId })); // return RedirectToAction("ClientInformation"); } } ViewBag.ServiceId = new SelectList(db.Servicesses, "ServiceId", "ServiceName"); return(View()); }
public ActionResult Manage([Bind(Include = "CBillID,ClientID,SiteID,Tdate,RetentionPerc,TaxPerc")] ClientBill cBill) { return(base.BaseSave <ClientBill>(cBill, cBill.CBillID > 0)); }
// [HttpPost] public ActionResult BillCreate(string button) { int ab = Convert.ToInt32(Session["id"]); int bc = Convert.ToInt32(Session["Designation"]); if (ab != 0 && bc == 1) { System.DateTime todaydate = new System.DateTime(System.DateTime.Today.Ticks); DateTime Current_date = Convert.ToDateTime(todaydate.ToString("dd/MM/yyyy")); //var billdate = db.Clients.Where(y => y.ClientGymStart == date).FirstOrDefault(); var clientinfo = db.Clients.ToList(); List <ClientBill> list = new List <ClientBill>(); ViewBag.list = list; //client = new Client(); // TimeSpan ts = new TimeSpan(); foreach (var gymstart in clientinfo) { //DateTime currentdays = //TimeSpan ts = new TimeSpan(); // ts = date.Subtract(client.ClientGymStart); var gymstartdat = gymstart.ClientGymStart.ToShortDateString(); int clientid = gymstart.ClientId; string clientname = gymstart.ClietName; var search_active_service = db.ClientServiceLists.Where(a => a.ClientId == clientid).FirstOrDefault(); if (search_active_service == null) { continue; } else { DateTime day = Convert.ToDateTime(gymstartdat); int i = Convert.ToInt32((Current_date - day).TotalDays); int service_id = search_active_service.ServiceId; var service = db.Servicesses.Where(b => b.ServiceId == service_id).FirstOrDefault(); int service_price = service.ServieAmount; int service_day = service.ServiceDay; var Last_client_bill = db.ClientBills.Where(c => c.ClientId == clientid).OrderByDescending(d => d.BillMonth).FirstOrDefault(); ClientBill clientBill = new ClientBill(); if (Last_client_bill == null) { int totaldays = i / service_day; if (totaldays == 1) { clientBill.ClientId = clientid; clientBill.BillAmount = service_price; clientBill.BillStatus = false; clientBill.DueStatus = 0; clientBill.BillMonth = Current_date; db.ClientBills.Add(clientBill); db.SaveChanges(); list.Add(clientBill); } } else { DateTime last_timeBill_date = Convert.ToDateTime(Last_client_bill.BillMonth); int totaldays2 = Convert.ToInt32((Current_date - last_timeBill_date).TotalDays); int j = totaldays2 / service_day; if (j == 1) { clientBill.ClientId = clientid; clientBill.BillAmount = service_price; clientBill.BillStatus = false; clientBill.DueStatus = 0; clientBill.BillMonth = Current_date; db.ClientBills.Add(clientBill); db.SaveChanges(); list.Add(clientBill); } } } } //return RedirectToAction("NewBill","Account"); return(View()); } else { FormsAuthentication.SignOut(); return(RedirectToAction("Login", "Login")); } }
public ActionResult BillPament([Bind(Include = "ClientBillId,ClientId,BillMonth,BillAmount,BillStatus, DueStatus")] ClientBill clientBill, int?payment) { int bill = Convert.ToInt32(clientBill.BillAmount); int due = Convert.ToInt32(clientBill.DueStatus); int paymentBill = Convert.ToInt32(payment); int er = 0; if (paymentBill == 0) { er++; ViewBag.paymentmessage = "Insert Payment Amount"; } if (er > 0) { return(View(clientBill)); } // int presentstatus = bill - paymentBill; // clientBill.DueStatus = presentstatus; int id = Convert.ToInt32(clientBill.ClientBillId); int i; var status = db.ClientBills.Where(y => y.ClientBillId == id).FirstOrDefault(); if (status.BillStatus == false) { if (due == 0) { if (bill >= paymentBill) { i = bill - paymentBill; if (i == 0) { due = 0; clientBill.DueStatus = due; clientBill.BillStatus = true; } else { due = i; clientBill.DueStatus = due; clientBill.BillStatus = false; } } else { ViewBag.error1 = "Payment bill must less than Current bill"; return(View(clientBill)); } } else { //Due payment if (due >= paymentBill) { i = due - paymentBill; if (i == 0) { due = 0; clientBill.DueStatus = due; clientBill.BillStatus = true; } else { due = i; clientBill.DueStatus = due; clientBill.BillStatus = false; } } else { ViewBag.error2 = "Payment bill must less than Due Status bill"; return(View(clientBill)); } } } else { ViewBag.Message = "This bill is already payment"; return(View(clientBill)); } ClientBillTransection transection = new ClientBillTransection(); transection.ClientBillId = clientBill.ClientBillId; transection.TransectionDate = DateTime.Now; transection.BillMonth = clientBill.BillMonth; transection.Amount = paymentBill; transection.BillStatus = clientBill.BillStatus; var a = Convert.ToInt32(db.ClientBillTransections.ToList().Max(e => Convert.ToInt64(e.InvoiceNumber))); int h = a + 1; transection.InvoiceNumber = Convert.ToString(h); var id2 = db.ClientBillTransections.Where(x => x.ClientBillId == clientBill.ClientBillId && x.BillMonth == clientBill.BillMonth && x.BillStatus == false); if (id2 == null) { ViewBag.Message = "This bill is already payment"; return(View(clientBill)); } else { db.ClientBillTransections.Add(transection); db.Entry(status).State = EntityState.Detached; db.Entry(clientBill).State = EntityState.Modified; db.SaveChanges(); ViewBag.transectionid = transection.TransectionId; return(RedirectToAction(actionName: "PrintTransectionInfo", routeValues: new { id = transection.TransectionId })); } }