public ActionResult AddCustomerCredit(AddCreditAmountViewModel acavm) { if (Session["UserId"] != null) { int UserId = int.Parse(Session["UserId"].ToString()); acavm.UserId = UserId; if (acavm.Amount != 0.0) { if (acavm.customerId != 0) { PragatiEntities db = new PragatiEntities(); CustomerPayableAmount cpa = db.CustomerPayableAmounts.Where(a => a.CustomerId == acavm.customerId && a.UserId == acavm.UserId).FirstOrDefault(); if (cpa == null) { CustomerPayableAmount cpab = new CustomerPayableAmount(); cpab.CustomerId = acavm.customerId; cpab.UserId = acavm.UserId; cpab.Amount = (float)acavm.Amount; db.CustomerPayableAmounts.Add(cpab); try { db.SaveChanges(); } catch { @ViewBag.Message = "Error Occured While adding credit into Customer Account...Please try again"; return View(); } return RedirectToAction("CustomerPayment"); } else { cpa.Amount = cpa.Amount + (float)acavm.Amount; cpa.CustomerId = acavm.customerId; cpa.UserId = acavm.UserId; try { db.SaveChanges(); } catch { @ViewBag.Message = "Error Occured While adding credit into Customer Account...Please try again"; return View(); } return RedirectToAction("CustomerPayment"); } //if (num == 1) //{ // return RedirectToAction("CustomerPayment"); //} //else //{ // @ViewBag.Message = "Error Occured While adding credit into Customer Account...Please try again"; // return View(); //} } else { @ViewBag.Message = "Please Select Customer"; return View(); } } else { @ViewBag.Message = "Please Enter Valid Amount"; return View(); } } else { return RedirectToAction("LogIn"); } }
public ActionResult EditMaterial(EditMaterialViewModel emvm, HttpPostedFileBase MaterialImage) { if (Session["UserId"] != null) { PragatiEntities db = new PragatiEntities(); string text = MaterialImage.FileName; text = text.Substring(text.LastIndexOf(".")); if (text == ".jpg" || text == ".jpeg" || text == ".png" || text == ".JPG" || text == ".JPEG" || text == ".PNG") { string text2 = Path.GetFileName(MaterialImage.FileName); string fileName = MaterialImage.FileName; text2 = text2.Substring(0, text2.LastIndexOf(".") - 1); text2 = text2 + DateTime.Now.Ticks.ToString() + text; string filename = Path.Combine(Server.MapPath("~/MaterialImage/"), text2); MaterialImage.SaveAs(filename); string materialImagePath = "~/MaterialImage/" + text2; emvm.MaterialImagePath = materialImagePath; AllMaterial allMaterial = db.AllMaterials.Where(a => a.MaterialId == emvm.MaterialId).FirstOrDefault(); allMaterial.MaterialCode = emvm.MaterialCode; allMaterial.Datetime = new DateTime?(DateTime.Now); allMaterial.MaterialId = emvm.MaterialId; if (emvm.MaterialImage != null) { allMaterial.MaterialImagePath = emvm.MaterialImagePath; } try { db.SaveChanges(); ViewBag.success = "Material Updated Successfully"; return View(emvm); } catch { ViewBag.Message = "Error occured Please try Again"; return View(emvm); } } else { ViewBag.Message = "Invalid Image."; return View(emvm); } } else { return RedirectToAction("LogIn"); } }
public ActionResult MonthlyChalan(int CustomerId, int UserId, string Fromdate, string ToDate) { if (Session["UserId"] != null) { PragatiEntities pragatiEntities = new PragatiEntities(); MonthlyInvoiceViewModel monthlyInvoiceViewModel = new MonthlyInvoiceViewModel(); List<ChalansViewModel> list = new List<ChalansViewModel>(); List<MonthlyInvoice_Down_ViewModel> lst_sub_down = new List<MonthlyInvoice_Down_ViewModel>(); List<MonthlyInvoice_Down_ReturnViewModel> lst_sub_return_down = new List<MonthlyInvoice_Down_ReturnViewModel>(); Customer customer = ( from a in pragatiEntities.Customers where a.CustomerId == CustomerId select a).FirstOrDefault<Customer>(); DateTime t = DateTime.Parse(Fromdate); DateTime t2 = DateTime.Parse(ToDate); monthlyInvoiceViewModel.CustomerName = customer.CustomerName + " " + customer.CustomerSurname; monthlyInvoiceViewModel.CustomerFirmName = customer.CustomerFirmname; monthlyInvoiceViewModel.FromDate = t.ToString("dd/MM/yyyy"); monthlyInvoiceViewModel.ToDate = t2.ToString("dd/MM/yyyy"); List<Invoice> list2 = ( from a in pragatiEntities.Invoices where a.CustomerId == (int?)CustomerId && a.UserId == (int?)UserId select a).ToList<Invoice>(); float num = 0f; foreach (Invoice current in list2) { DateTime dateTime = DateTime.Parse(current.DateTime); if (t <= dateTime && dateTime <= t2) { ChalansViewModel chalansViewModel = new ChalansViewModel(); chalansViewModel.ChalanId = current.InvoiceId; chalansViewModel.Date = DateTime.Parse(current.DateTime).ToString("dd/MM/yyyy"); chalansViewModel.Amount = current.TotalAmount.Value; num += current.TotalAmount.Value; foreach (var current_sub in current.Sales) { var submatid = (from m in pragatiEntities.Stocks where m.StockId == (int)current_sub.StockId select m).FirstOrDefault(); if (current_sub.ReturnPiece == "No") { // foreach (var item in lst_sub_down) // { MonthlyInvoice_Down_ViewModel sub_down = new MonthlyInvoice_Down_ViewModel(); var subname = (from m in pragatiEntities.SubMaterialTypes where m.SubMaterialTypeId == submatid.SubMaterialTypeId select m).FirstOrDefault(); var mainname = (from m in pragatiEntities.MaterialTypes where m.MaterialTypeId == submatid.MaterialTypeId select m).FirstOrDefault(); if (subname != null) { // subname.Name = ""; //total number of thread based on item if (lst_sub_down.Count == 0) { sub_down.Matname = mainname.MaterialName + "-" + subname.Name; if (current_sub.Nos_Of_Piece != 0) { sub_down.Piece = (int)current_sub.Nos_Of_Piece; lst_sub_down.Add(sub_down); } } else { foreach (var itemss in lst_sub_down) { if (itemss.Matname == mainname.MaterialName + "-" + subname.Name) { if (current_sub.Nos_Of_Piece != 0) { itemss.Piece = itemss.Piece + (int)current_sub.Nos_Of_Piece; //sub_down.Piece += (int)current_sub.Nos_Of_Piece; } } else { sub_down.Matname = mainname.MaterialName + "-" + subname.Name; if (current_sub.Nos_Of_Piece != 0) { sub_down.Piece = (int)current_sub.Nos_Of_Piece; lst_sub_down.Add(sub_down); } } } } } // } } else if (current_sub.ReturnPiece == "Yes") { MonthlyInvoice_Down_ReturnViewModel sub_returndown = new MonthlyInvoice_Down_ReturnViewModel(); var subname = (from m in pragatiEntities.SubMaterialTypes where m.SubMaterialTypeId == submatid.SubMaterialTypeId select m).FirstOrDefault(); var mainname = (from m in pragatiEntities.MaterialTypes where m.MaterialTypeId == submatid.MaterialTypeId select m).FirstOrDefault(); if (subname != null) { // subname.Name = ""; //total number of thread based on item if (lst_sub_return_down.Count == 0) { sub_returndown.ReturnMatname = mainname.MaterialName + "-" + subname.Name; if (current_sub.Nos_Of_Piece != 0) { sub_returndown.ReturnPiece = (int)current_sub.Nos_Of_Piece; lst_sub_return_down.Add(sub_returndown); } } else { foreach (var itemss in lst_sub_return_down) { if (itemss.ReturnMatname == mainname.MaterialName + "-" + subname.Name) { if (current_sub.Nos_Of_Piece != 0) { itemss.ReturnPiece = itemss.ReturnPiece + (int)current_sub.Nos_Of_Piece; //sub_down.Piece += (int)current_sub.Nos_Of_Piece; } } else { sub_returndown.ReturnMatname = mainname.MaterialName + "-" + subname.Name; if (current_sub.Nos_Of_Piece != 0) { sub_returndown.ReturnPiece = (int)current_sub.Nos_Of_Piece; lst_sub_return_down.Add(sub_returndown); } } } } } } } list.Add(chalansViewModel); } } monthlyInvoiceViewModel.TotalAmount = num; monthlyInvoiceViewModel.lstChalans = list; monthlyInvoiceViewModel.lst_totaldownItems = lst_sub_down; monthlyInvoiceViewModel.lst_totalReturndownItems = lst_sub_return_down; MonthlyInvoice monthlyInvoice = ( from a in pragatiEntities.MonthlyInvoices where a.CustomerId == (int?)CustomerId && a.UserId == (int?)UserId && a.FromDateTime == Fromdate && a.ToDateTime == ToDate select a).FirstOrDefault<MonthlyInvoice>(); if (monthlyInvoice == null) { MonthlyInvoice monthlyInvoice2 = new MonthlyInvoice(); monthlyInvoice2.CustomerId = new int?(CustomerId); monthlyInvoice2.FromDateTime = Fromdate; monthlyInvoice2.ToDateTime = ToDate; monthlyInvoice2.TotalAmount = new float?(num); monthlyInvoice2.UserId = new int?(UserId); pragatiEntities.MonthlyInvoices.Add(monthlyInvoice2); pragatiEntities.SaveChanges(); } MonthlyInvoice monthlyInvoice3 = ( from a in pragatiEntities.MonthlyInvoices where a.CustomerId == (int?)CustomerId && a.UserId == (int?)UserId && a.FromDateTime == Fromdate && a.ToDateTime == ToDate select a).FirstOrDefault<MonthlyInvoice>(); monthlyInvoiceViewModel.BillId = monthlyInvoice3.MonthlyInvoiceId; return View(monthlyInvoiceViewModel); } else { return RedirectToAction("LogIn"); } }
public ActionResult DeleteMaterial(int id) { if (Session["UserId"] != null) { PragatiEntities pragatiEntities = new PragatiEntities(); Stock stock = ( from a in pragatiEntities.Stocks where a.MaterialId == (int?)id select a).FirstOrDefault<Stock>(); if (stock == null) { AllMaterial allMaterial = ( from a in pragatiEntities.AllMaterials where a.MaterialId == id select a).FirstOrDefault<AllMaterial>(); string path = Server.MapPath(allMaterial.MaterialImagePath); // File.Delete(path); //try //{ // FileInfo fifo = new FileInfo(path); // fifo.Delete(); //} pragatiEntities.AllMaterials.Remove(allMaterial); try { pragatiEntities.SaveChanges(); return RedirectToAction("ViewMaterials", new { id = 1 }); } catch { return RedirectToAction("ViewMaterials", new { id = -1 }); } } return RedirectToAction("ViewMaterials", new { id = -2 }); } else { return RedirectToAction("LogIn"); } }