private void btn_save_Click(object sender, EventArgs e) { if (validatedata()) { tblBillDTO tblbilldto = new tblBillDTO(); // tblbilldto.BillNo = ; } }
public static tblBillDTO Get(int billId) { using (var dbObject = new BRCTransportDBEntities()) { tblBillDTO temp = new tblBillDTO(); temp = dbObject.tblBills.Find(billId).ToDTO(); temp.BillEntryList = dbObject.tblBillEntries.Where(h => h.BillId == billId).ToList().ToDTOs(); return(temp); } }
private void btn_save_Click(object sender, EventArgs e) { if (validatedata()) { if (CommonClass.tblBillEntryDTO.Count() == 0) { MessageBox.Show("Enter Atlease On Bill Entry"); return; } var resultDuplicateBllNo = BillBusinessLogic.CheckDuplicateBillNo(BillId, Convert.ToInt32(textbillno.Text)); if (resultDuplicateBllNo) { MessageBox.Show("Bill no already exists."); } else { tblBillDTO tblbilldto = new tblBillDTO(); if (BillId > 0) tblbilldto.BillId = BillId; tblbilldto.BillNo = Convert.ToInt32(textbillno.Text); tblbilldto.BillDate = Convert.ToDateTime(dateTimebilldate.Text); tblbilldto.PartyId = Convert.ToInt32(cmbParty.SelectedValue); tblbilldto.BranchCode = textbranchcode.Text; tblbilldto.PaymentDueDate = Convert.ToDateTime(dateTimeduedate.Text); tblbilldto.BillType = Convert.ToString(combotickbill.SelectedItem); tblbilldto.BasicOfChargesGC = textbasicofchange.Text; tblbilldto.Enclosure = textenclosure.Text; tblbilldto.ServiceTaxThrough = Convert.ToString(comboservicetax.SelectedItem); tblbilldto.CheckedBy = textcheckedby.Text; tblbilldto.GrandTotal = Convert.ToInt32(CommonClass.tblBillEntryDTO.Sum(h => h.Amount)); tblbilldto.ServiceTaxRegdNo = textservicetax.Text; tblbilldto.BillEntryList = CommonClass.tblBillEntryDTO; var result = BillBusinessLogic.Save(tblbilldto); if (result > 0) { MessageBox.Show("Bill Succussfully Generate"); if (BillId != 0) { this.Close(); } else { CleanData(); } } else { MessageBox.Show("Bill Generation Fail Dua to some Problem"); } } } }
public static int Save(tblBillDTO tblBillDTO) { using (var dbObject = new BRCTransportDBEntities()) { var tblBillObject = tblBillDTO.ToEntity(); if (tblBillDTO.BillId == 0) { dbObject.tblBills.Add(tblBillObject); if (tblBillDTO.BillEntryList != null) { foreach (var billEntry in tblBillDTO.BillEntryList) { billEntry.BillId = tblBillDTO.BillId; dbObject.tblBillEntries.Add(billEntry.ToEntity()); } } } else { tblBillObject = dbObject.tblBills.Find(tblBillDTO.BillId); tblBillObject.BillNo = tblBillDTO.BillNo; tblBillObject.BillDate = tblBillDTO.BillDate; tblBillObject.PartyId = tblBillDTO.PartyId; tblBillObject.BranchCode = tblBillDTO.BranchCode; tblBillObject.PaymentDueDate = tblBillDTO.PaymentDueDate; tblBillObject.BillType = tblBillDTO.BillType; tblBillObject.BasicOfChargesGC = tblBillDTO.BasicOfChargesGC; tblBillObject.Enclosure = tblBillDTO.Enclosure; tblBillObject.ServiceTaxThrough = tblBillDTO.ServiceTaxThrough; tblBillObject.CheckedBy = tblBillDTO.CheckedBy; tblBillObject.GrandTotal = tblBillDTO.GrandTotal; tblBillObject.ServiceTaxRegdNo = tblBillDTO.ServiceTaxRegdNo; List <tblBillEntry> entry = new List <tblBillEntry>(); entry = dbObject.tblBillEntries.Where(h => h.BillId == tblBillDTO.BillId).ToList(); foreach (var item in entry) { dbObject.tblBillEntries.Remove(item); } if (tblBillDTO.BillEntryList != null) { foreach (var billEntry in tblBillDTO.BillEntryList) { billEntry.BillId = tblBillDTO.BillId; dbObject.tblBillEntries.Add(billEntry.ToEntity()); } } } dbObject.SaveChanges(); return(tblBillObject.BillId); } }
public ActionResult Save(int id) { tblBillDTO tblBillDTO = new tblBillDTO(); if (id == 0) { tblBillDTO = new tblBillDTO(); tblBillDTO.BillNo = BillBusinessLogic.GetBillNo() + 1; } else { tblBillDTO = BillBusinessLogic.Get(id); } tblBillDTO = FillDropDown(tblBillDTO); return(View(tblBillDTO)); }
private tblBillDTO FillDropDown(tblBillDTO tblBillDTO) { var partyList = ConsignorBusinessLogic.GetAll(); foreach (var item in partyList) { item.PartyNameWithCode = item.Code + "-" + item.ConsignorName; } tblBillDTO.PartyList = partyList; //------------------- tblBillDTO.BillTypeList = new List <SelectListItem>(); tblBillDTO.BillTypeList.Add(new SelectListItem { Value = "FREIGHT", Text = "FREIGHT" }); tblBillDTO.BillTypeList.Add(new SelectListItem { Value = "OCTROI", Text = "OCTROI" }); tblBillDTO.BillTypeList.Add(new SelectListItem { Value = "SUPPLER", Text = "SUPPLER" }); tblBillDTO.BillTypeList.Add(new SelectListItem { Value = "MISC", Text = "MISC" }); tblBillDTO.BillTypeList.Add(new SelectListItem { Value = "Others", Text = "Others" }); //------------------- tblBillDTO.ServiceTaxThroughList = new List <SelectListItem>(); tblBillDTO.ServiceTaxThroughList.Add(new SelectListItem { Value = "CONSIGNOR", Text = "CONSIGNOR" }); tblBillDTO.ServiceTaxThroughList.Add(new SelectListItem { Value = "CONSIGNEE", Text = "CONSIGNEE" }); tblBillDTO.ServiceTaxThroughList.Add(new SelectListItem { Value = "BRC", Text = "BRC" }); //------------------- return(tblBillDTO); }
public ActionResult Save(tblBillDTO tblBillDTO) { if (ModelState.IsValid) { var resultDuplicateBllNo = BillBusinessLogic.CheckDuplicateBillNo(tblBillDTO.BillId, tblBillDTO.BillNo); if (resultDuplicateBllNo) { ModelState.AddModelError("BillNo", "Bill no already exists."); } else { if (tblBillDTO.BillId == 0) { tblBillDTO.BillEntryList = (List <tblBillEntryDTO>)Session["BillEntrySession"]; } var result = BillBusinessLogic.Save(tblBillDTO); return(RedirectToAction("Index")); } } tblBillDTO = FillDropDown(tblBillDTO); return(View(tblBillDTO)); }
public static int Save(tblBillDTO tblBillDTO) { return(BillRepository.Save(tblBillDTO)); }