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...", ""));
}
