public static int SaveBillEntry(tblBillEntryDTO tblBillEntryDTO) { using (var dbObject = new BRCTransportDBEntities()) { var tblBillEntryObject = tblBillEntryDTO.ToEntity(); if (tblBillEntryDTO.BillOrderId == 0) { dbObject.tblBillEntries.Add(tblBillEntryObject); } else { tblBillEntryObject = dbObject.tblBillEntries.Find(tblBillEntryDTO.BillOrderId); tblBillEntryObject.BillId = tblBillEntryDTO.BillId; tblBillEntryObject.BookingOldBrCode = tblBillEntryDTO.BookingOldBrCode; tblBillEntryObject.OldBillNo = tblBillEntryDTO.OldBillNo; tblBillEntryObject.OldBillDate = tblBillEntryDTO.OldBillDate; tblBillEntryObject.DestnCode = tblBillEntryDTO.DestnCode; tblBillEntryObject.Particulars = tblBillEntryDTO.Particulars; tblBillEntryObject.ChargedWeight = tblBillEntryDTO.ChargedWeight; tblBillEntryObject.Rate = tblBillEntryDTO.Rate; tblBillEntryObject.Amount = tblBillEntryDTO.Amount; } dbObject.SaveChanges(); return(tblBillEntryObject.BillOrderId); } }
public JsonResult BillEntryPartial(tblBillEntryDTO tblBillEntryDTO) { if (tblBillEntryDTO.BillId == 0) { var billEntryList = (List <tblBillEntryDTO>)Session["BillEntrySession"]; if (billEntryList == null) { billEntryList = new List <tblBillEntryDTO>(); } if (tblBillEntryDTO.SrNo == 0) { billEntryList.Add(tblBillEntryDTO); } else { var billEntry = billEntryList.Where(be => be.SrNo == tblBillEntryDTO.SrNo).FirstOrDefault(); billEntry.BillId = tblBillEntryDTO.BillId; billEntry.BookingOldBrCode = tblBillEntryDTO.BookingOldBrCode; billEntry.OldBillNo = tblBillEntryDTO.OldBillNo; billEntry.OldBillDate = tblBillEntryDTO.OldBillDate; billEntry.DestnCode = tblBillEntryDTO.DestnCode; billEntry.Particulars = tblBillEntryDTO.Particulars; billEntry.ChargedWeight = tblBillEntryDTO.ChargedWeight; billEntry.Rate = tblBillEntryDTO.Rate; billEntry.Amount = tblBillEntryDTO.Amount; } Session["BillEntrySession"] = SetBillEntrySrNo(billEntryList); } else { BillBusinessLogic.SaveBillEntry(tblBillEntryDTO); } return(Json(new { Success = true, Message = "" })); }
public PartialViewResult BillEntryPartial(int srNO, int billId, int billOrderId) { var tblBillEntryDTO = new tblBillEntryDTO(); if (billId == 0) { if (srNO > 0) { var billEntryList = (List <tblBillEntryDTO>)Session["BillEntrySession"]; if (billEntryList == null) { billEntryList = new List <tblBillEntryDTO>(); } tblBillEntryDTO = billEntryList.Where(be => be.SrNo == srNO).FirstOrDefault(); } } else { if (billOrderId > 0) { tblBillEntryDTO = BillBusinessLogic.GetBillEntry(billOrderId); } } return(PartialView(tblBillEntryDTO)); }
private void btnSave_Click(object sender, EventArgs e) { tblBillEntryDTO temp = new tblBillEntryDTO(); var srno = 1; if (CommonClass.tblBillEntryDTO.Count() > 0) { srno = CommonClass.tblBillEntryDTO.Select(h => h.SrNo).Max() + 1; } temp.SrNo = srno; temp.BookingOldBrCode = txtBrcode.Text; temp.OldBillDate = Convert.ToDateTime(dpBillDate.Text); temp.OldBillNo = txtbillno.Text; temp.DestnCode = txtdestncode.Text; temp.Particulars = txtperticulers.Text; temp.ChargedWeight = txtchagesWeight.Text; temp.Rate = txtrate.Text; temp.Amount = txtamount.Text.Trim() == "" ? 0 : Convert.ToDouble(txtamount.Text); if (billdata != null) { temp.SrNo = billdata.SrNo; CommonClass.tblBillEntryDTO.Remove(billdata); CommonClass.tblBillEntryDTO.Add(temp); this.Close(); } else { CommonClass.tblBillEntryDTO.Add(temp); } CleanData(); }
private void grdEntryBill_CellContentClick(object sender, DataGridViewCellEventArgs e) { string Action = this.grdEntryBill.Columns[e.ColumnIndex].HeaderText; if (Action == "Edit") { frmChildBill frmchilbill = new frmChildBill(); int billid = Convert.ToInt32(grdEntryBill.Rows[e.RowIndex].Cells["SrNo"].Value); frmchilbill.billdata = CommonClass.tblBillEntryDTO.Where(h => h.SrNo == billid).FirstOrDefault(); frmchilbill.FormClosed += frmchilbill_FormClosed; frmchilbill.ShowDialog(); } if (Action == "Delete") { try { var messageBoxResult = MessageBox.Show("Are you sure want to delete this record?", "Delete", MessageBoxButtons.YesNo); if (messageBoxResult == DialogResult.Yes) { int billid = Convert.ToInt32(grdEntryBill.Rows[e.RowIndex].Cells[0].Value); tblBillEntryDTO billdata = CommonClass.tblBillEntryDTO.Where(h => h.SrNo == billid).FirstOrDefault(); CommonClass.tblBillEntryDTO.Remove(billdata); fillGridData(); } } catch (Exception) { MessageBox.Show("Bill already used some where else can't deleted successfully."); } } }
public static int SaveBillEntry(tblBillEntryDTO tblBillEntryDTO) { return(BillRepository.SaveBillEntry(tblBillEntryDTO)); }