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);
}
}