private void SearchEvent()
{
var customerName = txtName.Text;
var mobileNo = txtMobileNo.Text;
var followUpDate = Convert.ToDateTime(dtStartDate.Text);
var status = ddlStatus.Text;
var statusItem = (ComboboxItem)ddlStatus.SelectedItem;
int statusId = Convert.ToInt32(statusItem.Value);
CustomerEnquiryFollowupBL ef = new CustomerEnquiryFollowupBL();
dgFollowup.DataSource = ef.GetCustomerEnquiryFollowup(Convert.ToDateTime(dtStartDate.Text), Convert.ToDateTime(dtEndDate.Text), statusId)
.Where(
efu => efu.CustomerName.ToUpper().Contains(customerName.ToUpper())
&&
efu.CustomerMobileNo.ToUpper().Contains(mobileNo.ToUpper())
&&
efu.StatusDescription.ToUpper().Contains(status.ToUpper())
).ToList();
if (dgFollowup.RowCount > 0)
{
btnEDIT.Enabled = true;
}
else
{
btnEDIT.Enabled = false;
}
}
private void LoadDefaultValues()
{
//Load Status
ddlStatus.Items.Clear();
VehicleInfoBL v = new VehicleInfoBL();
var slist = v.GetVehicleSalesStatus(string.Empty);
foreach (var vl in slist)
{
ComboboxItem item = new ComboboxItem();
item.Text = vl.Description;;
item.Value = vl.VehicleSalesStatusID;
ddlStatus.Items.Add(item);
}
if (ddlStatus.Items.Count > 0)
{
ddlStatus.SelectedIndex = 0;
}
CustomerEnquiryFollowupBL ef = new CustomerEnquiryFollowupBL();
dgFollowup.DataSource = ef.GetCustomerEnquiryFollowup(Convert.ToDateTime(dtStartDate.Text), Convert.ToDateTime(dtEndDate.Text), 1) //default status open
.ToList();
if (dgFollowup.RowCount > 0)
{
btnEDIT.Enabled = true;
}
else
{
btnEDIT.Enabled = false;
}
}
private void LoadDefaultValues()
{
//Get Current Month
lblMonth.Text = CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(DateTime.Now.Month).ToString();
lblTodayDate.Text = DateTime.Now.ToString("dd/MM/yyyy");
//VehicleBookingReport
VehicleBookingReportBL bl = new VehicleBookingReportBL();
var allvehicleBookingList = bl.GetAllVehicleBooking();
int deliveredCount = allvehicleBookingList.Where(x => x.CommittedDate.Month == DateTime.Now.Month && x.StatusDescription.ToUpper() == "DELIVERED").Count();
lblNoDelivered.Text = deliveredCount.ToString();
int BookedCount = allvehicleBookingList.Where(x => x.StatusDescription.ToUpper() == "OPEN").Count();
lblNoBookings.Text = BookedCount.ToString();
//VehicleEnquiry
CustomerEnquiryReportBL eBl = new CustomerEnquiryReportBL();
var enquiryLit = eBl.GetAllCustomerEnquiry();
//int allEnquiries = enquiryLit.Where(x => x.CreatedDate.Month == DateTime.Now.Month).Count();
lblNoofEnquiry.Text = enquiryLit.Where(x => x.VehicleStatusDescription.ToUpper() == "OPEN").Count().ToString();
int bookedEnquiries = enquiryLit.Where(x => x.VehicleStatusDescription.ToUpper() == "BOOKED").Count();
lblNoEnquiryToBookings.Text = bookedEnquiries.ToString();
int deliveredEnquiries = enquiryLit.Where(x => x.VehicleStatusDescription.ToUpper() == "DELIVERED").Count();
lblEnquiryToDelivery.Text = deliveredEnquiries.ToString();
//VehicleEnquiryFollowUpForToday
CustomerEnquiryFollowupBL efBL = new CustomerEnquiryFollowupBL();
var todayEnquiryfollowup = efBL.GetCustomerEnquiryFollowup(Convert.ToDateTime(DateTime.Now.ToShortDateString()), Convert.ToDateTime(DateTime.Now.ToShortDateString()), 1); //Open Status id for today
lblEnquiryFollowUpToday.Text = todayEnquiryfollowup.Count().ToString();
//VehicleEnquiryFollowUpForPastDays
CustomerEnquiryFollowupBL efBLpast = new CustomerEnquiryFollowupBL();
var pastEnquiryfollowup = efBL.GetCustomerEnquiryFollowup(Convert.ToDateTime(DateTime.MinValue.ToShortDateString()), Convert.ToDateTime(DateTime.Now.AddDays(-1).ToShortDateString()), 1); //Open Status id for today
lblPrevEnquiryFollowup.Text = pastEnquiryfollowup.Count().ToString();
//VehicleBookingFollowUpForToday
VehicleBookingFollowUpBL vbfBL = new VehicleBookingFollowUpBL();
var todayBookingfollowup = vbfBL.GetVehicleBookingFollowUp(Convert.ToDateTime(DateTime.Now.ToShortDateString()), Convert.ToDateTime(DateTime.Now.ToShortDateString()), 1);
lblBookingFollowUpToday.Text = todayBookingfollowup.Count().ToString();
//BookingFollowUpForPastDays
var pastBookingfollowup = vbfBL.GetVehicleBookingFollowUp(Convert.ToDateTime(DateTime.MinValue.ToShortDateString()), Convert.ToDateTime(DateTime.Now.AddDays(-1).ToShortDateString()), 1);
lblPrevBookingFollowup.Text = pastBookingfollowup.Count().ToString();
//Populate Invoice Generated
MM.BusinessLayer.Admin.InvoiceBL iBL = new MM.BusinessLayer.Admin.InvoiceBL();
var invoiceGenerated = iBL.InvoiceMarginGenerated();
lblNoofMarginGen.Text = invoiceGenerated.ToString();
var invoiceGenerationPending = iBL.InvoiceMarginPending();
lblNoofMarginpending.Text = invoiceGenerationPending.ToString();
if (_userName != "")
{
lblUserName.Text = _userName;
}
if (_role != "ADMIN")
{
accountingToolStripMenuItem.Visible = false;
expenseTypeToolStripMenuItem.Visible = false;
accountingToolStripMenuItem1.Visible = false;
invoiceToolStripMenuItem.Visible = false;
vehicleMarginToolStripMenuItem.Visible = false;
}
}
private void PopulateCustomerEnquiry(int enquiryId)
{
CustomerBL cBl = new CustomerBL();
var customerEnquiry = cBl.GetCustomerEnquiry(enquiryId);
//Assign EnquiryInformation to form
txtCustomerName.Text = customerEnquiry.CustomerName;
txtCustomerId.Text = customerEnquiry.CustomerID.ToString();
txtReferenceBy.Text = customerEnquiry.ReferenceBy;
//Employees
ComboboxItem empItem = new ComboboxItem();
empItem.Text = customerEnquiry.SalesExecutiveName;
empItem.Value = customerEnquiry.SalesExecutiveId;
ddlEmployees.Text = empItem.Text;
//Model1
if (customerEnquiry.Model1 != 0)
{
ComboboxItem model1item = new ComboboxItem();
model1item.Text = customerEnquiry.ModelName1;
model1item.Value = customerEnquiry.Model1;
ddlModel1.Text = model1item.Text;
}
//Model2
if (customerEnquiry.Model2 != 0)
{
ComboboxItem model2item = new ComboboxItem();
model2item.Text = customerEnquiry.ModelName2;
model2item.Value = customerEnquiry.Model2;
ddlModel2.Text = model2item.Text;
}
//Model3
if (customerEnquiry.Model3 != 0)
{
ComboboxItem model3item = new ComboboxItem();
model3item.Text = customerEnquiry.ModelName3;
model3item.Value = customerEnquiry.Model3;
ddlModel3.Text = model3item.Text;
}
ddlColor.Text = customerEnquiry.Color;
if (customerEnquiry.TestDrive)
{
rdnTDNo.Checked = false;
rdnTDYes.Checked = true;
}
if (customerEnquiry.IsExchangeVehicle)
{
rdnEVNo.Checked = false;
rdnEVYes.Checked = true;
}
if (customerEnquiry.CashorFinance.ToUpper() == "CASH")
{
rdnCash.Checked = true;
rdnFinance.Checked = false;
}
else
{
rdnCash.Checked = false;
rdnFinance.Checked = true;
}
txtCompetitiveModel.Text = customerEnquiry.CompetitiveModel;
//Status
ComboboxItem statusItem = new ComboboxItem();
statusItem.Text = customerEnquiry.VehicleStatusDescription;
statusItem.Value = customerEnquiry.VehicleStatusId;
ddlStatus.Text = statusItem.Text;
//Populate followup records
CustomerEnquiryFollowupBL efBl = new CustomerEnquiryFollowupBL();
var enquityfollowup = efBl.GetCustomerEnquiryFollowupbyId(enquiryId);
lblPrevRemarks.Text = enquityfollowup.Description;
dtFollowupDate.Text = enquityfollowup.FollowUpDate.ToString();
}
