public ActionResult ChangeSaleman(assignNewspaperVM serviceAssign) { if (db.ServiceAssign.Any(m => m.CustomerId == serviceAssign.CustomerId)) { foreach (var item in serviceAssign.NewspaperIds) { ServiceAssign objService = db.ServiceAssign.FirstOrDefault(m => m.CustomerId == serviceAssign.CustomerId && m.NewspaperId == item); objService.SalesManId = serviceAssign.SalesManId; log.AddActivity("Service assign to customer successfully"); db.SaveChanges(); } return(RedirectToAction("Index")); } else { ModelState.AddModelError("", "Newspaper Already Assigned."); serviceAssign.Newspapers = new SelectList(db.Service, "Id", "NewsPaperName"); serviceAssign.Salesmans = new SelectList(db.SalesMan, "Id", "FullName"); return(View(serviceAssign)); } }
public ActionResult DeleteConfirmed(int id) { ServiceAssign serviceAssign = db.ServiceAssign.Find(id); db.ServiceAssign.Remove(serviceAssign); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Id,PaperDispatchDate,EndedDate,NepaliDate,CreatedBy,UpdatedBy,CreatedDate,UpdatedDate,status,CustomerId,NewspaperId")] ServiceAssign serviceAssign) { if (ModelState.IsValid) { db.Entry(serviceAssign).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(serviceAssign)); }
public ActionResult EditEndedDate(DateTime PaperDispatchDate, DateTime EndedDate, bool payment, int Quantity, int id, DateTime PaymentDate) { ServiceAssign objserviceAssign = db.ServiceAssign.Find(id); objserviceAssign.PaperDispatchDate = PaperDispatchDate; objserviceAssign.EndedDate = EndedDate; objserviceAssign.UpdatedDate = PaymentDate; objserviceAssign.Quantity = Quantity; objserviceAssign.PaymentType = payment; db.SaveChanges(); TempData["message"] = "EndedDate Edited Sucessfully"; log.AddActivity("EndedDate is changed"); return(RedirectToAction("Index", "Counter")); }
// GET: ServiceAssigns/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ServiceAssign serviceAssign = db.ServiceAssign.Find(id); if (serviceAssign == null) { return(HttpNotFound()); } return(View(serviceAssign)); }
public ActionResult Create(assignNewspaperVM serviceAssign) { if (!db.ServiceAssign.Any(m => m.NewspaperId == serviceAssign.NewspaperId && m.CustomerId == serviceAssign.CustomerId)) { if (db.Service.Any(m => m.Id == serviceAssign.NewspaperId && m.TimeBase == "मासिक") && serviceAssign.Duration == 365) { serviceAssign.EndedDate = serviceAssign.PaperDispatchDate.AddDays(serviceAssign.Duration - 30); } else { serviceAssign.EndedDate = serviceAssign.PaperDispatchDate.AddDays(serviceAssign.Duration); } ServiceAssign objService = new ServiceAssign(); objService.NepaliDate = serviceAssign.NepaliDate; objService.NewspaperId = serviceAssign.NewspaperId; objService.SalesManId = serviceAssign.SalesManId; objService.PaperDispatchDate = Convert.ToDateTime(serviceAssign.PaperDispatchDate.ToShortDateString()); objService.status = true; objService.UpdatedBy = serviceAssign.UpdatedBy; objService.UpdatedDate = serviceAssign.UpdatedDate; objService.CreatedBy = serviceAssign.CreatedBy; objService.CreatedDate = serviceAssign.CreatedDate; objService.CustomerId = serviceAssign.CustomerId; objService.Quantity = serviceAssign.Quantity; objService.EndedDate = Convert.ToDateTime(serviceAssign.EndedDate.ToShortDateString()); db.ServiceAssign.Add(objService); log.AddActivity("Service assign to customer successfully"); db.SaveChanges(); return(RedirectToAction("Index")); } else { ModelState.AddModelError("", "Newspaper Already Assigned."); serviceAssign.Newspapers = new SelectList(db.Service, "Id", "NewsPaperName"); serviceAssign.Salesmans = new SelectList(db.SalesMan, "Id", "FullName"); return(View(serviceAssign)); } }
public JsonResult CheckDate(int id) { try { ServiceAssign serviceAssigned = db.ServiceAssign.Find(id); if ((serviceAssigned.BillNo != null)) { if (serviceAssigned.EndedDate > DateTime.Now) { return(Json("true")); } } return(Json("false")); } catch { return(Json("false")); } }
public ActionResult CustomerActivate(string BillNo, string PaymentDate, string Duration, string NepaliDate1, DateTime PaperDispatchDate, string Nepalidate, string PaymentType, string BankName, string ACNumber, decimal Amount, bool payment, decimal Discount, int id) { ServiceAssign objserviceAssign = db.ServiceAssign.Find(id); //int quant = objserviceAssign.Quantity; //if (objserviceAssign.BillNo != null && objserviceAssign.EndedDate < PaperDispatchDate) //{ objserviceAssign.Duration = Duration; //} objserviceAssign.NepaliDate = NepaliDate1; objserviceAssign.PaperDispatchDate = PaperDispatchDate; objserviceAssign.Amount = Amount; objserviceAssign.Discount = Discount; decimal AWithoutDis = /* quant **/ Amount; objserviceAssign.DiscountAmount = /*objserviceAssign.Quantity**/ AWithoutDis * (Discount / 100); objserviceAssign.GrandTotal = AWithoutDis - objserviceAssign.DiscountAmount; objserviceAssign.BillNo = BillNo; objserviceAssign.PaymentType = payment; //var date = DateTime.Now.ToShortDateString(); //objserviceAssign.UpdatedDate = Convert.ToDateTime(date); objserviceAssign.UpdatedDate = Convert.ToDateTime(PaymentDate); if (objserviceAssign.status) { objserviceAssign.EndedDate = objserviceAssign.PaperDispatchDate.AddDays(Convert.ToInt32(Duration)); objserviceAssign.status = false; } else { if (objserviceAssign.EndedDate.Date > DateTime.Now.Date) { objserviceAssign.EndedDate = objserviceAssign.EndedDate.AddDays(Convert.ToInt32(Duration)); } else if (objserviceAssign.EndedDate.Date < DateTime.Now.Date) { objserviceAssign.EndedDate = objserviceAssign.PaperDispatchDate.AddDays(Convert.ToInt32(Duration)); } } db.SaveChanges(); Account objAccount = new Account(); objAccount.Amount = objserviceAssign.GrandTotal; objAccount.Paymentdate = Convert.ToDateTime(PaymentDate); objAccount.Nepalidate = Nepalidate; objAccount.BankName = BankName; objAccount.BankAcc = ACNumber; objAccount.DiscountAmount = objserviceAssign.DiscountAmount; objAccount.CustomerId = objserviceAssign.CustomerId; objAccount.NewspaperId = objserviceAssign.NewspaperId; objAccount.CreatedBy = "counter"; objAccount.CreatedDate = DateTime.Now; objAccount.UpdateDate = DateTime.Now; objAccount.UpdatedBy = "counter"; objAccount.fiscalyear = db.FiscalYear.FirstOrDefault(m => m.Status == true); objAccount.FiscalYear = db.FiscalYear.FirstOrDefault(m => m.Status == true).NepYear; objAccount.BillNo = Convert.ToInt32(BillNo); objAccount.Payoption = PaymentType; db.Account.Add(objAccount); db.SaveChanges(); log.AddActivity("Customer Successfully activated"); string accId = db.Account.OrderByDescending(m => m.Id).FirstOrDefault().Id.ToString(); // return ReportCounter(BillNo.ToString()); return(RedirectToAction("ReportCounter", "Counter", new { BillNo = accId }));// }