public void ApprovalHistory() { using (var dataAccess = new ApprovalDataAccess(null)) { dataAccess.BuildApprovalList(5); } }
private void FillDropdowns() { var t = DateTime.Now; ipMonthSelected.Value = string.Format("{0} {1}", t.ToString("MMMM"), t.Year);; using (var dataAccess = new ApprovalDataAccess(null)) { lbOperationalStatus.Items.AddRange(dataAccess.GetOperationalStatusList().ToArray()); lbFleet.Items.AddRange(dataAccess.GetFleetTypesList(ModuleType.NonRev).ToArray()); } using (var generator = new ParamaterListItemGenerator()) { var owningCountries = generator.GenerateList(ParameterType.OwningCountry, null); var locationCountries = generator.GenerateList(ParameterType.LocationCountry, null); ddlOwningCountry.Items.AddRange(owningCountries.ToArray()); ddlLocationCountry.Items.AddRange(locationCountries.ToArray()); ddlApprovedOwningCountry.Items.AddRange(owningCountries.ToArray()); ddlApprovedLocationCountry.Items.AddRange(locationCountries.ToArray()); ddlApprovedLocationCountry.SelectedIndex = 0; ddlApprovedOwningCountry.SelectedIndex = 0; ddlOwningCountry.SelectedIndex = 0; ddlLocationCountry.SelectedIndex = 0; } }
protected void gvApprovalHistory_Edit(object sender, CommandEventArgs e) { SelectedTab = 1; if ((e.CommandName == "EditItem")) { var historyId = int.Parse(e.CommandArgument.ToString()); pnlHistory.Visible = true; List <OverviewGridRow> historyData; using (var dataAccess = new ApprovalDataAccess(null)) { historyData = dataAccess.BuildApprovalList(historyId); } gvHistory.DataSource = historyData; gvHistory.DataBind(); } }
private void LoadHistory() { var owningCountry = ddlApprovedOwningCountry.SelectedValue; var locationCountry = ddlApprovedLocationCountry.SelectedValue; var selectedMonth = ParseMonthSelected(); using (var dataAccess = new ApprovalDataAccess(null)) { lblLastUpdate.Text = LastUpdatedFromFleetNow.GetLastUpdatedDateTime(dataAccess); upnlUpdatedTime.Update(); var approvalEntries = dataAccess.GetApprovalEntries(owningCountry, locationCountry, selectedMonth); gvApprovalHistory.DataSource = approvalEntries; gvApprovalHistory.DataBind(); } }
protected override bool OnBubbleEvent(object sender, EventArgs args) { var handled = false; if (args is GridViewCommandEventArgs) { var commandArgs = args as GridViewCommandEventArgs; if (commandArgs.CommandName == "ShowVehicle") { var vehicleId = int.Parse(commandArgs.CommandArgument.ToString()); ucOverviewVehicleHistory.SetVehicleHistoryDetails(vehicleId); ucOverviewVehicle.SetVehicleDetails(vehicleId); mpeNonRevOverview.Show(); } handled = true; } if (args is CommandEventArgs) { var commandArgs = args as CommandEventArgs; if (commandArgs.CommandName == "KeepPopupOpen") { mpeNonRevOverview.Show(); handled = true; } } if (args is CommandEventArgs) { var commandArgs = args as CommandEventArgs; if (commandArgs.CommandName == "Approve Vehicles") { var parameters = BuildParameterList(); using (var dataAccess = new ApprovalDataAccess(parameters)) { var vehiclesApproved = int.Parse(commandArgs.CommandArgument.ToString()); var minDaysNonRev = int.Parse(tbMinDaysNonRev.Text); var userId = Rad.Security.ApplicationAuthentication.GetGlobalId(); var approvalId = dataAccess.InsertApproval(userId, ApprovalDateTime, vehiclesApproved, minDaysNonRev); dataAccess.InsertApprovalEntries(approvalId, LastEntryIdsApproved); } ucOverviewGrid.Visible = false; lblUploadMessage.Visible = true; handled = true; } if (commandArgs.CommandName == "IndexChanged") { mpeNonRevOverview.Show(); handled = true; } if (commandArgs.CommandName == UserControls.Phase4.HelpIcons.ExportToExcel.ExportString) { ExportToExcel(); handled = true; } } return(handled); }