public ActionResult DailyChalan(int CustomerId, int UserId, int ChalanId) { //HomeController.<>c__DisplayClass24 <>c__DisplayClass = new HomeController.<>c__DisplayClass24(); //<>c__DisplayClass.CustomerId = CustomerId; //<>c__DisplayClass.UserId = UserId; //<>c__DisplayClass.ChalanId = ChalanId; if (Session["UserId"] != null) { //HomeController.<>c__DisplayClass26 <>c__DisplayClass2 = new HomeController.<>c__DisplayClass26(); //<>c__DisplayClass2.CS$<>8__locals25 = <>c__DisplayClass; int num = 0; PragatiEntities pragatiEntities = new PragatiEntities(); ChalanViewModel chalanViewModel = new ChalanViewModel(); var invcdata = ( from a in pragatiEntities.Invoices where a.CustomerId == (int?)CustomerId && a.UserId == (int?)UserId && a.InvoiceId == ChalanId select a).FirstOrDefault<Invoice>(); Customer customer = ( from a in pragatiEntities.Customers where a.CustomerId == CustomerId select a).FirstOrDefault<Customer>(); chalanViewModel.ChalanId = invcdata.InvoiceId; chalanViewModel.CustomerName = customer.CustomerName + " " + customer.CustomerSurname; chalanViewModel.CustomerFirmName = customer.CustomerFirmname; chalanViewModel.Date = DateTime.Parse(invcdata.DateTime).ToString("dd/MM/yyyy"); chalanViewModel.TotalAmount = invcdata.TotalAmount.Value; List<Sale> list = ( from a in pragatiEntities.Sales where a.CustomerId == (int?)CustomerId && a.UserId == (int?)UserId && a.CreatedDateTime == invcdata.DateTime select a).ToList<Sale>(); List<ItemsViewModel> list2 = new List<ItemsViewModel>(); bool flag = false; bool flag2 = false; bool flag3 = false; bool flag4 = false; string text = ""; string text2 = ""; string text3 = ""; float num2 = 0f; float num3 = 0f; //using (List<Sale>.Enumerator enumerator = list.GetEnumerator()) //{ //while (enumerator.MoveNext()) //{ foreach (var item in list) { //HomeController.<>c__DisplayClass28 <>c__DisplayClass3 = new HomeController.<>c__DisplayClass28(); //<>c__DisplayClass3.CS$<>8__locals27 = <>c__DisplayClass2; //<>c__DisplayClass3.CS$<>8__locals25 = <>c__DisplayClass; //<>c__DisplayClass3.item = enumerator.Current; num++; ItemsViewModel itemsViewModel = new ItemsViewModel(); flag4 = false; Stock stockdata = ( from a in pragatiEntities.Stocks where (int?)a.StockId == item.StockId && a.MaterialId == item.MaterialId && a.UserId == item.UserId select a).FirstOrDefault<Stock>(); AllMaterial allMaterial = ( from a in pragatiEntities.AllMaterials where (int?)a.MaterialId == item.MaterialId select a).FirstOrDefault<AllMaterial>(); MaterialType materialType = ( from a in pragatiEntities.MaterialTypes where (int?)a.MaterialTypeId == stockdata.MaterialTypeId select a).FirstOrDefault<MaterialType>(); if (stockdata.MaterialTypeId == 1 || stockdata.MaterialTypeId == 4 || stockdata.MaterialTypeId == 2) { SubMaterialType subMaterialType = ( from a in pragatiEntities.SubMaterialTypes where (int?)a.SubMaterialTypeId == stockdata.SubMaterialTypeId && a.MaterialTypeId == stockdata.MaterialTypeId select a).FirstOrDefault<SubMaterialType>(); foreach (ItemsViewModel current in list2) { if (current.ItemName == materialType.MaterialName.Substring(0, 1) + "-" + subMaterialType.Name.Substring(0, 3)) { itemsViewModel = current; flag = true; break; } flag = false; text = ""; } if (!flag) { flag4 = true; itemsViewModel.ItemName = materialType.MaterialName.Substring(0, 1) + "-" + subMaterialType.Name.Substring(0, 3); itemsViewModel.Rate = subMaterialType.Price.Value; itemsViewModel.Amount = item.TotalAmount.Value; itemsViewModel.SerailNo = num; } float num4 = subMaterialType.Price.Value * (float)item.Nos_Of_Piece.Value; itemsViewModel.totAmount += num4; string text4 = text; text = string.Concat(new string[] { text4, allMaterial.MaterialCode, "(", item.Nos_Of_Piece.ToString(), ")," }); float num5 = (float)item.Nos_Of_Piece.Value; itemsViewModel.totpiece += num5; ItemsViewModel expr_980 = itemsViewModel; expr_980.lstsubitems += text; flag = false; text = ""; } else { if (stockdata.MaterialTypeId == 3) { Sub_Kasab sub_Kasab = ( from a in pragatiEntities.Sub_Kasab where (int?)a.Sub_KasabId == stockdata.Sub_KasabId && a.MaterialTypeId == stockdata.MaterialTypeId select a).FirstOrDefault<Sub_Kasab>(); foreach (ItemsViewModel current in list2) { if (current.ItemName == materialType.MaterialName.Substring(0, 1) + "-" + sub_Kasab.Name.Substring(0, 3)) { itemsViewModel = current; flag2 = true; break; } flag2 = false; text = ""; } if (!flag2) { flag4 = true; itemsViewModel.ItemName = materialType.MaterialName.Substring(0, 1) + "-" + sub_Kasab.Name.Substring(0, 3); itemsViewModel.Rate = sub_Kasab.Price.Value; itemsViewModel.Amount = item.TotalAmount.Value; itemsViewModel.SerailNo = num; } float num6 = sub_Kasab.Price.Value * (float)item.Nos_Of_Piece.Value; itemsViewModel.totAmount += num6; string text4 = text2; text2 = string.Concat(new string[] { text4, allMaterial.MaterialCode, "(", item.Nos_Of_Piece.ToString(), ")," }); float num7 = (float)item.Nos_Of_Piece.Value; itemsViewModel.totpiece += num7; ItemsViewModel expr_C7D = itemsViewModel; expr_C7D.lstsubitems += text2; flag2 = false; text2 = ""; } else { if (stockdata.MaterialTypeId == 5 || stockdata.MaterialTypeId == 6 || stockdata.MaterialTypeId == 7) { foreach (ItemsViewModel current in list2) { if (current.ItemName == materialType.MaterialName.Substring(0, 1)) { itemsViewModel = current; flag3 = true; break; } flag3 = false; } float? tot_Weight_in_Gram_; if (!flag3) { flag4 = true; itemsViewModel.ItemName = materialType.MaterialName.Substring(0, 1); itemsViewModel.Rate = (float)allMaterial.Price.Value; itemsViewModel.Amount = item.TotalAmount.Value; ItemsViewModel arg_E18_0 = itemsViewModel; tot_Weight_in_Gram_ = item.Tot_Weight_in_Gram_; arg_E18_0.Piece = ((tot_Weight_in_Gram_.HasValue ? new float?(tot_Weight_in_Gram_.GetValueOrDefault() / 1000f) : null) + " Kg ").ToString(); itemsViewModel.SerailNo = num; } object obj = text3; object[] array = new object[5]; array[0] = obj; array[1] = allMaterial.MaterialCode; array[2] = "("; object[] arg_E8D_0 = array; int arg_E8D_1 = 3; tot_Weight_in_Gram_ = item.Tot_Weight_in_Gram_; arg_E8D_0[arg_E8D_1] = (tot_Weight_in_Gram_.HasValue ? new float?(tot_Weight_in_Gram_.GetValueOrDefault() / 1000f) : null); array[4] = "),"; text3 = string.Concat(array); itemsViewModel.lstsubitems = text3; num2 += item.Tot_Weight_in_Gram_.Value / 1000f; itemsViewModel.totpiece = num2; num3 += item.TotalAmount.Value; itemsViewModel.totAmount = num3; flag3 = false; text3 = ""; num2 = 0f; num3 = 0f; } } } if (flag4) { list2.Add(itemsViewModel); chalanViewModel.Items = list2; } } //} //} return View(chalanViewModel); } else { return RedirectToAction("LogIn"); } }
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 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 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 EditMaterial(int id) { if (Session["UserId"] != null) { PragatiEntities db = new PragatiEntities(); var data = db.AllMaterials.Where(a => a.MaterialId == id).FirstOrDefault(); EditMaterialViewModel edtmvm = new EditMaterialViewModel(); edtmvm.MaterialId = id; edtmvm.MaterialCode = data.MaterialCode; edtmvm.MaterialImagePath = data.MaterialImagePath; var materialtype = db.MaterialTypes.Where(a => a.MaterialTypeId == data.MaterialTypeId).FirstOrDefault(); edtmvm.MaterialName = materialtype.MaterialName; if (materialtype.MaterialTypeId == 3) { var submaterialtype = db.Sub_Kasab.Where(a => a.MaterialTypeId == data.MaterialTypeId).FirstOrDefault(); edtmvm.SubMaterialName = submaterialtype.Name; edtmvm.SubMaterialId = submaterialtype.Sub_KasabId; } return View(edtmvm); } 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"); } }