private void LoadCenters() { DataView dv = ATMDB.GetDataView("up_getCenters", UserName); ddSygmaCenterNo.DataSource = dv; ddSygmaCenterNo.DataBind(); ddSygmaCenterNo.Items.Insert(0, new ListItem("Choose...", "")); if (ddSygmaCenterNo.Items.Count == 2) { ddSygmaCenterNo.SelectedIndex = 1; SetPayRateTypes(); } //ddProgSygmaCenterNo.DataSource = dv; //ddProgSygmaCenterNo.DataBind(); //ddProgSygmaCenterNo.Items.Insert(0, new ListItem("Choose...", "")); ddApsSygmaCenterNo.DataSource = dv; ddApsSygmaCenterNo.DataBind(); ddApsSygmaCenterNo.Items.Insert(0, new ListItem("Choose...", "")); if (ddApsSygmaCenterNo.Items.Count == 2) { ddApsSygmaCenterNo.SelectedIndex = 1; SetPreviewRateAndSchedule(); } }
protected override void LoadATMPage() { if (IsPostBack) { return; } DataView dv = ATMDB.GetDataView("up_getCenters", UserName); ddSygmaCenterNo.DataSource = dv; ddSygmaCenterNo.DataBind(); ddSygmaCenterNo.Items.Insert(0, new ListItem("Choose...", "")); ddSygmaCenterNo.Items.Insert(1, new ListItem("All", "0")); weeklystd(); Quaterlystd(); txtWkyStartDate.Text = (DateTime.Now.AddDays(-Convert.ToInt32(DateTime.Now.DayOfWeek) - 7)).ToShortDateString(); txtWkyEndDate.Text = (DateTime.Now.AddDays(-Convert.ToInt32(DateTime.Now.DayOfWeek) - 1)).ToShortDateString(); DateTime startDate = new DateTime(); DateTime endDate = new DateTime(); string lastQuarter = GetLastQuarterDates(DateTime.Now.Month); SetLastQuarterDates(out startDate, out endDate, lastQuarter); txtQtystartDate.Text = Convert.ToDateTime(startDate).ToString("M/dd/yyyy"); txtQtyEndDate.Text = Convert.ToDateTime(endDate).ToString("M/dd/yyyy"); }
protected void weeklystd() { try { lblWkyCustMessage.Visible = false; lbWkyReasonCodes.Enabled = false; lbWkyReasonCodes.Height = 73; DataView dvReasonCode = ATMDB.GetDataView("up_getSelectedReasonCode"); lbWkyReasonCodes.DataSource = dvReasonCode.Table.DefaultView; lbWkyReasonCodes.DataBind(); foreach (ListItem item in lbWkyReasonCodes.Items) { if (item.Value == "18" || item.Value == "40" || item.Value == "41" || item.Value == "60" || item.Value == "61") { item.Selected = true; } } } catch (Exception) { log.WriteEntryFormat("Error while loading weekly reason codes"); } }
protected void Qty_ReasonCode_CheckedChanged(Object sender, EventArgs e) { try { if (rbQtyStdReasoncodes.Checked) { Quaterlystd(); } if (rbQtyCustReasoncodes.Checked) { lblQtyCustMessage.Visible = true; lbQtyReasonCodes.Enabled = true; DataView dvReasonCode = ATMDB.GetDataView("up_getReasonCode"); lbQtyReasonCodes.DataSource = dvReasonCode.Table.DefaultView; lbQtyReasonCodes.DataBind(); lbQtyReasonCodes.Height = 150; foreach (ListItem item in lbQtyReasonCodes.Items) { if (item.Value == "18" || item.Value == "40" || item.Value == "41" || item.Value == "60" || item.Value == "61") { item.Selected = true; } } } } catch (Exception) { log.WriteEntryFormat("Error while loading Quaterly reason codes"); } }
protected void txtWeekendingDate_TextChanged(object sender, EventArgs e) { lblMessage.Text = ""; DateTime date; if (DateTime.TryParse(txtWeekendingDate.Text, out date)) { lblInvalidDate.Visible = false; if (date >= Convert.ToDateTime("01-01-2001") && date <= Convert.ToDateTime("01-01-2099")) { DataView dvForms = ATMDB.GetDataView("up_p_getFormsByWeekending", ddSygmaCenterNo.SelectedValue, txtWeekendingDate.Text); lbRoutes.DataSource = dvForms; lbRoutes.DataBind(); lbRoutes.Items.Insert(0, "Choose..."); upFormInfo.Update(); } else { txtWeekendingDate.Text = ""; lblInvalidDate.Text = "Invalid Date; Outside available Date Range! "; lblInvalidDate.Visible = true; } } else { lbRoutes.Items.Clear(); if (txtWeekendingDate.Text != "") { lblInvalidDate.Text = "Weekending Date is invalid!"; lblInvalidDate.Visible = true; } txtWeekendingDate.Text = ""; upFormInfo.Update(); } }
private void LoadEmployees() { DataView dv = ATMDB.GetDataView("up_getNonATMEmployees", ddSygmaCenterNo.SelectedValue); ddEmployee.DataSource = dv; ddEmployee.DataBind(); ddEmployee.Items.Insert(0, new ListItem("Choose...", "-1")); }
private void LoadCenters() { DataView dv = ATMDB.GetDataView("up_getCenters", UserName); ddSygmaCenterNo.DataSource = dv; ddSygmaCenterNo.DataBind(); ddSygmaCenterNo.Items.Insert(0, new ListItem("Choose...", "-1")); ddEmployee.Items.Insert(0, new ListItem("Choose...", "-1")); }
protected void ddDepartDay_SelectedIndexChanged(object sender, EventArgs e) { DataView dv = ATMDB.GetDataView("up_getRoutes", UserName, ddSygmaCenterNo.SelectedValue); AddSort(dv); AddNameFilter(dv); gvRoutes.PageSize = RowCountBar1.PageSize; gvRoutes.DataSource = dv; setRoutes(); gvRoutes.DataBind(); }
private void SetPayRateTypes() { if (ddSygmaCenterNo.SelectedValue != "" && ddPayScale.SelectedValue != "") { pnlRates.Visible = true; gvPayRates.DataSource = ATMDB.GetDataView("up_p_getCenterPayScaleRates", ddSygmaCenterNo.SelectedValue, ddPayScale.SelectedValue); gvPayRates.DataBind(); } else { pnlRates.Visible = false; } }
private void LoadCenters() { DataView dv = ATMDB.GetDataView("up_getCenters", UserName); ddProgSygmaCenterNo.DataSource = dv; ddProgSygmaCenterNo.DataBind(); ddProgSygmaCenterNo.Items.Insert(0, new ListItem("Choose...", "")); if (ddProgSygmaCenterNo.Items.Count == 2) { ddProgSygmaCenterNo.SelectedIndex = 1; CenterSelectionIndexChanged(); } }
protected override void LoadATMPage() { var ds = ATMDB.GetDataSet("up_p_getFormCriteria", UserName); var count = ds.Tables[2].Rows.Count; if (IsPostBack) { return; } DataView dv = ATMDB.GetDataView("up_getCenters", UserName); ddSygmaCenterNo.DataSource = dv; ddSygmaCenterNo.DataBind(); ddSygmaCenterNo.Items.Insert(0, new ListItem("Choose...", "")); }
private void SetVehicleTrailerDeprDetails(string gVId, bool gIsVehicle) { DataView dvVehicleTrailerDeprDetails = ATMDB.GetDataView("up_p_getVehicleTrailerDeprDetails", gVId, gIsVehicle); if (dvVehicleTrailerDeprDetails.Count > 0) { lblVehicleTrailerName.Text = dvVehicleTrailerDeprDetails[0]["VehicleName"].ToString(); if (!Convert.IsDBNull(dvVehicleTrailerDeprDetails[0]["InServiceDate"])) { txtInServiceDate.Text = Convert.ToDateTime(dvVehicleTrailerDeprDetails[0]["InServiceDate"]).ToShortDateString(); } if (!Convert.IsDBNull(dvVehicleTrailerDeprDetails[0]["DeprStartDate"])) { txtDeprStartDate.Text = Convert.ToDateTime(dvVehicleTrailerDeprDetails[0]["DeprStartDate"]).ToShortDateString(); } if (!Convert.IsDBNull(dvVehicleTrailerDeprDetails[0]["DeprEndDate"])) { txtDeprEndDate.Text = Convert.ToDateTime(dvVehicleTrailerDeprDetails[0]["DeprEndDate"]).ToShortDateString(); } txtDeprMonths.Text = dvVehicleTrailerDeprDetails[0]["DeprMonths"].ToString(); txtCost.Text = dvVehicleTrailerDeprDetails[0]["Cost"].ToString(); txtMonthlyDepreciation.Text = dvVehicleTrailerDeprDetails[0]["MonthlyDepreciation"].ToString(); double currentBookValue = 0; if (!Convert.IsDBNull(dvVehicleTrailerDeprDetails[0]["InServiceDate"]) && dvVehicleTrailerDeprDetails[0]["MonthlyDepreciation"].ToString() != "") { DateTime InServiceDate = Convert.ToDateTime(dvVehicleTrailerDeprDetails[0]["InServiceDate"]); DateTime currentDate = DateTime.Now; double monthsFromInSerDate = (currentDate.Year - InServiceDate.Year) * 12 + currentDate.Month - InServiceDate.Month + (currentDate.Day >= InServiceDate.Day ? 0 : -1); double monthlyDepreciation = Convert.ToDouble(dvVehicleTrailerDeprDetails[0]["MonthlyDepreciation"]); currentBookValue = monthlyDepreciation * monthsFromInSerDate; lblCurrentBookValueValue.Text = currentBookValue.ToString("N2"); } else { lblCurrentBookValueValue.Text = currentBookValue.ToString("N2"); } } else { pnlDeprDetails.Visible = false; lblNoRecordExist.Text = "No Record exist!"; lblNoRecordExist.Visible = true; } }
protected override void LoadATMPage() { //if funcid is passed in then it should be an ajax request if (!string.IsNullOrEmpty(Request.QueryString.Get("funcid"))) { ATMDB.RunNonQuery("up_user_setStartFunction", UserName, Request.QueryString.Get("funcid")); } else { DataView dv = ATMDB.GetDataView("up_user_getUserInfo", UserName); if (dv.Count > 0) { if (!Convert.IsDBNull(dv[0]["RootUrl"])) { Response.Redirect(dv[0]["RootUrl"].ToString()); } } } }
protected void txtEmplID_TextChanged(object sender, EventArgs e) { if (txtEmplID.Text != "" && txtEmplID.Text.Length == 8) { DataView dvEmplName = ATMDB.GetDataView("up_checkEmplId", txtEmplID.Text); if (dvEmplName.Count < 1) { txtEmplID.Text = ""; ScriptManager.RegisterStartupScript(this, this.GetType(), "focus", "document.getElementById('" + this.txtEmplID.ClientID + "').focus();", true); } } else { txtEmplID.Text = ""; ScriptManager.RegisterStartupScript(this, this.GetType(), "focus", "document.getElementById('" + this.txtEmplID.ClientID + "').focus();", true); } }
private void SetAPSchedule() { if (ddApsSygmaCenterNo.SelectedIndex > 0) { DataView dv = ATMDB.GetDataView("up_getAutoProgressionSchedule", ddApsSygmaCenterNo.SelectedValue); pnlApsSchedule.Visible = true; rptApsSchedule.DataSource = dv; rptApsSchedule.DataBind(); hlAddProgressionBand.Style["display"] = "block"; //hlAddProgressionBand.Attributes.Add("onmouseover", "this.style.backgroundColor= 'FFF111'"); //hlAddProgressionBand.Attributes.Add("onmouseout", "this.style.backgroundColor= 'Navy'"); if (dv.Table.Rows.Count > 0) { hlClearProgressionBand.Style["display"] = "block"; lblClearAll.Style["display"] = "block"; hlRemoveLastBand.Style["display"] = "block"; lblRemove.Style["display"] = "block"; hlUpdateNow.Style["display"] = "block"; lblUpdateNow.Style["display"] = "block"; } else { hlClearProgressionBand.Style["display"] = "none"; lblClearAll.Style["display"] = "none"; hlRemoveLastBand.Style["display"] = "none"; lblRemove.Style["display"] = "none"; hlUpdateNow.Style["display"] = "none"; lblUpdateNow.Style["display"] = "none"; } } else { pnlApsSchedule.Visible = false; hlAddProgressionBand.Style["display"] = "none"; hlClearProgressionBand.Style["display"] = "none"; lblClearAll.Style["display"] = "none"; hlRemoveLastBand.Style["display"] = "none"; lblRemove.Style["display"] = "none"; hlUpdateNow.Style["display"] = "none"; lblUpdateNow.Style["display"] = "none"; } }
private void SetEmployees() { if (ddProgSygmaCenterNo.SelectedIndex > 0) { gIsApsEnabledSygmaCenterNo = Convert.ToBoolean(ATMDB.GetScalar("up_p_isApsEnabledCenter", ddProgSygmaCenterNo.SelectedValue)); DataSet dsClassification = ATMDB.GetDataSet("up_p_getCentersAndClassifications"); dtClassifications = dsClassification.Tables[1]; DataView dv = ATMDB.GetDataView("up_getEmployees", UserName, ddProgSygmaCenterNo.SelectedValue); AddSort(dv); AddNameFilter(dv); gvEmployees.DataSource = dv; gvEmployees.DataBind(); pnlProgression.Visible = true; lblEmployeeCount.Text = dv.Count.ToString(); } else { pnlProgression.Visible = false; } }
private void SetVehicles() { if (ddProgSygmaCenterNo.SelectedIndex > 0) { DataView dvVehicles = ATMDB.GetDataView("up_getVehicles", UserName, ddProgSygmaCenterNo.SelectedValue); DataView dvTrailers = ATMDB.GetDataView("up_getTrailers", UserName, ddProgSygmaCenterNo.SelectedValue); DataTable dtVehicles = dvVehicles.ToTable(); DataTable dtTrailers = dvTrailers.ToTable(); dtVehicles.Merge(dtTrailers); dtVehicles.AcceptChanges(); DataView dvVehicleTrailer = new DataView(dtVehicles); DataSet dsTypeMakeStatusObject = ATMDB.GetDataSet("up_getVehicle_Type_Make_Status_ObjectType"); dtVehicleType = dsTypeMakeStatusObject.Tables[0]; dtVehicleMake = dsTypeMakeStatusObject.Tables[1]; dtVehicleStatus = dsTypeMakeStatusObject.Tables[2]; dtVehicleObjectType = dsTypeMakeStatusObject.Tables[3]; DataView dvSygmaCenter = ATMDB.GetDataView("up_getCenters"); dtSygmaCenter = dvSygmaCenter.ToTable(); LoadYear(); LoadReplacedYear(); AddSort(dvVehicleTrailer); AddNameFilter(dvVehicleTrailer); AddNameFilter(dvVehicles); AddNameFilter(dvTrailers); gvVT.PageSize = (VehicleTrailerRowCountBar1.PageSize > 0) ? VehicleTrailerRowCountBar1.PageSize : 50; gvVT.DataSource = dvVehicleTrailer; gvVT.DataBind(); pnlProgression.Visible = true; VehicleTrailerRowCountBar1.VehiclesCount = dvVehicles.Count; VehicleTrailerRowCountBar1.TrailersCount = dvTrailers.Count; VehicleTrailerRowCountBar1.ItemCount = dvVehicles.Count + dvTrailers.Count; } else { pnlProgression.Visible = false; } }
private void SetCenters() { lbCenters.DataSource = ATMDB.GetDataView("up_getCenters"); lbCenters.DataBind(); lbCenters.Items.Insert(0, new ListItem("All", "0")); }
private void setRoutes() { if (ddSygmaCenterNo.SelectedIndex > 0) { DataSet dsPayScales = ATMDB.GetDataSet("up_p_getPayScales"); dtPayScales = dsPayScales.Tables[0]; DataSet dsDomiciles = ATMDB.GetDataSet("up_p_getDomiciles", ddSygmaCenterNo.SelectedValue); dtDomiciles = dsDomiciles.Tables[0]; dtClassifications = dsDomiciles.Tables[1]; DataSet dsDrivers = ATMDB.GetDataSet("up_p_getDrivers", ddSygmaCenterNo.SelectedValue); dtDrivers = dsDrivers.Tables[0]; DataSet dsHelpers = ATMDB.GetDataSet("up_p_getDriverHelpers", ddSygmaCenterNo.SelectedValue); dtHelpers = dsHelpers.Tables[0]; pnlProgression.Visible = true; //ddAddLocation.DataSource = dtDomiciles; //ddAddLocation.DataBind(); if (dtDomiciles != null) { ddAddLocation.Items.Clear(); ddAddLocation.Items.Add(new ListItem("Choose...", "")); foreach (DataRow rtd in dtDomiciles.Rows) { ListItem liRTD = new ListItem(rtd["LocationName"].ToString(), rtd["LocationId"].ToString()); ddAddLocation.Items.Add(liRTD); } } if (dtClassifications != null) { ddAddClassification.Items.Clear(); ddAddClassification.Items.Add(new ListItem("Choose...", "")); foreach (DataRow rtd in dtClassifications.Rows) { ListItem liRTD = new ListItem(rtd["ClassificationName"].ToString(), rtd["ClassificationId"].ToString()); ddAddClassification.Items.Add(liRTD); } } if (dtDrivers != null) { ddAddDriver.Items.Clear(); ddAddDriver.Items.Add(new ListItem("Choose...", "")); foreach (DataRow rtd in dtDrivers.Rows) { ListItem liRTD = new ListItem(rtd["DriverName"].ToString(), rtd["DriverId"].ToString()); ddAddDriver.Items.Add(liRTD); } } if (dtHelpers != null) { ddAddDriverHelper.Items.Clear(); ddAddDriverHelper.Items.Add(new ListItem("Choose...", "")); foreach (DataRow rtd in dtHelpers.Rows) { ListItem liRTD = new ListItem(rtd["DriverName"].ToString(), rtd["DriverId"].ToString()); ddAddDriverHelper.Items.Add(liRTD); } } ddDepartDay.Items.Clear(); ddDepartDay.Items.Add("Choose..."); ddDepartDay.Items.Add("Sunday"); ddDepartDay.Items.Add("Monday"); ddDepartDay.Items.Add("Tuesday"); ddDepartDay.Items.Add("Wednesday"); ddDepartDay.Items.Add("Thursday"); ddDepartDay.Items.Add("Friday"); ddDepartDay.Items.Add("Saturday"); ddAltDepartDay.Items.Clear(); ddAltDepartDay.Items.Add("Choose..."); ddAltDepartDay.Items.Add("Sunday"); ddAltDepartDay.Items.Add("Monday"); ddAltDepartDay.Items.Add("Tuesday"); ddAltDepartDay.Items.Add("Wednesday"); ddAltDepartDay.Items.Add("Thursday"); ddAltDepartDay.Items.Add("Friday"); ddAltDepartDay.Items.Add("Saturday"); //ddAddDriver.Attributes.Add("onchange", string.Format("UpdateHelper({0}, {1});", ddAddDriver.SelectedValue, ddAddDriver.SelectedItem)); //ddDriver.Attributes.Add("onchange", string.Format("UpdateRouteDetails(this, 5, {0});", row["RouteDetailId"])); //ddAddDriverPayScale.DataSource = dtPayScales; //ddAddDriverPayScale.DataBind(); if (dtPayScales != null) { ddAddDriverPayScale.Items.Clear(); ddAddDriverPayScale.Items.Add(new ListItem("Choose...", "")); foreach (DataRow rtd in dtPayScales.Rows) { ListItem liRTD = new ListItem(rtd["PayScaleDesignator"].ToString(), rtd["PayScaleId"].ToString()); ddAddDriverPayScale.Items.Add(liRTD); } } //ddAddHelperPayScale.DataSource = dtPayScales; //ddAddHelperPayScale.DataBind(); if (dtPayScales != null) { ddAddHelperPayScale.Items.Clear(); ddAddHelperPayScale.Items.Add(new ListItem("Choose...", "")); foreach (DataRow rtd in dtPayScales.Rows) { ListItem liRTD = new ListItem(rtd["PayScaleDesignator"].ToString(), rtd["PayScaleId"].ToString()); ddAddHelperPayScale.Items.Add(liRTD); } } //SetAddRouteControls(dtPayScales, dtDomiciles); DataView dv = ATMDB.GetDataView("up_getRoutes", UserName, ddSygmaCenterNo.SelectedValue); AddSort(dv); AddNameFilter(dv); gvRoutes.PageSize = RowCountBar1.PageSize; gvRoutes.DataSource = dv; gvRoutes.DataBind(); pnlRoutes.Visible = true; //lblRouteCount.Text = dv.Count.ToString(); RowCountBar1.ItemCount = dv.Count; } else { pnlProgression.Visible = false; pnlRoutes.Visible = false; } }
protected void btnExport_Click(object sender, ImageClickEventArgs e) { //try //{ DataView dvVehicleTrailer = ATMDB.GetDataView("up_exportVehicleTrailers", UserName, ddProgSygmaCenterNo.SelectedValue); AddNameFilter(dvVehicleTrailer); object val = null; var textColumnNumbers = new List <int>(); XLWorkbook book = new XLWorkbook(); book.AddWorksheet("VT"); var sheet = book.Worksheet(1); var table = dvVehicleTrailer.ToTable(); var columnCount = table.Columns.Count; var rowCount = table.Rows.Count; var header = sheet.Range(1, 1, 1, columnCount); for (var c = 1; c <= columnCount; c++) { header.Cell(1, c).Value = table.Columns[c - 1].ColumnName; } header.Style.Font.Bold = true; var rowNumber = 2; var columnNumber = 1; var dateTimeCols = getDateTimeColumns(table); for (var r = 0; r < rowCount; r++) { for (var j = 0; j < columnCount; j++) { val = table.Rows[r][j]; if (val != null) { var cell = sheet.Cell(rowNumber, columnNumber); if (val is DateTime) { cell.DataType = XLCellValues.DateTime; var dateFormat = cell.Style.NumberFormat.Format; cell.Value = (DateTime)val; if (string.IsNullOrEmpty(dateFormat.Replace("General", string.Empty))) { cell.Style.NumberFormat.Format = (dateTimeCols.Contains(j)) ? "M/d/yyyy HH:mm" : "M/d/yyyy"; } else { cell.Style.NumberFormat.Format = dateFormat; } } else if (val is short || val is int || val is double || val is decimal || val is byte) { cell.Value = Convert.ToDouble(val); } else { var textVal = val.ToString().Trim(); if (textVal != string.Empty) { cell.SetValue(textVal); if (!textColumnNumbers.Contains(columnNumber)) { textColumnNumbers.Add(columnNumber); } } } } columnNumber++; //incrememnt the excel column } rowNumber++; //increment the excel row columnNumber = 1; } sheet.Columns().AdjustToContents(); textColumnNumbers.ForEach(num => sheet.Column(num).AddIgnoredError(false, false, false, false, false, false, true, false, false)); const char PAD_CHAR = '0'; var fileName = string.Concat("ATM_Vehicle_Trailer_Report_" + ddProgSygmaCenterNo.SelectedValue + "_" + DateTime.Now.Year, DateTime.Now.Month.ToString().PadLeft(2, PAD_CHAR), DateTime.Now.Day.ToString().PadLeft(2, PAD_CHAR), DateTime.Now.Hour.ToString().PadLeft(2, PAD_CHAR), DateTime.Now.Minute.ToString().PadLeft(2, PAD_CHAR), DateTime.Now.Second.ToString().PadLeft(2, PAD_CHAR), ".xlsx"); Web.StreamExcelDocument(book, fileName, Response); Response.Flush(); //Response.End(); HttpContext.Current.ApplicationInstance.CompleteRequest(); //catch (Exception ex) //{ //} }
private void LoadPayScales() { ddPayScale.DataSource = ATMDB.GetDataView("up_p_getPayScales"); ddPayScale.DataBind(); ddPayScale.Items.Insert(0, new ListItem("Choose...", "")); }
private void SetEmployees() { ddEmployee.DataSource = ATMDB.GetDataView("up_getEmployees", UserName); ddEmployee.DataBind(); ddEmployee.Items.Insert(0, new ListItem("Choose...", "")); }
private void SetUsers() { ddUser.DataSource = ATMDB.GetDataView("up_sec_getUsers", UserName); ddUser.DataBind(); ddUser.Items.Insert(0, new ListItem("Choose...", "")); }