public ActionResult UpdateClientsPayment(ClientsPayment clientspayment) { try { using (ArchitectureEntitiesModel entities = new ArchitectureEntitiesModel()) { var getclientpayment = ObjEntities.ClientsPayments.Where(e => e.Client == clientspayment.Client).FirstOrDefault(); var getclient = ObjEntities.ClientsViews.Where(e => e.Id == clientspayment.Client).FirstOrDefault(); if (getclientpayment != null) { if (Convert.ToInt32(clientspayment.Paid_Amount) <= Convert.ToInt32(getclient.Amount)) { int Due = Convert.ToInt32(getclient.Amount) - Convert.ToInt32(clientspayment.Paid_Amount); getclientpayment.Paid_Amount = clientspayment.Paid_Amount; getclientpayment.Due_Amount = Due.ToString(); //getclientpayment.EntryDate = Convert.ToDateTime(clientspayment.Month); entities.SaveChanges(); TempData["Success"] = "Data Updated successfully"; } else { TempData["Warning"] = "Paid Amount Should be less than due amount!"; return(RedirectToAction("EditClientsPayment")); } } //if (long.Parse(clientspayment.Paid_Amount.ToString()) <= long.Parse(getclientpayment.Due_Amount.ToString())) //{ // ClientsPayment updatedclientspayment = (from c in entities.ClientsPayments // where c.Id == clientspayment.Id // select c).FirstOrDefault(); // updatedclientspayment.Client = clientspayment.Client; // updatedclientspayment.Month = clientspayment.Month; // updatedclientspayment.Paid_Amount = Convert.ToString(long.Parse((updatedclientspayment.Paid_Amount)) + long.Parse((clientspayment.Paid_Amount))); // updatedclientspayment.Due_Amount = Convert.ToString(long.Parse((getclient.Amount)) - long.Parse((updatedclientspayment.Paid_Amount))); // updatedclientspayment.Month = clientspayment.Month; // updatedclientspayment.EntryDate = DateTime.Now; // entities.SaveChanges(); // TempData["Success"] = "Successfully updated"; //} //else //{ // TempData["Warning"] = "Paid Amount Should be less than due amount!"; // return RedirectToAction("EditClientsPayment"); //} } } catch (Exception ex) { } return(RedirectToAction("AddPayments")); }
public ActionResult EditClientsPayment(int id) { var clientspayment = new ClientsPayment(); try { clientspayment = ObjEntities.ClientsPayments.Where(x => x.Id == id).FirstOrDefault(); if (clientspayment != null) { ViewBag.Id = id; var Client = new SelectList(ObjEntities.ClientsViews.ToList(), "Id", "Name"); var Month = new SelectList(ObjEntities.tblMonths.ToList(), "Id", "Month"); ViewData["ClientPayment"] = Client; ViewData["MonthData"] = Month; } ViewBag.Id = id; TempData["Heading"] = 4; } catch (Exception ex) { } return(View(clientspayment)); }
public ActionResult AddPayments(ClientsPayment clientpayment) { try { if (ModelState.IsValid) { //UpdateClientsPayment(clientpayment.Paid_Amount,clientpayment.Client); using (ArchitectureEntitiesModel ObjEntities = new ArchitectureEntitiesModel()) { var getclient = ObjEntities.ClientsViews.Where(e => e.Id == clientpayment.Client).FirstOrDefault(); //My Code Saad Bhatti var chkData = ObjEntities.ClientsPayments.Where(c => c.Client == clientpayment.Client && c.EntryDate.Year == clientpayment.Month.Year && c.EntryDate.Month == clientpayment.Month.Month).FirstOrDefault(); if (chkData != null) { if (Convert.ToInt32(getclient.Amount) >= Convert.ToInt32(clientpayment.Paid_Amount) + Convert.ToInt32(chkData.Paid_Amount)) { if (long.Parse(clientpayment.Paid_Amount.ToString()) <= long.Parse(getclient.Amount.ToString())) { int TotalAmount = Convert.ToInt32(getclient.Amount); int Due = Convert.ToInt32(TotalAmount) - (Convert.ToInt32(clientpayment.Paid_Amount) + (Convert.ToInt32(chkData.Paid_Amount))); int Paid = Convert.ToInt32(chkData.Paid_Amount) + Convert.ToInt32(clientpayment.Paid_Amount); chkData.Paid_Amount = Paid.ToString(); chkData.Due_Amount = Due.ToString(); ObjEntities.SaveChanges(); //clientpayment.EntryDate = DateTime.Now; //chkData.Due_Amount = Due.ToString(); //ObjEntities.ClientsPayments.Add(clientpayment); //ObjEntities.SaveChanges(); //int id1 = 0; //id1 = clientpayment.Id; //if (id1 > 0) //{ // var getmonth = ObjEntities.tblMonth.Where(e => e.Id == clientpayment.Month).FirstOrDefault(); TempData["Success"] = Session["UserName"] + " " + "Added" + " " + clientpayment.Paid_Amount + " " + "for" + " " + getclient.Name + " " + "for" + " " + "Month" + "-" + clientpayment.Month.Month; tblNotification tblnotification = new tblNotification(); tblnotification.NotificationMessage = Session["UserName"] + " " + "Added" + " " + clientpayment.Paid_Amount + " " + "for" + " " + getclient.Name + " " + "for" + " " + "Month" + "-" + clientpayment.Month.Month; tblnotification.IsShow = 0; ObjEntities.tblNotifications.Add(tblnotification); ObjEntities.SaveChanges(); //} } else { TempData["Warning"] = "Paid Amount Should be less than due amount!"; } } else { TempData["Warning"] = "Paid Amount Should be less than due amount!"; } } else { int id = 0; clientpayment.EntryDate = Convert.ToDateTime(clientpayment.Month); clientpayment.Due_Amount = Convert.ToString(long.Parse((getclient.Amount)) - long.Parse((clientpayment.Paid_Amount))); ObjEntities.ClientsPayments.Add(clientpayment); ObjEntities.SaveChanges(); id = clientpayment.Id; if (id > 0) { // var getmonth = ObjEntities.tblMonth.Where(e => e.Id == clientpayment.Month).FirstOrDefault(); TempData["Success"] = Session["UserName"] + " " + "Added" + " " + clientpayment.Paid_Amount + "Payment" + " " + "for" + " " + getclient.Name + " " + "for" + " " + "Month" + "-" + clientpayment.Month; tblNotification tblnotification = new tblNotification(); tblnotification.NotificationMessage = Session["UserName"] + " " + "Added" + " " + clientpayment.Paid_Amount + " " + "for" + " " + getclient.Name + " " + "for" + " " + "Month" + "-" + clientpayment.Month; tblnotification.IsShow = 0; ObjEntities.tblNotifications.Add(tblnotification); ObjEntities.SaveChanges(); } } } } //var Clients = new SelectList(ObjEntities.ClientsView.ToList(), "Id", "Name"); //ViewData["ClientPayment"] = Clients; } catch (Exception ex) { } return(RedirectToAction("AddPayments")); }