public FinanceAllotmentDTO GetFinanceAllotment(int financeAllotmentId) { FinanceAllotmentDTO dto = new FinanceAllotmentDTO(); try { using (var entity = new ManiMotorsEntities1()) { dto = (from vbfa in entity.VehicleBookingFinanceAllotments join fi in entity.FinanceInfoes on vbfa.FinancierID equals fi.FinanceInfoID where vbfa.VehicleBookingFinanceAllotmentID == financeAllotmentId select new FinanceAllotmentDTO { VehicleBookingFinanceAllotmentID = financeAllotmentId, VehicleBookingId = vbfa.VehicleBookingID, FinancierName = fi.Name, FinancierID = vbfa.FinancierID, LoanNumber = vbfa.LoanNo, FinanceDate = vbfa.FinanceDate, FinanceAmount = vbfa.FinanceAmount, OtherAmount = vbfa.OtherAmount, OtherChargesDescription = vbfa.OtherChargesDesc } ).FirstOrDefault(); } } catch (Exception ex) { throw ex; } return(dto); }
private void btnSave_Click(object sender, EventArgs e) { FinanceAllotmentBL obj = new FinanceAllotmentBL(); //FinancierId int financierId = 0; if (ddlFinance.SelectedIndex != -1) { var financeItem = (ComboboxItem)ddlFinance.SelectedItem; financierId = Convert.ToInt32(financeItem.Value); } int _loanNo = 0; if (txtLoanNo.Text != "") { _loanNo = Convert.ToInt32(txtLoanNo.Text); } int _financeAmt = 0; if (txtFinanceamt.Text != "") { _financeAmt = Convert.ToInt32(txtFinanceamt.Text); } int _otherAmt = 0; if (txtOtherChargesAmt.Text != "") { _otherAmt = Convert.ToInt32(txtOtherChargesAmt.Text); } //Populate dto FinanceAllotmentDTO dto = new FinanceAllotmentDTO() { VehicleBookingId = Convert.ToInt32(lblVehicleBookingId.Text), FinancierID = financierId, LoanNumber = _loanNo, FinanceDate = Convert.ToDateTime(dtFinanceDate.Text), FinanceAmount = _financeAmt, OtherChargesDescription = txtOtherChargesDesc.Text, OtherAmount = _otherAmt, CreatedBy = GlobalSetup.Userid, CreatedDate = DateTime.Now, ModifiedBy = GlobalSetup.Userid, ModifiedDate = DateTime.Now }; if (_mode == "EDIT") { dto.VehicleBookingFinanceAllotmentID = _financeAllotmentId; } int financeAllotmentId = obj.SaveFinanceAllotment(dto, _mode); lblFinanceAllotmentId.Text = financeAllotmentId.ToString(); this.Close(); }
public int SaveFinanceAllotment(FinanceAllotmentDTO dto, string mode = "") { var financeAllotmentId = 0; try { using (var entity = new ManiMotorsEntities1()) { if (mode == "EDIT") { var obj = entity.VehicleBookingFinanceAllotments.FirstOrDefault(vbfa => vbfa.VehicleBookingFinanceAllotmentID == dto.VehicleBookingFinanceAllotmentID); obj.VehicleBookingID = dto.VehicleBookingId; obj.FinancierID = dto.FinancierID; obj.LoanNo = dto.LoanNumber; obj.FinanceDate = dto.FinanceDate; obj.FinanceAmount = dto.FinanceAmount; obj.OtherChargesDesc = dto.OtherChargesDescription; obj.OtherAmount = dto.OtherAmount; obj.Createdby = dto.CreatedBy; obj.CreatedDate = dto.CreatedDate; obj.Modifiedby = dto.ModifiedBy; obj.ModifiedDate = dto.ModifiedDate; entity.SaveChanges(); financeAllotmentId = obj.VehicleBookingFinanceAllotmentID; } else { VehicleBookingFinanceAllotment obj = new VehicleBookingFinanceAllotment() { VehicleBookingID = dto.VehicleBookingId, FinancierID = dto.FinancierID, LoanNo = dto.LoanNumber, FinanceDate = dto.FinanceDate, FinanceAmount = dto.FinanceAmount, OtherChargesDesc = dto.OtherChargesDescription, OtherAmount = dto.OtherAmount, Createdby = dto.CreatedBy, CreatedDate = dto.CreatedDate, Modifiedby = dto.ModifiedBy, ModifiedDate = dto.ModifiedDate }; entity.VehicleBookingFinanceAllotments.Add(obj); entity.SaveChanges(); financeAllotmentId = obj.VehicleBookingFinanceAllotmentID; } } } catch (Exception ex) { throw ex; } return(financeAllotmentId); }
public InvoiceDTO GetInvoiceDetails(int VehicleBookingId) { var Invoicedto = new InvoiceDTO(); var vBL = new VehicleBookingBL(); var viBL = new VehicleInventoryBL(); var vABL = new VehicleAllotmentBL(); var spABL = new SparePartsAllotmentBL(); var spInventory = new SparePartsInventoryBL(); var fABL = new FinanceAllotmentBL(); var vehicleBooking = vBL.GetVehicleBooking(VehicleBookingId); //Customer Information var ctmrDTO = new CustomerDTO(); //VehicleInventory var vIDTO = new VehicleInventoryDTO(); //VehicleBooking var vBDTO = new VehicleBookingDTO(); //SpareParts Inventory var spInvDTOlist = new List <SparePartsInventoryDTO>(); //Finance Allotment var fDTO = new FinanceAllotmentDTO(); if (vehicleBooking != null) { vBDTO = vehicleBooking; Invoicedto.VclBooking = vBDTO; ctmrDTO.CustomerID = vehicleBooking.CustomerID; ctmrDTO.Name = vehicleBooking.CustomerName; Invoicedto.Customer = ctmrDTO; //Get Vehicle Inventory ID from VehicleAllotment Id int vInventoryId = vABL.GeInventoryId(vehicleBooking.VehicleBookingAllotmentId ?? 0); if (vInventoryId != 0) { var invDTO = viBL.GetVehicleInventory(vInventoryId); vIDTO.EngineNo = invDTO.EngineNo; vIDTO.ChasisNo = invDTO.ChasisNo; vIDTO.VehicleModelName = invDTO.VehicleModelName; vIDTO.ExShowRoomPrice = invDTO.ExShowRoomPrice; vIDTO.LT_RT_OtherExp = invDTO.LT_RT_OtherExp; vIDTO.InsurancePrice = invDTO.InsurancePrice; vIDTO.OnRoadPrice = invDTO.OnRoadPrice; vIDTO.WarrantyPrice = invDTO.WarrantyPrice; vIDTO.VehicleInventoryID = vInventoryId; if (invDTO.Is70PerMarginPrice) { vIDTO.MarginPrice = invDTO.Margin70; } if (invDTO.Is50PerMarginPrice) { vIDTO.MarginPrice = invDTO.Margin50; } Invoicedto.VehicleInventory = vIDTO; } //Get SpareParts Allotment Details var sPAltList = spABL.GetSparePartsAllotmentbyBookingId(VehicleBookingId); if (sPAltList.Count > 0) { foreach (var sp in sPAltList) { var spIDTO = new SparePartsInventoryDTO(); if (sp.SparePartsInventoryID != 0) { var spI = spInventory.GetSparePartsInventory(sp.SparePartsInventoryID); //SpareParts Inventory SparePartsInventoryDTO spidto = new SparePartsInventoryDTO(); spidto.SparePartsInventoryID = sp.SparePartsInventoryID; spidto.ShowRoomPrice = spI.ShowRoomPrice; spidto.MarginPrice = spI.MarginPrice; spidto.SparePartsModelName = spI.SparePartsModelName; spidto.SparePartsInfoID = spI.SparePartsInfoID; spInvDTOlist.Add(spidto); } } Invoicedto.lstSparePartsInventory = spInvDTOlist; } //Finance Allotment if (vehicleBooking.FinanceAllotmentId != null && vehicleBooking.FinanceAllotmentId != 0) { fDTO = fABL.GetFinanceAllotment(vehicleBooking.FinanceAllotmentId ?? 0); Invoicedto.FinanceAllotment = fDTO; } } return(Invoicedto); }