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