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 }));//
}
