public InsuranceAllotmentDTO GetInsuranceAllotment(int insuranceAllotmentId) { InsuranceAllotmentDTO dto = new InsuranceAllotmentDTO(); try { using (var entity = new ManiMotorsEntities1()) { dto = (from vbfa in entity.VehicleBookingInsuranceAllotments join fi in entity.InsuranceInfoes on vbfa.InsuranceInfoID equals fi.InsuranceInfoID where vbfa.VehicleBookingInsuranceAllotmentID == insuranceAllotmentId select new InsuranceAllotmentDTO { VehicleBookingInsuranceAllotmentID = insuranceAllotmentId, VehicleBookingId = vbfa.VehicleBookingID, InsuranceByDealer = vbfa.InsuranceByDealer, InsuranceInfoID = vbfa.InsuranceInfoID, InsuranceName = fi.Name, CoverNoteNo = vbfa.CoverNoteNo, PolicyNumber = vbfa.PolicyNo, PolicyAmount = vbfa.PolicyAmount, FromDate = vbfa.FromDate, ToDate = vbfa.ToDate, PolicyDeliveredDate = vbfa.PolicyDeliveredDate, ContactNo = vbfa.ContactNo, } ).FirstOrDefault(); } } catch (Exception ex) { throw ex; } return(dto); }
public int SaveInsuranceAllotment(InsuranceAllotmentDTO dto, string mode = "") { var insuranceAllotmentId = 0; try { using (var entity = new ManiMotorsEntities1()) { if (mode == "EDIT") { var obj = entity.VehicleBookingInsuranceAllotments.FirstOrDefault(vbfa => vbfa.VehicleBookingInsuranceAllotmentID == dto.VehicleBookingInsuranceAllotmentID); obj.VehicleBookingID = dto.VehicleBookingId; obj.InsuranceByDealer = dto.InsuranceByDealer; obj.InsuranceInfoID = dto.InsuranceInfoID; obj.CoverNoteNo = dto.CoverNoteNo; obj.PolicyNo = dto.PolicyNumber; obj.PolicyAmount = dto.PolicyAmount; obj.FromDate = dto.FromDate; obj.ToDate = dto.ToDate; obj.PolicyDeliveredDate = dto.PolicyDeliveredDate; obj.ContactNo = dto.ContactNo; obj.Createdby = dto.CreatedBy; obj.CreatedDate = dto.CreatedDate; obj.Modifiedby = dto.ModifiedBy; obj.ModifiedDate = dto.ModifiedDate; entity.SaveChanges(); insuranceAllotmentId = obj.VehicleBookingInsuranceAllotmentID; } else { VehicleBookingInsuranceAllotment obj = new VehicleBookingInsuranceAllotment() { VehicleBookingID = dto.VehicleBookingId, InsuranceByDealer = dto.InsuranceByDealer, InsuranceInfoID = dto.InsuranceInfoID, CoverNoteNo = dto.CoverNoteNo, PolicyNo = dto.PolicyNumber, PolicyAmount = dto.PolicyAmount, FromDate = dto.FromDate, ToDate = dto.ToDate, PolicyDeliveredDate = dto.PolicyDeliveredDate, Createdby = dto.CreatedBy, CreatedDate = dto.CreatedDate, Modifiedby = dto.ModifiedBy, ModifiedDate = dto.ModifiedDate }; entity.VehicleBookingInsuranceAllotments.Add(obj); entity.SaveChanges(); insuranceAllotmentId = obj.VehicleBookingInsuranceAllotmentID; } } } catch (Exception ex) { throw ex; } return(insuranceAllotmentId); }
private void btnSave_Click(object sender, EventArgs e) { InsuranceAllotmentBL obj = new InsuranceAllotmentBL(); //InsuranceId int insuranceId = 0; if (ddlInsurance.SelectedIndex != -1) { var insuranceItem = (ComboboxItem)ddlInsurance.SelectedItem; insuranceId = Convert.ToInt32(insuranceItem.Value); } bool isInsByDealer = false; if (rdnYesbyDealer.Checked) { isInsByDealer = true; } int _coverNoteNo = 0; if (txtCoverNote.Text != "") { _coverNoteNo = Convert.ToInt32(txtCoverNote.Text); } int _policyAmount = 0; if (txtPolicyAmount.Text != "") { _policyAmount = Convert.ToInt32(txtPolicyAmount.Text); } //Populate dto InsuranceAllotmentDTO dto = new InsuranceAllotmentDTO() { VehicleBookingId = Convert.ToInt32(lblVehicleBookingId.Text), InsuranceInfoID = insuranceId, InsuranceByDealer = isInsByDealer, CoverNoteNo = _coverNoteNo, PolicyAmount = _policyAmount, PolicyNumber = txtPolicyNo.Text, FromDate = Convert.ToDateTime(dtPolicyFromDate.Text), ToDate = Convert.ToDateTime(dtPolicyToDate.Text), PolicyDeliveredDate = Convert.ToDateTime(dtPolicyDeliveredDate.Text), ContactNo = txtContactNo.Text, CreatedBy = GlobalSetup.Userid, CreatedDate = DateTime.Now, ModifiedBy = GlobalSetup.Userid, ModifiedDate = DateTime.Now }; if (_mode == "EDIT") { dto.VehicleBookingInsuranceAllotmentID = _insuranceAllotmentId; } int insuranceAllotmentId = obj.SaveInsuranceAllotment(dto, _mode); lblnsuranceAllotmentId.Text = insuranceAllotmentId.ToString(); this.Close(); }