private void LoadRentList(int DriverId) { try { var query = from a in General.GetQueryable <DriverRent>(c => c.DriverId == DriverId) select new { Id = a.Id, TransNo = a.TransNo, TransDate = a.TransDate, DriverNo = a.Fleet_Driver.DriverNo, Driver = a.Fleet_Driver.DriverName, DriverID = a.DriverId, Rent = a.DriverRent1, Balance = a.Balance, //JobsTotal = a.JobsTotal TransactionFor = a.TransFor }; grdLister.DataSource = query.ToList(); } catch (Exception ex) { ENUtils.ShowErrorMessage(ex.Message); } }
private void SaveData() { try { Gen_SysPolicy obj = General.GetQueryable <Gen_SysPolicy>(null).FirstOrDefault(); if (obj != null) { objMaster.GetByPrimaryKey(obj.Id); objMaster.Edit(); } string[] skipProperties = { "Gen_SysPolicy" }; IList <Fleet_DriverTemplet> savedListTemp = objMaster.Current.Fleet_DriverTemplets; List <Fleet_DriverTemplet> listofDetailTemp = (from r in grdSMSTemplets.Rows select new Fleet_DriverTemplet { Id = r.Cells[COL_SMSTEMPLET.ID].Value.ToInt(), Templets = r.Cells[COL_SMSTEMPLET.Tempplet].Value.ToString(), SysPolicyId = r.Cells[COL_SMSTEMPLET.POLICYID].Value.ToInt(), }).ToList(); Utils.General.SyncChildCollection(ref savedListTemp, ref listofDetailTemp, "Id", skipProperties); objMaster.Save(); Display(); } catch (Exception ex) { ENUtils.ShowErrorMessage(ex.Message); } }
void GetClientName() { try { string Client = AppVars.objPolicyConfiguration.DefaultClientId.ToString(); string ClientName = Client; conn = new SqlConnection(); conn.ConnectionString = Connection1; conn.Open(); dt = new DataTable(); // For Client ID string ID = "select ID from Clients where Name = '" + ClientName + "'"; SqlDataAdapter dr = new SqlDataAdapter(ID, conn); dr.Fill(dt); ClientID = dt.Rows[0]["ID"].ToInt(); conn.Close(); GetVehicalIdFromWeb(); } catch (Exception ex) { conn.Close(); ENUtils.ShowErrorMessage(ex.Message); } }
private void LoadRentList() { try { using (TaxiDataContext db = new TaxiDataContext()) { //var query = (from a in General.GetQueryable<Fleet_Driver>(c => c.IsActive == true && c.DriverTypeId == 1).AsEnumerable() // where // (col_No && (a.DriverNo.ToLower().Contains(searchTxt) || searchTxt == string.Empty)) // || (col_DriverName && (a.DriverName.ToLower().Contains(searchTxt) || searchTxt == string.Empty)) // select new // { // Id = a.Id, // No = a.DriverNo, // Name = a.DriverName, // MobileNo = a.MobileNo, // LastDate = a.DriverRents.Count > 0 ? a.DriverRents[a.DriverRents.Count - 1].TransDate : null, // TotalRentCount = a.DriverRents.Count > 0 ? Convert.ToSingle(a.DriverRents.Count).ToStr() : "" // }).ToList(); // grdLister.DataSource = query.AsEnumerable().OrderBy(item => item.No, new NaturalSortComparer<string>()).ToList(); grdLister.DataSource = db.stp_getdriverrentlist().ToList().OrderBy(item => item.DriverNo, new NaturalSortComparer <string>()).ToList(); } } catch (Exception ex) { ENUtils.ShowErrorMessage(ex.Message); } }
private void btnAllDrivers_Click(object sender, EventArgs e) { try { string DateType = ""; int Month = 0; int Year = 0; DateTime?FromDate = dtpFromDate.Value.ToDateorNull(); DateTime?TillDate = dtpTillDate.Value.ToDateorNull(); TillDate = TillDate + TimeSpan.Parse("23:59:59"); if (rdoWeekly.IsChecked == true) { DateType = "CURRENT_WEEK"; if (chkLastWeek.Checked == true) { DateType = "LAST_WEEK"; } } else if (rdoMonthly.IsChecked == true) { DateType = "MONTHLY"; Month = ddlMonths.SelectedIndex.ToInt(); string yr = ddlYear.SelectedText == "" ? DateTime.Now.Year.ToStr() : ddlYear.SelectedText.ToStr(); Year = (yr).ToInt(); } else if (rdoDaily.IsChecked == true) { DateType = "DAILY"; } if (rdoDateCriteria.IsChecked == true) { frmMultiGraphsReports frm = new frmMultiGraphsReports(ddlUsers.SelectedValue.ToInt(), DayName, "DRIVERS", DateType, Month, Year, FromDate.ToDateTime(), TillDate.ToDateTime()); DockWindow doc = UI.MainMenuForm.MainMenuFrm.GetDockByName("frmMultiGraphsReports1"); if (doc != null) { doc.Close(); } MainMenuForm.MainMenuFrm.ShowForm(frm); } else { ENUtils.ShowMessage("Select Date Criteria from Multi Graphs"); } } catch (Exception ex) { ENUtils.ShowErrorMessage(ex.Message); } }
private void btnViewReport_Click(object sender, EventArgs e) { try { ViewReport(); } catch (Exception ex) { ENUtils.ShowErrorMessage(ex.Message); } }
private void LoadLostList() { try { string searchTxt = txtSearch.Text.ToStr().ToLower().Trim(); string col = ddlColumns.Text.ToStr().Trim().ToLower(); if (searchTxt.Length < 3) { searchTxt = string.Empty; } bool col_lost = false; bool col_Decs = false; bool col_Name = false; if (col == "lost no") { col_lost = true; } if (col == "item description") { col_Decs = true; } if (col == "customer") { col_Name = true; } var query = from a in General.GetQueryable <LostProperty>(null) where (col_lost && (a.LPNo.ToLower().Contains(searchTxt) || searchTxt == string.Empty)) || (col_Decs && (a.Complaint.ToLower().Contains(searchTxt) || searchTxt == string.Empty)) || (col_Name && (a.CustomerName.ToLower().Contains(searchTxt) || searchTxt == string.Empty)) select new { Id = a.Id, LPNo = a.LPNo, LPDate = a.ReportedDate, LostDate = a.LostDate, CustomerName = a.CustomerName, ItemDecs = a.Complaint }; grdLister.DataSource = query.ToList(); } catch (Exception ex) { ENUtils.ShowErrorMessage(ex.Message); } }
private void btnSendEmail_Click(object sender, EventArgs e) { try { GenerateReport(); if (this.ClsCashAccSummaryBindingSource.Count > 0) { General.ShowEmailForm(reportViewer1, "Cash Account Report"); } } catch (Exception ex) { ENUtils.ShowErrorMessage(ex.Message); } }
private void grid_CommandCellClick(object sender, EventArgs e) { try { GridCommandCellElement gridCell = (GridCommandCellElement)sender; if (gridCell.ColumnInfo.Name.ToLower() == "btndelete") { if (DialogResult.Yes == RadMessageBox.Show("Are you sure you want to delete Invoice ? ", "", MessageBoxButtons.YesNo, RadMessageIcon.Question)) { //objMaster.GetByPrimaryKey(grdLister.CurrentRow.Cells["InvoiceId"].Value.ToLong()); grdLister.CurrentRow.Delete(); //int InvoiceId = grdLister.CurrentRow.Cells["InvoiceId"].Value.ToInt(); //(new TaxiDataContext()).stp_DeleteInvoicePayment(InvoiceId); //LoadInvoiceList(); } } else if (gridCell.ColumnInfo.Name.ToLower() == "btninfo") { ViewInfo(); } else if (gridCell.ColumnInfo.Name.ToLower() == "btnpay") { try { //frmInvoicePayment frm = new frmInvoicePayment(id, InvoiceNo, Total); frmPayment frm = new frmPayment(gridCell.RowInfo.Cells["CompanyId"].Value.ToInt(), gridCell.RowInfo.Cells["Id"].Value.ToInt()); frm.MaximizeBox = false; frm.ShowDialog(); frm.Dispose(); LoadInvoiceList(); } catch (Exception ex) { ENUtils.ShowMessage(ex.Message); } } } catch (Exception ex) { ENUtils.ShowErrorMessage(ex.Message); } }
private void LoadRentList() { try { string searchTxt = txtSearch.Text.ToStr().ToLower().Trim(); string col = ddlColumns.Text.ToStr().Trim().ToLower(); if (searchTxt.Length < 3) { searchTxt = string.Empty; } bool col_No = false; bool col_DriverName = false; if (col == "driver no") { col_No = true; } if (col == "driver name") { col_DriverName = true; } var query = from a in General.GetQueryable <Fleet_Driver>(c => c.IsActive == true && c.DriverTypeId == 1).AsEnumerable() where (col_No && (a.DriverNo.ToLower().Contains(searchTxt) || searchTxt == string.Empty)) || (col_DriverName && (a.DriverName.ToLower().Contains(searchTxt) || searchTxt == string.Empty)) select new { Id = a.Id, No = a.DriverNo, Name = a.DriverName, MobileNo = a.MobileNo, LastDate = a.DriverRents.Count > 0 ? a.DriverRents[a.DriverRents.Count - 1].TransDate : null, TotalRentCount = a.DriverRents.Count > 0 ? Convert.ToSingle(a.DriverRents.Count).ToStr() : "" }; grdLister.DataSource = query.AsEnumerable().OrderBy(item => item.No, new NaturalSortComparer <string>()).ToList(); } catch (Exception ex) { ENUtils.ShowErrorMessage(ex.Message); } }
private void LoadCommisionList() { try { string searchTxt = txtSearch.Text.ToStr().ToLower().Trim(); string col = ddlColumns.Text.ToStr().Trim().ToLower(); if (searchTxt.Length < 3) { searchTxt = string.Empty; } var query = from a in General.GetQueryable <Fleet_DriverCommision>(c => c.DriverId == DriverId) orderby a.TransDate descending select new { Id = a.Id, a.AddOn, a.EditOn, UpdateBy = a.EditOn != null ? a.EditLog : a.AddLog, Holiday = a.WeekOff != null && a.WeekOff == true ?"Off":"Active", DriverNo = a.Fleet_Driver.DriverNo, Driver = a.Fleet_Driver.DriverName, TransNo = a.TransNo, TransDate = a.TransDate, From = a.FromDate, Till = a.ToDate, DriverID = a.DriverId, Owed = a.DriverOwed, Balance = a.Balance, // TransactionFor = a.TransFor //JobsTotal = a.JobsTotal }; grdLister.DataSource = query.ToList(); } catch (Exception ex) { ENUtils.ShowErrorMessage(ex.Message); } }
void grdLister_CellDoubleClick(object sender, GridViewCellEventArgs e) { try { if (grdLister.CurrentRow != null && grdLister.CurrentRow is GridViewDataRowInfo) { this.SelectedFares = grdLister.CurrentRow.Cells["Fares"].Value.ToDecimal(); this.SeletedMiles = grdLister.CurrentRow.Cells["miles"].Value.ToString(); this.SelectedTime = grdLister.CurrentRow.Cells["Miniuts"].Value.ToString(); } this.Close(); } catch (Exception ex) { ENUtils.ShowErrorMessage(ex.Message); } }
private void btnAddSMSTemplet_Click(object sender, EventArgs e) { try { string error = string.Empty; string Templet = TxtSMSTemplet.Text.ToStr(); if (Templet == "") { error += "Required : Templet"; } if (!string.IsNullOrEmpty(error)) { ENUtils.ShowMessage(error); return; } GridViewRowInfo row = null; if (grdSMSTemplets.CurrentRow != null) { row = grdSMSTemplets.CurrentRow; } else { row = grdSMSTemplets.Rows.AddNew(); } row.Cells[COL_SMSTEMPLET.Tempplet].Value = Templet; ClearTemplet(); TxtSMSTemplet.Select(); } catch (Exception ex) { ENUtils.ShowErrorMessage(ex.Message); } }
private void btnExportPDF_Click(object sender, EventArgs e) { try { ViewReport(); if (this.DataSource.Count > 0) { ExportSummaryReport(TypeReport); } else { ENUtils.ShowMessage("Data Not Found"); } } catch (Exception ex) { ENUtils.ShowErrorMessage(ex.Message); } }
private void btnSendEmail_Click(object sender, EventArgs e) { try { ViewReport(); if (this.DataSource.Count > 0) { General.ShowEmailForm(reportViewer1, "Driver Summary Report# " + TypeReport); } else { ENUtils.ShowMessage("Data Not Found"); } } catch (Exception ex) { ENUtils.ShowErrorMessage(ex.Message); } }
private void LoadRentList() { try { string searchTxt = txtSearch.Text.ToStr().ToLower().Trim(); string col = ddlColumns.Text.ToStr().Trim().ToLower(); if (searchTxt.Length < 3) { searchTxt = string.Empty; } var query = from a in General.GetQueryable <DriverRent>(c => c.DriverId == DriverId) select new { Id = a.Id, a.AddOn, a.EditOn, UpdateBy = a.EditOn != null ? a.EditLog : a.AddLog, Driver = a.Fleet_Driver.DriverNo, TransNo = a.TransNo, TransDate = a.TransDate, From = a.FromDate, Till = a.ToDate, DriverID = a.DriverId, Balance = a.Balance, //JobsTotal = a.JobsTotal }; grdLister.DataSource = query.ToList(); } catch (Exception ex) { ENUtils.ShowErrorMessage(ex.Message); } }
private void frmDriverCommissionReport_KeyDown(object sender, KeyEventArgs e) { try { if (e.KeyCode == Keys.Enter && ddlCompany.SelectedValue.ToInt() != 0) { //if (ChkCommission.Checked == false) //{ // ViewReport(); //} //else //{ // ViewReportCommissionWise(); //} } } catch (Exception ex) { ENUtils.ShowErrorMessage(ex.Message); } }
void grdLister_CellClick(object sender, GridViewCellEventArgs e) { try { if (e.Row != null && e.Row is GridViewDataRowInfo) { // yui_3_18_1_4_1430521781421_6239 string min = grdLister.CurrentRow.Cells["miles"].Value.ToString(); HtmlElement[] list = webBrowser1.Document.GetElementsByTagName("div").OfType <HtmlElement>().ToArray <HtmlElement>(); foreach (var item in list) { if (item.InnerHtml != null && item.InnerHtml.Contains(min)) { item.InvokeMember("click"); } } } } catch (Exception ex) { ENUtils.ShowErrorMessage(ex.Message); } //try //{ // if (grdLister.CurrentRow != null && grdLister.CurrentRow is GridViewDataRowInfo) // { // this.SelectedFares = grdLister.CurrentRow.Cells["Fares"].Value.ToDecimal(); // this.SeletedMiles = grdLister.CurrentRow.Cells["miles"].Value.ToString(); // this.SelectedTime = grdLister.CurrentRow.Cells["Miniuts"].Value.ToString(); // } // this.Close(); //} //catch (Exception ex) //{ // ENUtils.ShowErrorMessage(ex.Message); //} }
private void LoadCommisionList() { try { string searchTxt = txtSearch.Text.ToStr().ToLower().Trim(); string col = ddlColumns.Text.ToStr().Trim().ToLower(); if (searchTxt.Length < 3) { searchTxt = string.Empty; } var query = from a in General.GetQueryable <Fleet_DriverCommision>(c => c.DriverId == DriverId) select new { Id = a.Id, TransNo = a.TransNo, TransDate = a.TransDate, DriverNo = a.Fleet_Driver.DriverNo, Driver = a.Fleet_Driver.DriverName, DriverID = a.DriverId, Owed = a.DriverOwed, Balance = a.Balance, TransactionFor = a.TransFor //JobsTotal = a.JobsTotal }; grdLister.DataSource = query.ToList(); } catch (Exception ex) { ENUtils.ShowErrorMessage(ex.Message); } }
private void rdoGraphVehicles_Click(object sender, EventArgs e) { try { string DateType = ""; int Month = 0; int Year = 0; DateTime?FromDate = dtpFromDate.Value.ToDateorNull(); DateTime?TillDate = dtpTillDate.Value.ToDateorNull(); TillDate = TillDate + TimeSpan.Parse("23:59:59"); if (rdoDateCriteria.IsChecked == true) { frmMultiGraphsReports frm = new frmMultiGraphsReports(ddlUsers.SelectedValue.ToInt(), DayName, "VEHICLE", DateType, Month, Year, FromDate.ToDateTime(), TillDate.ToDateTime()); DockWindow doc = UI.MainMenuForm.MainMenuFrm.GetDockByName("frmMultiGraphsReports1"); if (doc != null) { doc.Close(); } MainMenuForm.MainMenuFrm.ShowForm(frm); } else { ENUtils.ShowMessage("Select Date Criteria from Multi Graphs"); } } catch (Exception ex) { ENUtils.ShowErrorMessage(ex.Message); } }
private void LoadCommisionList() { try { string searchTxt = txtSearch.Text.ToStr().ToLower().Trim(); string col = ddlColumns.Text.ToStr().Trim().ToLower(); if (searchTxt.Length < 3) { searchTxt = string.Empty; } bool col_No = false; bool col_DriverName = false; if (col == "driver no") { col_No = true; } if (col == "driver name") { col_DriverName = true; } //var query = from a in General.GetQueryable<Fleet_Driver>(c => c.IsActive == true && c.DriverTypeId == 2).AsEnumerable() // where // (col_No && (a.DriverNo.ToLower().Contains(searchTxt) || searchTxt == string.Empty)) // || (col_DriverName && (a.DriverName.ToLower().Contains(searchTxt) || searchTxt == string.Empty)) // select new // { // Id = a.Id, // No = a.DriverNo, // Name = a.DriverName, // MobileNo = a.MobileNo, // LastDate = a.Fleet_DriverCommisions.Count > 0 ? a.Fleet_DriverCommisions[a.Fleet_DriverCommisions.Count - 1].TransDate : null // }; using (TaxiDataContext db = new TaxiDataContext()) { var query = from a in db.GetTable <Fleet_Driver>().Where(c => c.DriverTypeId == 2 && c.IsActive == true) join b in db.GetTable <Fleet_DriverCommision>() on a.Id equals b.DriverId into table2 from b in table2.DefaultIfEmpty().OrderByDescending(c => c.TransDate).Take(1) where ( (col_No && (a.DriverNo.ToLower().Contains(searchTxt) || searchTxt == string.Empty)) || (col_DriverName && (a.DriverName.ToLower().Contains(searchTxt) || searchTxt == string.Empty)) ) select new { Id = a.Id, No = a.DriverNo, Name = a.DriverName, MobileNo = a.MobileNo, LastDate = b != null ? b.TransDate : null }; grdLister.DataSource = query.AsEnumerable().OrderBy(item => item.No, new NaturalSortComparer <string>()).ToList(); } // db.Dispose(); } catch (Exception ex) { ENUtils.ShowErrorMessage(ex.Message); } }
private void PopulateGraph() { try { string DateStatus = ""; DateTime FromDate = DateTime.Now.ToDate(); DateTime TillDate = DateTime.Now.ToDate(); DateTime Last_WK_FromDate = DateTime.Now.ToDate(); DateTime Last_WK_TillDate = DateTime.Now.ToDate(); using (Taxi_Model.TaxiDataContext db = new TaxiDataContext()) { if (DateType == "CURRENT_WEEK") { FromDate = DateTime.Now.GetStartOfCurrentWeek().ToDate(); TillDate = DateTime.Now.GetEndOfCurrentWeek().ToDate(); Last_WK_FromDate = DateTime.Now.GetStartOfCurrentWeek().ToDate().AddDays(-7); Last_WK_TillDate = DateTime.Now.GetStartOfCurrentWeek().ToDate().AddDays(-1); DateStatus = " For " + string.Format("{0:dd/MM/yyyy}", FromDate.ToDate()) + " to " + string.Format("{0:dd/MM/yyyy}", TillDate.ToDate()); } //else if (DateType == "LAST_WEEK") //{ //} else if (DateType == "MONTHLY") { FromDate = new DateTime(Year, Month, 1); TillDate = new DateTime(Year, Month, DateTime.DaysInMonth(Year, Month)); //Last_WK_FromDate = new DateTime(Year, Month - 1, 1); //Last_WK_TillDate = new DateTime(Year, Month - 1, DateTime.DaysInMonth(Year, Month - 1)); DateStatus = " For " + string.Format("{0:dd/MM/yyyy}", FromDate.ToDate()) + " to " + string.Format("{0:dd/MM/yyyy}", TillDate.ToDate()); } else if (DateType == "Datewise") { FromDate = from; TillDate = till; //Last_WK_FromDate = new DateTime(Year, Month - 1, 1); //Last_WK_TillDate = new DateTime(Year, Month - 1, DateTime.DaysInMonth(Year, Month - 1)); DateStatus = " For " + string.Format("{0:dd/MM/yyyy}", FromDate.ToDate()) + " to " + string.Format("{0:dd/MM/yyyy}", TillDate.ToDate()); } else if (DateType == "DAILY") { FromDate = DateTime.Today.ToDateTime(); TillDate = DateTime.Now.ToDateTime(); DateStatus = "For " + string.Format("{0:dd/MM/yyyy}", FromDate.ToDate()) + " to " + string.Format("{0:dd/MM/yyyy}", TillDate.ToDate()); } FromDate = FromDate.ToDate(); TillDate = TillDate.ToDate() + TimeSpan.Parse("23:59:59"); var Value = db.stp_GraphData(User_Id, DayName, ReportType, FromDate, TillDate, Last_WK_FromDate, Last_WK_TillDate).ToList(); if (Value.Count > 0) { if (ReportType == "ACCOUNT_CASH") { //int CashBooking = Value[0].CashBookings.ToInt(); //int AccountBooking = Value[0].AccountBookings.ToInt(); //int[] yValues = { CashBooking, AccountBooking }; //string[] xNames = { "Cash: " + CashBooking, "Account: " + AccountBooking }; //MainChart.Series[0].Points.DataBindXY(xNames, yValues); //MainChart.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Pie; //MainChart.Series[1].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Pie; //lblTop.Text = "Account VS Cash"; //MainChart.Titles[0].Text = "Account VS Cash " + DateStatus; } else if (ReportType == "WEEKLY_JOBS") { //int?[] Totalbookings = Value.Where(c => c.Status == "CurrentWeek").Select(c => c.Total_Booking).ToArray(); //string[] DaysName = Value.Where(c => c.Status == "CurrentWeek").Select(c => c.Days).ToArray(); //MainChart.Series[0].Name = "Job Cureent Week"; //MainChart.Series[0].Points.DataBindXY(DaysName, Totalbookings); //MainChart.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Column; //int?[] LastTotalbookings = Value.Where(c => c.Status == "lastWeek").Select(c => c.Total_Booking).ToArray(); //string[] LastDaysName = Value.Where(c => c.Status == "lastWeek").Select(c => c.Days).ToArray(); //MainChart.Series[1].Name = "History Average"; //MainChart.Series[1].Points.DataBindXY(LastDaysName, LastTotalbookings); //lblTop.Text = "Job History"; //for (int i = 0; i < MainChart.Series[0].Points.Count; i++) //{ // MainChart.Series[0].Points[i].Label = MainChart.Series[0].Points[i].YValues[0].ToStr(); //} //for (int i = 0; i < MainChart.Series[1].Points.Count; i++) //{ // MainChart.Series[1].Points[i].Label = MainChart.Series[1].Points[i].YValues[0].ToStr(); //} //MainChart.Titles[0].Text = "Jobs History " + DateStatus; } else if (ReportType == "DAILY_TOTAL_JOBS") { //int?[] Totalbookings = Value.Where(c => c.Status == "CurrentDay").Select(c => c.Total_Booking).ToArray(); //string[] DaysName = Value.Where(c => c.Status == "CurrentDay").Select(c => c.Days).ToArray(); //MainChart.Series[0].Name = "Job Cureent Day"; //MainChart.Series[0].Points.DataBindXY(DaysName, Totalbookings); //MainChart.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Column; //int?[] LastTotalbookings = Value.Where(c => c.Status == "lastDay").Select(c => c.Total_Booking).ToArray(); //string[] LastDaysName = Value.Where(c => c.Status == "lastDay").Select(c => c.Days).ToArray(); //MainChart.Series[1].Name = "History Average"; //MainChart.Series[1].Points.DataBindXY(LastDaysName, LastTotalbookings); //lblTop.Text = "Job History"; //for (int i = 0; i < MainChart.Series[0].Points.Count; i++) //{ // MainChart.Series[0].Points[i].Label = MainChart.Series[0].Points[i].YValues[0].ToStr(); // MainChart.Series[0].Points[i].Font = new System.Drawing.Font("Trebuchet MS", 10F, System.Drawing.FontStyle.Bold); //} //for (int i = 0; i < MainChart.Series[1].Points.Count; i++) //{ // MainChart.Series[1].Points[i].Label = MainChart.Series[1].Points[i].YValues[0].ToStr(); //} //MainChart.Titles[0].Text = "Jobs History " + DateStatus; } else if (ReportType == "HOUR_JOBS") { //int?[] Totalbookings = Value.Where(c => c.HourStatus == "Today_Hour").Select(c => c.TotalHourBookings).ToArray(); //string[] hour = Value.Where(c => c.HourStatus == "Today_Hour").Select(c => c.OnHour.ToStr()).ToArray(); //MainChart.Series[0].Name = "Today"; //MainChart.Series[0].Points.DataBindXY(hour, Totalbookings); //MainChart.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Column; //int?[] AvgTotalbooking = Value.Where(c => c.HourStatus == "Avg_Hour").Select(c => c.TotalHourBookings).ToArray(); //string[] Avghour = Value.Where(c => c.HourStatus == "Avg_Hour").Select(c => c.OnHour.ToStr()).ToArray(); //MainChart.Series[1].Name = "Average"; //MainChart.Series[1].Points.DataBindXY(Avghour, AvgTotalbooking); //lblTop.Text = "jobs Per Hour"; //for (int i = 0; i < MainChart.Series[0].Points.Count; i++) //{ // MainChart.Series[0].Points[i].Label = MainChart.Series[0].Points[i].YValues[0].ToStr(); //} //for (int i = 0; i < MainChart.Series[1].Points.Count; i++) //{ // MainChart.Series[1].Points[i].Label = MainChart.Series[1].Points[i].YValues[0].ToStr(); //} //MainChart.Titles[0].Text = "jobs Per Hour" + DateStatus; } else if (ReportType == "TOP_BOTTOM_DRIVERS") { //FromDate = FromDate.ToDate(); //TillDate = TillDate.ToDate() + TimeSpan.Parse("23:59:59"); //var DriverList = db.stp_GraphData(User_Id, DayName, ReportType, FromDate, TillDate, Last_WK_FromDate, Last_WK_TillDate).OrderByDescending(c => c.DriverStatus).ToList(); //int?[] Totalbookings = DriverList.Select(c => c.TotalDriverJobs).ToArray(); //string[] Driver = DriverList.Select(c => c.DriverNo).ToArray(); //MainChart.Series[0].Name = "Top Driver"; //MainChart.Series[0].Points.DataBindXY(Driver, Totalbookings); //MainChart.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Column; //for (int i = 0; i < MainChart.Series[0].Points.Count; i++) //{ // MainChart.Series[0].Points[i].Label = MainChart.Series[0].Points[i].YValues[0].ToStr(); //} //for (int i = 0; i < MainChart.Series[1].Points.Count; i++) //{ // MainChart.Series[1].Points[i].Label = MainChart.Series[1].Points[i].YValues[0].ToStr(); //} //MainChart.Titles[0].Text = "Top=Bottom Drivers " + DateStatus; //MainChart.Series[0].Points[3].Color = Color.Orange; //MainChart.Series[0].Points[4].Color = Color.Orange; //MainChart.Series[0].Points[5].Color = Color.Orange; //MainChart.Series[1].Name = "Bottom Driver"; //MainChart.Series[1].Color = Color.Orange; //lblTop.Text = "Top=Bottom Drivers"; } else if (ReportType == "YEARLY_BOOKINGS") { //foreach (var obj in Value.Where(c => c.YearlyStatus == "Cureent_Year")) //{ // DataPoint point = new DataPoint(); // point.Label = obj.TotalMonthlyBooking.ToStr(); // point.AxisLabel = obj.month.ToStr(); // point.LabelForeColor = Color.Navy; // point.YValues[0] = (double)obj.TotalMonthlyBooking; // point.XValue = Convert.ToDouble(obj.month_No); // MainChart.Series[0].Points.Add(point); //} //MainChart.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Line; //foreach (var obj in Value.Where(c => c.YearlyStatus == "Last_Year")) //{ // DataPoint point = new DataPoint(); // point.Label = obj.TotalMonthlyBooking.ToStr(); // point.AxisLabel = obj.month.ToStr(); // point.LabelForeColor = Color.Navy; // point.YValues[0] = (double)obj.TotalMonthlyBooking; // point.XValue = Convert.ToDouble(obj.month_No); // MainChart.Series[1].Points.Add(point); //} //MainChart.Series[1].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Line; //MainChart.Series[0].Name = "Job This Year"; //MainChart.Series[1].Name = "History Average"; //MainChart.Series[0].BorderWidth = 5; //MainChart.Series[1].BorderWidth = 5; //lblTop.Text = "Job This Year/historical"; //MainChart.Titles["Title1"].Text = "Job This Year/historical"; } else if (ReportType == "TOTAL_DESPATCH") { //int?[] TotalDespatch = Value.Select(c => c.TotalDespatch).ToArray(); //string[] Controller = Value.Select(c => c.Despatchby).ToArray(); //MainChart.Series[0].Name = "Top 3 operater(jobs Dispatch)"; //MainChart.Series[0].Points.DataBindXY(Controller, TotalDespatch); //MainChart.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Column; //for (int i = 0; i < MainChart.Series[0].Points.Count; i++) //{ // MainChart.Series[0].Points[i].Label = MainChart.Series[0].Points[i].YValues[0].ToStr(); //} //MainChart.Series[1].Enabled = false; //lblTop.Text = "Jobs Dispatch"; //MainChart.Titles[0].Text = "Jobs Dispatch" + DateStatus; } // else if (ReportType == "TOTAL_TAKEN_All_OPERATOR") // { // int?[] TotalDespatch = Value.Select(c => c.TotalDespatch).ToArray(); // string[] Controller = Value.Select(c => c.ControllerName).ToArray(); // MainChart.Series[0].Name = "All operater(jobs Taken)"; // MainChart.Series[0].Points.DataBindXY(Controller, TotalDespatch); // MainChart.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Column; // var colors = new List<Color> // { // Color.Blue, // Color.Red, // Color.Yellow, // Color.Green, // Color.Pink, // Color.AliceBlue, // Color.Aqua, // Color.Aquamarine, // Color.Azure, // Color.Beige, // Color.Bisque, // Color.BlueViolet, // Color.Chartreuse, // Color.Coral, // Color.Cornsilk, // Color.DarkOrange, // Color.DarkSalmon, // Color.Fuchsia, // Color.Maroon // }; // for (int i = 0; i < MainChart.Series[0].Points.Count; i++) // { // MainChart.Series[0].Points[i].Label = MainChart.Series[0].Points[i].YValues[0].ToStr(); // MainChart.Series[0].Points[i].Color = colors[i]; // MainChart.Series[0].Points[i].Font = new System.Drawing.Font("Trebuchet MS", 10F, System.Drawing.FontStyle.Bold); // } // MainChart.Series[1].Enabled = false; // lblTop.Text = "Jobs Taken"; // MainChart.Titles[1].Text = "Operators"; // MainChart.Titles[2].Text = "No of Bookings"; // MainChart.Titles[0].Text = "Jobs Taken" + DateStatus; // } // else if (ReportType == "WEEKLY_JOBS_TAKEN") // { // int?[] TotalDespatch = Value.Select(c => c.TotalHourBookings).ToArray(); // string User = Value.Select(c => c.ControllerName).FirstOrDefault().ToStrIfEmpty(); // string[] Controller = Value.Select(c => c.OnHour.ToStr()).ToArray(); // MainChart.Series[0].Name = "Weekly Jobs By " + User + ""; // MainChart.Series[0].Points.DataBindXY(Controller, TotalDespatch); // MainChart.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Column; // for (int i = 0; i < MainChart.Series[0].Points.Count; i++) // { // MainChart.Series[0].Points[i].Label = MainChart.Series[0].Points[i].YValues[0].ToStr(); // MainChart.Series[0].Points[i].Font = new System.Drawing.Font("Trebuchet MS", 10F, System.Drawing.FontStyle.Bold); // } // MainChart.Series[1].Enabled = false; // lblTop.Text = "Weekly Jobs"; // MainChart.Titles[0].Text = "Weekly Jobs" + DateStatus; // MainChart.Titles[1].Text = "Week No"; // MainChart.Titles[2].Text = "No of Bookings"; // } // else if (ReportType == "DAILY_JOBS") // { // int?[] TotalDespatch = Value.Select(c => c.TotalHourBookings).ToArray(); // string User = Value.Select(c => c.ControllerName).FirstOrDefault().ToStrIfEmpty(); // int?[] Controller = Value.Select(c => c.OnHour).ToArray(); // MainChart.Series[0].Name = "Daily Jobs By " + User + ""; // MainChart.Series[0].Points.DataBindXY(Controller, TotalDespatch); // MainChart.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Column; // for (int i = 0; i < MainChart.Series[0].Points.Count; i++) // { // MainChart.Series[0].Points[i].Label = MainChart.Series[0].Points[i].YValues[0].ToStr(); // // MainChart.ChartAreas.["ChartArea1"].AxisX.LabelStyle.Font = new System.Drawing.Font("Trebuchet MS", 2.25F, System.Drawing.FontStyle.Bold); // MainChart.Series[0].Points[i].Font = new System.Drawing.Font("Trebuchet MS", 10F, System.Drawing.FontStyle.Bold); // } // //MainChart.Series[1].Font = Font.Bold; // MainChart.Series[1].Enabled = false; // lblTop.Text = "Daily Jobs"; // MainChart.Titles[0].Text = "Daily Jobs" + DateStatus; // MainChart.Titles[1].Text = "Hours"; // MainChart.Titles[2].Text = "No of Bookings"; // } // else if (ReportType == "MONTHLY_JOBS_TAKEN") // { // int?[] TotalDespatch = Value.Select(c => c.Total_Booking).ToArray(); // string User = Value.Select(c => c.ControllerName).FirstOrDefault().ToStrIfEmpty(); // string[] Controller = Value.Select(c => c.Bookingmonth).ToArray(); // MainChart.Series[0].Name = "Monthly Jobs By " + User +""; // MainChart.Series[0].Points.DataBindXY(Controller, TotalDespatch); // MainChart.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Column; // for (int i = 0; i < MainChart.Series[0].Points.Count; i++) // { // MainChart.Series[0].Points[i].Label = MainChart.Series[0].Points[i].YValues[0].ToStr(); // MainChart.Series[0].Points[i].Font = new System.Drawing.Font("Trebuchet MS", 10F, System.Drawing.FontStyle.Bold); // } // MainChart.Series[1].Enabled = false; // lblTop.Text = "Monthly Jobs"; // MainChart.Titles[2].Text = "No of Bookings"; // MainChart.Titles[1].Text = "Month"; // MainChart.Titles[0].Text = "Monthly Jobs" + DateStatus; // } // else if (ReportType == "VEHICLE_EARNING") // { // decimal?[] TotalEarning = Value.Select(c => c.DriverTotalEarning).ToArray(); // string[] Controller = Value.Select(c => c.ControllerName).ToArray(); // MainChart.Series[0].Name = "All Vehicle(Vehicle Earning)"; // MainChart.Series[0].Points.DataBindXY(Controller, TotalEarning); // MainChart.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Column; // for (int i = 0; i < MainChart.Series[0].Points.Count; i++) // { // MainChart.Series[0].Points[i].Label = MainChart.Series[0].Points[i].YValues[0].ToStr(); // MainChart.Series[0].Points[i].Font = new System.Drawing.Font("Trebuchet MS", 10F, System.Drawing.FontStyle.Bold); // } // MainChart.Series[1].Enabled = false; // lblTop.Text = "Vehicle Earning"; // // MainChart.Titles[0].Text = "Jobs Taken" + DateStatus; // MainChart.Titles[1].Text = "Vehicle"; // MainChart.Titles[2].Text = "Bookings"; // } // else if (ReportType == "COMPANY_VEHICLE_EARNING") // { // decimal?[] TotalEarning = Value.Select(c => c.DriverTotalEarning).ToArray(); // string[] Controller = Value.Select(c => c.ControllerName).ToArray(); // MainChart.Series[0].Name = "All Company Vehicle(Company Vehicle Earning)"; // MainChart.Series[0].Points.DataBindXY(Controller, TotalEarning); // MainChart.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Column; // for (int i = 0; i < MainChart.Series[0].Points.Count; i++) // { // MainChart.Series[0].Points[i].Label = MainChart.Series[0].Points[i].YValues[0].ToStr(); // MainChart.Series[0].Points[i].Font = new System.Drawing.Font("Trebuchet MS", 10F, System.Drawing.FontStyle.Bold); // } // MainChart.Series[1].Enabled = false; // lblTop.Text = "Company Vehicle Earning"; // // MainChart.Titles[0].Text = "Jobs Taken" + DateStatus; // MainChart.Titles[1].Text = "Company Vehicle"; // MainChart.Titles[2].Text = "Bookings"; // } // else if (ReportType == "TOTAL_DESPATCH_All_OPERATOR") // { // int?[] TotalDespatch = Value.Select(c => c.TotalDespatch).ToArray(); // string[] Controller = Value.Select(c => c.Despatchby).ToArray(); // MainChart.Series[0].Name = "All operater(jobs Dispatch)"; // MainChart.Series[0].Points.DataBindXY(Controller, TotalDespatch); // MainChart.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Column; // var colors = new List<Color> // { // Color.Blue, // Color.Red, // Color.Yellow, // Color.Green, // Color.Pink, // Color.AliceBlue, // Color.Aqua, // Color.Aquamarine, // Color.Azure, // Color.Beige, // Color.Bisque, // Color.BlueViolet, // Color.Chartreuse, // Color.Coral, // Color.Cornsilk, // Color.DarkOrange, // Color.DarkSalmon, // Color.Fuchsia, // Color.Maroon // }; // for (int i = 0; i < MainChart.Series[0].Points.Count; i++) // { // MainChart.Series[0].Points[i].Label = MainChart.Series[0].Points[i].YValues[0].ToStr(); // MainChart.Series[0].Points[i].Color = colors[i]; // MainChart.Series[0].Points[i].Font = new System.Drawing.Font("Trebuchet MS", 10F, System.Drawing.FontStyle.Bold); // } // MainChart.Series[1].Enabled = false; // lblTop.Text = "Jobs Dispatch"; // MainChart.Titles[1].Text = "Operators"; // MainChart.Titles[2].Text = "No of Bookings"; // MainChart.Titles[0].Text = "Jobs Dispatch" + DateStatus; // } // else if (ReportType == "DRIVER_RECOVERED_BOOKING") // { // int?[] TotalRejectedJobs = Value.Select(c => c.rejectedjobs).ToArray(); // string[] DriverName = Value.Select(c => c.DriverName).ToArray(); // MainChart.Series[0].Name = "Drivers(Recovered Jobs)"; // MainChart.Series[0].Points.DataBindXY(DriverName, TotalRejectedJobs); // MainChart.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Column; // for (int i = 0; i < MainChart.Series[0].Points.Count; i++) // { // MainChart.Series[0].Points[i].Label = MainChart.Series[0].Points[i].YValues[0].ToStr(); // MainChart.Series[0].Points[i].Font = new System.Drawing.Font("Trebuchet MS", 10F, System.Drawing.FontStyle.Bold); // } // MainChart.Series[1].Enabled = false; // lblTop.Text = "Drivers Recovered Jobs"; // MainChart.Titles[1].Text = "Drivers"; // MainChart.Titles[2].Text = "No of Booking"; // MainChart.Titles[0].Text = "Drivers Recovered Jobs" + DateStatus; // } // else if (ReportType == "TOTAL_CALLRECIVE") // { // int?[] TotalCall = Value.Select(c => c.TotalCallRecive).ToArray(); // string[] Controller = Value.Select(c => c.ControllerName).ToArray(); // MainChart.Series[0].Name = "Top 3 operater(Call Received)"; // MainChart.Series[0].Points.DataBindXY(Controller, TotalCall); // MainChart.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Column; // for (int i = 0; i < MainChart.Series[0].Points.Count; i++) // { // MainChart.Series[0].Points[i].Label = MainChart.Series[0].Points[i].YValues[0].ToStr(); // MainChart.Series[0].Points[i].Font = new System.Drawing.Font("Trebuchet MS", 10F, System.Drawing.FontStyle.Bold); // } // MainChart.Series[1].Enabled = false; // lblTop.Text = "Jobs Taken"; // MainChart.Titles[0].Text = "Jobs Taken" + DateStatus; // } // else if (ReportType == "DRIVER_REJECT_BOOKING") // { // int?[] TotalRejectedJobs = Value.Select(c => c.rejectedjobs).ToArray(); // string[] DriverName = Value.Select(c => c.DriverName).ToArray(); // MainChart.Series[0].Name = "Top 3 Drivers(Rejected Jobs)"; // MainChart.Series[0].Points.DataBindXY(DriverName, TotalRejectedJobs); // MainChart.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Column; // for (int i = 0; i < MainChart.Series[0].Points.Count; i++) // { // MainChart.Series[0].Points[i].Label = MainChart.Series[0].Points[i].YValues[0].ToStr(); // MainChart.Series[0].Points[i].Font = new System.Drawing.Font("Trebuchet MS", 10F, System.Drawing.FontStyle.Bold); // } // MainChart.Series[1].Enabled = false; // lblTop.Text = "Drivers Rejected Jobs"; // MainChart.Titles[1].Text = "Drivers"; // MainChart.Titles[2].Text = "No of Booking"; // MainChart.Titles[0].Text = "Drivers Rejected Jobs" + DateStatus; // } // else if (ReportType == "LATE_BOOKING_DISPATCH") // { // int?[] TotallateJobs = Value.Select(c => c.TotalLateBooking).ToArray(); // string[] jobLateBy = Value.Select(c => c.BookingLateBy).ToArray(); // MainChart.Series[0].Name = "Top 3 operator(Late Jobs)"; // MainChart.Series[0].Points.DataBindXY(jobLateBy, TotallateJobs); // MainChart.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Column; // for (int i = 0; i < MainChart.Series[0].Points.Count; i++) // { // MainChart.Series[0].Points[i].Label = MainChart.Series[0].Points[i].YValues[0].ToStr(); // MainChart.Series[0].Points[i].Font = new System.Drawing.Font("Trebuchet MS", 10F, System.Drawing.FontStyle.Bold); // } // MainChart.Series[1].Enabled = false; // lblTop.Text = "Operator Late Jobs"; // MainChart.Titles[0].Text = "Operator Late Jobs" + DateStatus; // } // else if (ReportType == "COMPLAINT_DRIVERS") // { // int?[] TotalComplaints = Value.Select(c => c.TotalCompaintsForDriver).ToArray(); // string[] DriverNameComplaint = Value.Select(c => c.CompalintForDriver).ToArray(); // MainChart.Series[0].Name = "Complaints For Drivers"; // MainChart.Series[0].Points.DataBindXY(DriverNameComplaint, TotalComplaints); // MainChart.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Column; // for (int i = 0; i < MainChart.Series[0].Points.Count; i++) // { // MainChart.Series[0].Points[i].Label = MainChart.Series[0].Points[i].YValues[0].ToStr(); // } // MainChart.Series[1].Enabled = false; // lblTop.Text = "Complaints For Drivers"; // MainChart.Titles[0].Text = "Complaints For Drivers" + DateStatus; // } // else if (ReportType == "COMPLAINT_CONTROLLER") // { // int?[] TotalComplaints = Value.Select(c => c.TotalCompaintsForController).ToArray(); // string[] OperatorNameComplaint = Value.Select(c => c.CompalintForController).ToArray(); // MainChart.Series[0].Name = "Complaints For Operators"; // MainChart.Series[0].Points.DataBindXY(OperatorNameComplaint, TotalComplaints); // MainChart.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Column; // for (int i = 0; i < MainChart.Series[0].Points.Count; i++) // { // MainChart.Series[0].Points[i].Label = MainChart.Series[0].Points[i].YValues[0].ToStr(); // MainChart.Series[0].Points[i].Font = new System.Drawing.Font("Trebuchet MS", 10F, System.Drawing.FontStyle.Bold); // } // MainChart.Series[1].Enabled = false; // lblTop.Text = "Complaints For Operators"; // MainChart.Titles[0].Text = "Complaints For Operators" + DateStatus; // } // else if (ReportType == "DRIVER_TOTAL_EARNING") // { // decimal?[] TotalEarning = Value.Select(c => c.DriverTotalEarning).ToArray(); // string[] DriverName = Value.Select(c => c.EarningDriverName).ToArray(); // MainChart.Series[0].Name = "Top 3 Driver(Earning)"; // MainChart.Series[0].Points.DataBindXY(DriverName, TotalEarning); // MainChart.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Column; // for (int i = 0; i < MainChart.Series[0].Points.Count; i++) // { // MainChart.Series[0].Points[i].Label = MainChart.Series[0].Points[i].YValues[0].ToStr(); // MainChart.Series[0].Points[i].Font = new System.Drawing.Font("Trebuchet MS", 10F, System.Drawing.FontStyle.Bold); // } // MainChart.Series[1].Enabled = false; // lblTop.Text = "Driver Earning"; // MainChart.Titles[0].Text = "Driver Earning" + DateStatus; // } // else if (ReportType == "MONTHLY_BOOKINGS") // { // int?[] Totalbookings = Value.Select(c => c.MonthlyBookings).ToArray(); // string[] MonthName = Value.Select(c => c.Bookingmonth).ToArray(); // MainChart.Series[0].Name = "Monthly Jobs"; // MainChart.Series[0].Points.DataBindXY(MonthName, Totalbookings); // MainChart.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Column; // for (int i = 0; i < MainChart.Series[0].Points.Count; i++) // { // MainChart.Series[0].Points[i].Label = MainChart.Series[0].Points[i].YValues[0].ToStr(); // MainChart.Series[0].Points[i].Font = new System.Drawing.Font("Trebuchet MS", 10F, System.Drawing.FontStyle.Bold); // } // MainChart.Series[0].Points[0].Color = Color.Orange; // // MainChart.Series[0].Points[1].Color = Color.Orange; // MainChart.Series[1].Name = "History Average"; // MainChart.Series[1].Color = Color.Orange; // lblTop.Text = "Monthly Jobs"; // MainChart.Titles[0].Text = "Monthly Jobs" + DateStatus; // } //} //else //{ // ENUtils.ShowMessage("Data Not found.."); // _cond = false; // //frmShowGraphs frm = new frmShowGraphs(); // //DockWindow doc = UI.MainMenuForm.MainMenuFrm.GetDockByName("frmShowGraphs1"); // //if (doc == null) // //{ // // doc.Close(); // //} // //MainMenuForm.MainMenuFrm.ShowForm(frm); //} } } } catch (Exception ex) { ENUtils.ShowErrorMessage(ex.Message); } }
private void LoadMap(string Origin, string Destination, string[] via) { try { string originAddress = Origin; string destinationAddress = Destination; if (AppVars.objPolicyConfiguration.AddFareCalculationType.ToInt() == 1) { Origin = General.GetPostCodeMatch(Origin.ToStr().ToUpper()); Destination = General.GetPostCodeMatch(Destination.ToStr().ToUpper()); } if (string.IsNullOrEmpty(Origin)) { Origin = originAddress; } else { Origin += ", UK"; } if (string.IsNullOrEmpty(Destination)) { Destination = destinationAddress; } else { Destination += ", UK"; } string ViaLoc = ""; for (int i = 0; i < via.Count(); i++) { if (AppVars.objPolicyConfiguration.AddFareCalculationType.ToInt() == 1) { destinationAddress = General.GetPostCodeMatch(via[i].ToStr().ToUpper()); } else { destinationAddress = via[i].ToStr().ToUpper(); } if (string.IsNullOrEmpty(destinationAddress)) { destinationAddress = via[i].ToStr().ToUpper(); } else { destinationAddress += ", UK"; } ViaLoc += "&w" + i.ToStr() + "=" + destinationAddress; } string Url = ""; //if (!string.IsNullOrEmpty(ViaLoc)) // Url = "https://maps.google.com/maps?source=s_d&saddr=" + Origin + ViaLoc + "+&daddr=" + Destination; //else Url = " https://maps.yahoo.com/directions/?o=" + Origin.ToStr().Replace(" ", "+") + "&" + "&d=" + Destination.ToStr().Replace(" ", "+") + ViaLoc.Replace(" ", "+"); //if(!string.IsNullOrEmpty(ViaLoc)) // Url= "https://maps.google.com/maps?source=s_d&saddr=" + Origin + ViaLoc + "+&daddr=" + Destination; //else // Url = "https://maps.google.com/maps?source=s_d&saddr=" + Origin+ "+&daddr=" + Destination; //string ieVersion = Registry.LocalMachine.OpenSubKey(@"Software\Microsoft\Internet Explorer").GetValue("Version").ToStr(); //ieVersion = ieVersion.Substring(0, ieVersion.IndexOf('.')).Trim(); //if (ieVersion.ToDecimal() >= 9) //{ // webBrowser1.Navigate(Url, null, null, "User-Agent: Mozilla/5.0 (compatible; MSIE 9.0)"); //} //else //{ webBrowser1.Navigate(Url); // webBrowser1.Navigate("https://maps.google.co.uk/maps/myplaces?source=s_d&saddr=PENTAX+H+SOUTH+HILL+AVENUE+HARROW+HA2+0DU,+UK+&daddr=HEATHROW+TERMINAL+4,+TW6+2GA,+UK&dg=feature"); // webBrowser1.Navigate(Url); // } //CheckMiles(); } catch (Exception ex) { ENUtils.ShowErrorMessage(ex.Message); } }
private void LoadVehicleList() { try { string searchTxt = txtSearch.Text.ToStr().ToLower().Trim(); string col = ddlColumns.Text.ToStr().Trim().ToLower(); if (searchTxt.Length < 3) { searchTxt = string.Empty; } bool col_VehNo = false; bool col_Qwner = false; bool col_Model = false; bool col_vehType = false; if (col == "vehicle no") { col_VehNo = true; } if (col == "owner") { col_Qwner = true; } if (col == "model no") { col_Model = true; } if (col == "vehicle type") { col_vehType = true; } var query = from a in General.GetQueryable <Fleet_Master>(null) where (col_VehNo && (a.VehicleNo.ToLower().Contains(searchTxt) || searchTxt == string.Empty)) || (col_Qwner && (a.VehicleOwner.ToLower().Contains(searchTxt) || searchTxt == string.Empty)) || (col_Model && (a.VehicleModel.ToLower().Contains(searchTxt) || searchTxt == string.Empty)) || (col_vehType && (a.Fleet_VehicleType.VehicleType.ToLower().Contains(searchTxt) || searchTxt == string.Empty)) select new { Id = a.Id, VehicleID = a.VehicleID, PlateNo = a.Plateno, VehicleNo = a.VehicleNo, Vehicle = a.Fleet_VehicleType.VehicleType, Owner = a.VehicleOwner, Make = a.VehicleMake, Model = a.VehicleModel, Mot = a.MOTExpiryDate, RoadTax = a.RoadTaxExpDate, Insurance = a.InsuranceExpiry, Plate = a.PLateExpiryDate }; grdLister.DataSource = query.ToList(); } catch (Exception ex) { ENUtils.ShowErrorMessage(ex.Message); } }