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