private void FillCombo()
{
try
{
using (TaxiDataContext db = new TaxiDataContext())
{
//var listofZones = db.Gen_Zones.Where(c => c.MaxLatitude != null).OrderBy(c => c.OrderNo).ToList();
//ComboFunctions.FillCombo(listofZones, ddlZone, "ZoneName", "Id");
var listofDrvs = (from a in db.Fleet_DriverQueueLists
where a.Status != null && a.Status == true && a.DriverId != null && a.Fleet_Driver.HasPDA == true
select new
{
Id = a.DriverId,
DriverName = a.Fleet_Driver.DriverNo + " - " + a.Fleet_Driver.DriverName
}).ToList();
ComboFunctions.FillCombo(listofDrvs, ddlDriver, "DriverName", "Id");
}
}
catch (Exception ex)
{
}
}
private void FillCombo()
{
ComboFunctions.FillDriverNoCombo(ddl_Driver, c => c.DriverTypeId == 1 && (c.SubcompanyId == AppVars.DefaultDriverSubCompanyId || AppVars.DefaultDriverSubCompanyId == 0));
dtpFromDate.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
dtpTillDate.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.LastDayOfMonthValue());
dtpTillDate.Value = dtpTillDate.Value.Value.AddHours(23).AddMinutes(59);
}
private void FillDriverNoComboIfNull()
{
if (ddlDriver.DataSource == null)
{
ComboFunctions.FillDriverNoCombo(ddlDriver, null);
}
}
private void ddlDriver_Enter(object sender, EventArgs e)
{
if (ddlDriver.DataSource == null)
{
ComboFunctions.FillDriverNoCombo(ddlDriver);
}
}
private void InitializeConstructor()
{
ComboFunctions.FillCompanyCombo(ddlCompany);
ComboFunctions.FillBookingTypeCombo(ddlBookingType);
ddlBookingType.SelectedValue = Enums.BOOKING_TYPES.LOCAL;
dtpInvoiceDate.Value = DateTime.Now.ToDate();
dtpDueDate.Value = DateTime.Now.ToDate().AddMonths(1);
FormatChargesGrid();
grdLister.ShowGroupPanel = false;
grdLister.AutoCellFormatting = true;
grdLister.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
grdLister.ShowRowHeaderColumn = false;
objMaster = new InvoiceBO();
this.SetProperties((INavigation)objMaster);
grdLister.AllowAddNewRow = false;
dtpFromDate.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
dtpTillDate.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.LastDayOfMonthValue());
grdLister.CommandCellClick += new CommandCellClickEventHandler(grdLister_CommandCellClick);
}
private void frmAddNewAddress_Load(object sender, EventArgs e)
{
ComboFunctions.FillZonesCombo(ddlZone);
ddlZone.SelectedValue = this.OldZoneId;
}
public frmCompanyVehcile()
{
InitializeComponent();
InitializeConstructor();
ComboFunctions.FillSubCompanyCombo(ddlSubCompany);
ComboFunctions.FillVehicleTypeCombo(ddlVehicleType);
ComboFunctions.FillVehicleColorsCombo(ddlVehicleColor);
ComboFunctions.FillFuelTypeCombo(ddlFuelType);
btnInsuranceExpiryBrowsing.Click += new EventHandler(btnInsuranceExpiryBrowsing_Click);
btnMOTExpiryBrowsing.Click += new EventHandler(btnMOTExpiryBrowsing_Click);
btnRoadTaxExpiryBrowsing.Click += new EventHandler(btnRoadTaxExpiryBrowsing_Click);
btnPlateExpiryBrowsing.Click += new EventHandler(btnPlateExpiryBrowsing_Click);
btnPlateExpiryBrowsing2.Click += new EventHandler(btnPlateExpiryBrowsing2_Click);
btnPlateExpiryBrowsing3.Click += new EventHandler(btnPlateExpiryBrowsing3_Click);
btnVehicleBookBrowsing.Click += new EventHandler(btnVehicleBookBrowsing_Click);
btnPlateExpiryView.Click += new EventHandler(btnPlateExpiryView_Click);
btnPlateExpiryView2.Click += new EventHandler(btnPlateExpiryView2_Click);
btnPlateExpiryView3.Click += new EventHandler(btnPlateExpiryView3_Click);
btnMOTExpiryView.Click += new EventHandler(btnMOTExpiryView_Click);
btnInsuranceExpiryView.Click += new EventHandler(btnInsuranceExpiryView_Click);
btnRoadTaxExpiryView.Click += new EventHandler(btnRoadTaxExpiryView_Click);
btnVehicleBookView.Click += new EventHandler(btnVehicleBookView_Click);
btnInsuranceExpiryClear.Click += new EventHandler(btnInsuranceExpiryClear_Click);
btnMOTExpiryClear.Click += new EventHandler(btnMOTExpiryClear_Click);
btnPlateExpiryClear.Click += new EventHandler(btnPlateExpiryClear_Click);
btnPlateExpiryClear2.Click += new EventHandler(btnPlateExpiryClear2_Click);
btnPlateExpiryClear3.Click += new EventHandler(btnPlateExpiryClear3_Click);
btnRoadTaxExpiryClear.Click += new EventHandler(btnRoadTaxExpiryClear_Click);
btnVehicleBookClear.Click += new EventHandler(btnVehicleBookClear_Click);
}
private void DdlSubCompanyId_Enter(object sender, EventArgs e)
{
if (ddlSubCompanyId.DataSource == null)
{
ComboFunctions.FillSubCompanyCombo(ddlSubCompanyId);
}
}
private void btnDeleteHistory_Click(object sender, EventArgs e)
{
try
{
int RangeId = ddlDateRange.SelectedValue.ToInt();
if (RangeId == 0)
{
ENUtils.ShowMessage("Please select a DateRange History");
return;
}
using (TaxiDataContext db = new TaxiDataContext())
{
Fleet_DriverCommissionCollectionHistory objHistory = db.GetTable <Fleet_DriverCommissionCollectionHistory>().FirstOrDefault(c =>
(c.Id == RangeId));
if (objHistory != null)
{
db.Fleet_DriverCommissionCollectionHistories.DeleteOnSubmit(objHistory);
db.SubmitChanges();
}
}
ComboFunctions.FillDriverCommissionCollectionHistoryCombo(ddlDateRange);
grdLister.Rows.Clear();
}
catch (Exception ex)
{
ENUtils.ShowMessage(ex.Message);
}
}
private void FillCombos()
{
//ComboFunctions.FillLocationTypeCombo(ddlLocationType,c=>c.Id!=Enums.LOCATION_TYPES.ADDRESS);
ComboFunctions.FillLocationTypeCombo(ddlLocationType);
ComboFunctions.FillZonesCombo(ddlZone);
}
private void InitializeSettings()
{
ComboFunctions.FillSinBinDriversCombo(ddl_Driver);
this.Shown += new EventHandler(frmSinBin_Shown);
this.KeyPreview = true;
this.KeyDown += new KeyEventHandler(frmSinBin_KeyDown);
}
private void FillCombo()
{
ComboFunctions.FillDriverWeeklyRentHistoryCombo(ddlDateRange);
ComboFunctions.FillDriverNoCombo(ddlDriver);
//ComboFunctions.FillDriverNoCombo(ddlDriver, c => c.DriverTypeId == 1);
}
private void FillCombos()
{
ComboFunctions.FillSecGroupsComboExcRoot(ddlGroups);
ComboFunctions.FillSubCompanyCombo(ddlSubCompany);
ThemeList themeList = ThemeResolutionService.GetAvailableThemes();
if (themeList.Count() > 0)
{
ddlThemes.DisplayMember = "ThemeName";
ddlThemes.ValueMember = "ThemeName";
ddlThemes.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
ddlThemes.DataSource = themeList.Distinct().Where(t => !t.ThemeName.EndsWith("*") && t.ThemeName != "BreezeExtended").OrderBy(t => t.ThemeName).ToList();
}
ddlThemes.SelectedIndex = -1;
ddlThemes.NullText = "Select";
ddlGroups.SelectedIndex = -1;
if (ddlSubCompany.Items.Count > 0)
{
chkAllowTransferBooking.Visible = true;
}
}
public frmDrvStreetView()
{
InitializeComponent();
ComboFunctions.FillPDADLoginriverIdCombo(ddl_Driver);
ddl_Driver.KeyUp += new KeyEventHandler(ddl_Driver_KeyUp);
ddl_Driver.KeyDown += new KeyEventHandler(ddl_Driver_KeyDown);
}
private void InitializeSettings()
{
ComboFunctions.FillNonAvailPDADLoginDriverCombo(ddl_Driver);
ddl_Driver.KeyUp += new KeyEventHandler(ddl_Driver_KeyUp);
ddl_Driver.KeyDown += new KeyEventHandler(ddl_Driver_KeyDown);
this.Shown += new EventHandler(frmRecallJob_Shown);
}
private void rptfrmAccountInvoiceSummary_Load(object sender, System.EventArgs e)
{
this.FormTitle = "Account Invoice Summary";
dtpTillDate.Value = DateTime.Now.ToDate();
dtpFromDate.Value = DateTime.Now.ToDate().AddMonths(-1);
ComboFunctions.FillCompanyCombo(ddlCompany);
ddlCompany.Enabled = false;
chkAll.Checked = true;
}
public override void OnNew()
{
txtInvoiceNo.Text = string.Empty;
ComboFunctions.FillCompanyCombo(ddlCompany);
chkDepartmentWise.Checked = false;
chkCostCenterWise.Checked = false;
grdLister.Rows.Clear();
txtInvoiceAmount.Text = string.Empty;
}
void rptfrmCompnayVehicle_Load(object sender, EventArgs e)
{
ComboFunctions.FillSubCompanyCombo(ddlSubCompany);;
if (ddlSubCompany.Items.Count() == 1)
{
ddlSubCompany.SelectedIndex = 0;
}
ComboFunctions.FillVehicleTypeCombo(ddlVehicleType);
}
private void FillCombo()
{
try
{
ComboFunctions.FillThirdPartyCompanyCombo(ddlThirdPartyCompany);
}
catch (Exception ex)
{ }
}
public rptfrmJobActivity()
{
InitializeComponent();
ComboFunctions.FillCompanyCombo(ddlCompany);
dtpFromDate.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
dtpTillDate.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.LastDayOfMonthValue());
}
//void DropDownListElement_TextChanging(object sender, TextChangingEventArgs e)
//{
// //this.ddl_Driver.DropDownListElement.TextBox.cle.Filter = ClearFilterItem;
// //this.ddl_Driver.Filter = FilterItem;
// string s = ddl_Driver.Text;
// this.ddl_Driver.FilterExpression = "DriverName LIKE '%" + s + "%'";
//}
//private bool FilterItem(RadListDataItem item)
//{
// if (item == null)
// return false;
// if (item.Text.Contains(ddl_Driver.DropDownListElement.TextBox.TextBoxItem.Text))
// {
// return true;
// }
// return false;
//}
private void LoadData()
{
try
{
ComboFunctions.FillDriverNoCombo(ddl_Driver);
}
catch (Exception ex)
{
}
}
void frmDriverReport_Load(object sender, EventArgs e)
{
ComboFunctions.FillCompanyCombo(ddlCompany);
ComboFunctions.FillDriverNoComboSorted(ddlDriver);
dtpFromDate.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
dtpTillDate.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.LastDayOfMonthValue());
IsLoaded = true;
}
public frmCompanyCostCenter(int companyId)
{
InitializeComponent();
ComboFunctions.FillCompanyCombo(ddlCompany);
this.Shown += new EventHandler(frmCompanyDepartments_Shown);
objMaster = new CompanyCostCenterBO();
this.SetProperties((INavigation)objMaster);
ddlCompany.SelectedValue = companyId;
this.CompanyId = companyId;
}
private void FillCombo()
{
// ComboFunctions.
ComboFunctions.FillLocationTypeCombo(ddlFromLocType);
ComboFunctions.FillLocationTypeCombo(ddlToLocType);
ComboFunctions.FillVehicleTypeCombo(ddlVehicleType);
// ComboFunctions.FillCompanyCombo(ddlCompany);
ddlFromLocType.SelectedValue = Enums.LOCATION_TYPES.POSTCODE;
ddlToLocType.SelectedValue = Enums.LOCATION_TYPES.POSTCODE;
}
void frmLocations_Load(object sender, EventArgs e)
{
FillDriverNoComboIfNull();
ComboFunctions.FillCompany_AllCombo(ddlAccount);
if (objMaster.Current == null)
{
OnNewAllocation();
}
}
void frmPlotDriver_Shown(object sender, EventArgs e)
{
if (IsPlotting)
{
if (AppVars.objPolicyConfiguration.EnablePDA.ToBool())
{
ComboFunctions.FillFreezePlottedDriverNoCombo(ddl_Driver);
}
else
{
ComboFunctions.FillDriverNoCombo(ddl_Driver);
}
ComboFunctions.FillZonesPlottedCombo(ddlZone);
ComboFunctions.FillVehicleCombo(ddlVehicle);
}
else
{
Pg_Ordering.Item.Visibility = Telerik.WinControls.ElementVisibility.Collapsed;
Pg_Main.Text = "Un-Plot";
ddlZone.Enabled = false;
ddlVehicle.Enabled = false;
lblZone.Enabled = false;
var list1 = General.GetQueryable <Fleet_DriverQueueList>(a => a.DriverId != null && a.Status == true);
var query = from a in list1
orderby a.QueueDateTime
select new
{
Id = a.Id,
DriverNo = a.Fleet_Driver.DriverNo + " - " + a.Fleet_Driver.DriverName,
};
ComboFunctions.FillCombo(query.ToList(), ddl_Driver, "DriverNo", "Id");
}
ddl_Driver.RootElement.Focus();
ddl_Driver.RootElement.Children[0].Focus();
IsFormLoaded = true;
if (DriverId != 0)
{
DriverQueueBO objMaster = new DriverQueueBO();
objMaster.GetByPrimaryKey(DriverId);
ddl_Driver.SelectedValue = objMaster.Current.DriverId.ToInt();
ddlZone.SelectedValue = objMaster.Current.ZoneId.ToInt();
ddlVehicle.SelectedValue = objMaster.Current.FleetMasterId.ToInt();
}
}
public frmPreAccInvoiceReport()
{
InitializeComponent();
this.Load += new EventHandler(frmInvoiceReport_Load);
ComboFunctions.FillCompanyCombo(ddlCompany);
dtpFromDate.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
dtpTillDate.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.LastDayOfMonthValue());
}
public frmShifts()
{
InitializeComponent();
objdriver = new DriverBO();
objMaster = new DriverShiftsBO();
FormateShiftGride();
ComboFunctions.FillDriverNoCombo(ddlDriver);
ComboFunctions.FillDriverShiftsCombo(ddlShifts);
grdShifts.CellDoubleClick += new GridViewCellEventHandler(grdShifts_CellDoubleClick);
grdShifts.CommandCellClick += new CommandCellClickEventHandler(grid_CommandCellClick);
}
private void ddlCompany_SelectedValueChanged(object sender, EventArgs e)
{
if (grdLister.Columns.Count == 0)
{
return;
}
int?companyId = ddlCompany.SelectedValue.ToIntorNull();
if (companyId == null)
{
SetOrderNoColumn(false);
SetPupilNoColumn(false);
SetBookedByColumn(false);
ClearDepartment();
ClearCostCenter();
ClearOrderNo();
}
else
{
Gen_Company obj = General.GetObject <Gen_Company>(c => c.Id == companyId);
if (obj != null)
{
this.companyEmail = obj.Email.ToStr().Trim();
FillDepartmentCombo(obj.Id);
FillCostCenterCombo(obj.Id);
bool orderNo = obj.HasOrderNo.ToBool();
bool pupilNo = obj.HasPupilNo.ToBool();
bool HasBookedBy = obj.HasBookedBy.ToBool();
SetOrderNoColumn(orderNo);
SetPupilNoColumn(pupilNo);
SetBookedByColumn(HasBookedBy);
if (orderNo)
{
var list = General.GetQueryable <Booking>(c => c.CompanyId == obj.Id && (c.OrderNo != null && c.OrderNo != ""))
.Select(args => new { Id = args.OrderNo, OrderNo = args.OrderNo }).Distinct().ToList();
ComboFunctions.FillCombo(list, ddlOrderNo, "OrderNo", "Id");
ddlOrderNo.Visible = true;
label5.Visible = true;
}
else
{
ddlOrderNo.Visible = false;
label5.Visible = false;
}
}
}
}
private void ddlCompany_SelectedIndexChanged(object sender, Telerik.WinControls.UI.Data.PositionChangedEventArgs e)
{
if (IsLoaded == false)
{
return;
}
if (ddlCompany.SelectedValue.ToIntorNull() != null)
{
ComboFunctions.FillCompanyDepartmentCombo(ddlDepartment, c => c.CompanyId == ddlCompany.SelectedValue.ToInt());
}
}
