public CustomerEnquiryFollowupDTO GetCustomerEnquiryFollowupbyId(int CustomerEnquiryid) { CustomerEnquiryFollowupDTO lst = new CustomerEnquiryFollowupDTO(); try { using (var entity = new ManiMotorsEntities1()) { lst = (from ce in entity.CustomerEnquiries join cef in entity.CustomerEnquiryFollowUps on ce.CustomerEnquiryID equals cef.CustomerEnquiryID join vs in entity.VehicleSalesStatus on ce.VehicleStatusID equals vs.VehicleSalesStatusID join vi in entity.VehicleInfoes on ce.Model1 equals vi.VehicleInfoID join c in entity.Customers on ce.CustomerID equals c.CustomerID where cef.CustomerEnquiryID == CustomerEnquiryid && cef.IsLatest == true select new CustomerEnquiryFollowupDTO { CustomerName = c.Name, CustomerId = c.CustomerID, ModelName = vi.ModelName, CustomerEnquiryId = ce.CustomerEnquiryID, FollowUpDate = cef.FollowUpDate, StatusDescription = vs.Description, StatusId = vs.VehicleSalesStatusID, CustomerMobileNo = c.ContactNo, Description = cef.Description }).FirstOrDefault(); } } catch (Exception ex) { throw ex; } return(lst); }
public bool SaveCustomerEnquiry(CustomerEnquiryDTO eDTO, CustomerEnquiryFollowupDTO efDTO, int exchangeVehicleId = 0, string mode = "") { var flag = false; try { using (var entities = new ManiMotorsEntities1()) { using (TransactionScope scope = new TransactionScope()) { if (mode != "EDIT") { try { CustomerEnquiry dbEnt = new CustomerEnquiry() { CustomerID = eDTO.CustomerID, ReferenceBy = eDTO.ReferenceBy, CashORFinance = eDTO.CashorFinance, SalesExecutive = eDTO.SalesExecutiveId, Model1 = eDTO.Model1, Model2 = eDTO.Model2, Model3 = eDTO.Model3, Color = eDTO.Color, TestDrive = eDTO.TestDrive, ExchangeVehicle = eDTO.IsExchangeVehicle, CompetitiveModel = eDTO.CompetitiveModel, VehicleStatusID = eDTO.VehicleStatusId, Createdby = eDTO.CreatedBy, CreatedDate = eDTO.CreatedDate, Modifiedby = eDTO.ModifiedBy, ModifiedDate = eDTO.ModifiedDate }; entities.CustomerEnquiries.Add(dbEnt); entities.SaveChanges(); var CustomerEnquiryID = dbEnt.CustomerEnquiryID; var lstCustomer = entities.CustomerEnquiryFollowUps.Where(i => i.CustomerEnquiryID == CustomerEnquiryID); foreach (var followup in lstCustomer) { followup.IsLatest = false; entities.SaveChanges(); } CustomerEnquiryFollowUp dbEntf = new CustomerEnquiryFollowUp() { CustomerID = efDTO.CustomerId, CustomerEnquiryID = CustomerEnquiryID, Description = efDTO.Description, FollowUpDate = efDTO.FollowUpDate, Createdby = eDTO.CreatedBy, CreatedDate = eDTO.CreatedDate, Modifiedby = eDTO.ModifiedBy, ModifiedDate = eDTO.ModifiedDate, IsLatest = true, }; entities.CustomerEnquiryFollowUps.Add(dbEntf); entities.SaveChanges(); if (exchangeVehicleId != 0) { var customerExchange = entities.CustomerExchangeVehicles.FirstOrDefault(ev => ev.CustomerExchangeVehicleID == exchangeVehicleId); customerExchange.CustomerEnquiryID = CustomerEnquiryID; entities.SaveChanges(); } scope.Complete(); } catch (Exception ex) { scope.Dispose(); throw; } } else { try { var ce = entities.CustomerEnquiries.FirstOrDefault(e => e.CustomerEnquiryID == eDTO.CustomerEnquiryID); ce.CustomerID = eDTO.CustomerID; ce.ReferenceBy = eDTO.ReferenceBy; ce.CashORFinance = eDTO.CashorFinance; ce.SalesExecutive = eDTO.SalesExecutiveId; ce.Model1 = eDTO.Model1; ce.Model2 = eDTO.Model2; ce.Model3 = eDTO.Model3; ce.Color = eDTO.Color; ce.TestDrive = eDTO.TestDrive; ce.ExchangeVehicle = eDTO.IsExchangeVehicle; ce.CompetitiveModel = eDTO.CompetitiveModel; ce.VehicleStatusID = eDTO.VehicleStatusId; ce.Createdby = eDTO.CreatedBy; ce.CreatedDate = eDTO.CreatedDate; ce.Modifiedby = eDTO.ModifiedBy; ce.ModifiedDate = eDTO.ModifiedDate; entities.SaveChanges(); var lstCustomer = entities.CustomerEnquiryFollowUps.Where(i => i.CustomerEnquiryID == eDTO.CustomerEnquiryID); foreach (var followup in lstCustomer) { followup.IsLatest = false; entities.SaveChanges(); } CustomerEnquiryFollowUp dbEntf = new CustomerEnquiryFollowUp() { CustomerID = efDTO.CustomerId, CustomerEnquiryID = eDTO.CustomerEnquiryID, Description = efDTO.Description, FollowUpDate = efDTO.FollowUpDate, Createdby = eDTO.CreatedBy, CreatedDate = eDTO.CreatedDate, Modifiedby = eDTO.ModifiedBy, ModifiedDate = eDTO.ModifiedDate, IsLatest = true, }; entities.CustomerEnquiryFollowUps.Add(dbEntf); entities.SaveChanges(); scope.Complete(); } catch (Exception ex) { scope.Dispose(); throw; } } } } flag = true; } catch (Exception ex) { throw ex; } return(flag); }
private void btnSave_Click(object sender, EventArgs e) { if (txtCustomerName.Text == "" || ddlEmployees.SelectedIndex == -1 || ddlModel1.SelectedIndex == -1 || (!rdnTDYes.Checked && !rdnTDNo.Checked) || (!rdnEVYes.Checked && !rdnEVNo.Checked) || (!rdnCash.Checked && !rdnFinance.Checked) || ddlStatus.SelectedIndex == -1 || txtRemarks.Text == "") { MyMessageBox.ShowBox("Please Enter All Mandatory Fields!!!"); return; } //Get ModelId int Model1 = 0; if (ddlModel1.SelectedIndex != -1) { var model1Item = (ComboboxItem)ddlModel1.SelectedItem; Model1 = Convert.ToInt32(model1Item.Value); } int?Model2 = null; if (ddlModel2.SelectedIndex != -1) { var model2Item = (ComboboxItem)ddlModel2.SelectedItem; Model2 = Convert.ToInt32(model2Item.Value); } int?Model3 = null; if (ddlModel3.SelectedIndex != -1) { var model3Item = (ComboboxItem)ddlModel3.SelectedItem; Model3 = Convert.ToInt32(model3Item.Value); } string color = ddlColor.Text; bool testDrive = rdnTDYes.Checked; bool exchangeVehicle = rdnEVYes.Checked; string payment; if (rdnCash.Checked) { payment = "Cash"; } else { payment = "Finance"; } //Get Sales Executive Id int SalesExecutiveId = 0; if (ddlEmployees.SelectedIndex != -1) { var salesItem = (ComboboxItem)ddlEmployees.SelectedItem; SalesExecutiveId = Convert.ToInt32(salesItem.Value); } //Get StatusId int StatusId = 0; if (ddlStatus.SelectedIndex != -1) { var statusitem = (ComboboxItem)ddlStatus.SelectedItem; StatusId = Convert.ToInt32(statusitem.Value); } CustomerEnquiryDTO dto = new CustomerEnquiryDTO() { CustomerID = Convert.ToInt32(txtCustomerId.Text), ReferenceBy = txtReferenceBy.Text, SalesExecutiveId = SalesExecutiveId, Model1 = Model1, Model2 = Model2, Model3 = Model3, Color = color, TestDrive = testDrive, IsExchangeVehicle = exchangeVehicle, CashorFinance = payment, CompetitiveModel = txtCompetitiveModel.Text, VehicleStatusId = StatusId, CreatedBy = GlobalSetup.Userid, CreatedDate = DateTime.Now, ModifiedBy = 1, ModifiedDate = DateTime.Now }; CustomerEnquiryFollowupDTO efdto = new CustomerEnquiryFollowupDTO() { CustomerId = Convert.ToInt32(txtCustomerId.Text), Description = txtRemarks.Text, FollowUpDate = Convert.ToDateTime(dtFollowupDate.Text), CreatedBy = GlobalSetup.Userid, CreatedDate = DateTime.Now, ModifiedBy = 1, ModifiedDate = DateTime.Now }; CustomerBL obj = new CustomerBL(); if (_mode == "EDIT") { dto.CustomerEnquiryID = _enquiryId; } var flag = obj.SaveCustomerEnquiry(dto, efdto, ExchangeVehicleId, _mode); if (flag) { MyMessageBox.ShowBox("Vehicle Enquiry Saved"); Clear(); } else { MyMessageBox.ShowBox("Vehicle Enquiry Failed to Save"); } }