protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Select")
{
int index = Convert.ToInt32(e.CommandArgument);
GridViewRow gvr = GridView1.Rows[index];
string dssn = Server.HtmlDecode(gvr.Cells[3].Text);
txtSSNo.Text = dssn;
DsktpData DtopData = new DsktpData();
if (!string.IsNullOrEmpty(txtSSNo.Text))
{
if (DtopData.checkExistTowerRecord(txtSSNo.Text))
{
string ssn = txtSSNo.Text;
clearPage();
TowerEmpRecord dRec = new TowerEmpRecord();
dRec = DtopData.getTowerEmpData(ssn);
bindTowerRecord(dRec);
}
else
{
clearPage();
infoDiv1.Visible = true;
lblInfo.Text = "There were no records returned for the search criteria.";
}
}
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
ds.Clear();
string lname = string.IsNullOrEmpty(txtSrchLname.Text) ? "" : txtSrchLname.Text;
string fname = string.IsNullOrEmpty(txtSrchFname.Text) ? "" : txtSrchFname.Text;
string empno = "";
clearPage();
string rtrvArg = txtSrchLname.Text;
DsktpData DsktpObj = new DsktpData();
ds = DsktpObj.searchTower(fname, lname, empno);
if (ds.Tables[0].Rows.Count != 0)
{
GridView1.Visible = true;
GridView1.DataSource = ds;
GridView1.DataBind();
GridView1.SelectedIndex = -1;
}
else
{
clearPage();
infoDiv1.Visible = true;
lblInfo.Text = "There were no records returned for the search criteria.";
}
}
protected void btnRetrieve_Click(object sender, EventArgs e)
{
DsktpData DtopData = new DsktpData();
if (!string.IsNullOrEmpty(txtSSNo.Text))
{
if (DtopData.checkExistRecord(txtSSNo.Text))
{
string ssn = txtSSNo.Text;
clearPage();
SpDepRecord dRec = new SpDepRecord();
dRec = DtopData.getSpDepData(ssn);
bindSpDepRecord(dRec);
DataSet ds = DtopData.getSpDepElections(ssn);
grvElections.DataSource = ds;
grvElections.DataBind();
int empno = Convert.ToInt32(txtXrefEmpno.Text);
DataSet ds2 = DtopData.getSpDepNotes(empno, ssn);
grvNotes.DataSource = ds2;
grvNotes.DataBind();
}
else
{
clearPage();
infoDiv1.Visible = true;
lblInfo.Text = "There were no records returned for the search criteria.";
}
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
ds.Clear();
//string fromdt = string.IsNullOrEmpty(txtFromDt.Text) ? "" : txtFromDt.Text;
DateTime dt_from = Convert.ToDateTime(txtFromDt.Text);
//string todate = string.IsNullOrEmpty(txtToDt.Text) ? "" : txtToDt.Text;
DateTime dt_to = Convert.ToDateTime(txtToDt.Text);
DsktpData DsktpObj = new DsktpData();
ds = DsktpObj.getPCAuditLog(dt_from, dt_to);
if (ds.Tables[0].Rows.Count != 0)
{
GridView1.Visible = true;
GridView1.DataSource = ds;
GridView1.DataBind();
GridView1.SelectedIndex = -1;
}
else
{
clearPage();
infoDiv1.Visible = true;
lblInfo.Text = "There were no records returned for the search criteria.";
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
ds.Clear();
string wonum = string.IsNullOrEmpty(txtSrchWOnum.Text) ? "" : txtSrchWOnum.Text;
string proj = string.IsNullOrEmpty(txtSrchType.Text) ? "" : txtSrchType.Text;
proj = proj.ToUpper();
clearPage();
DsktpData DsktpObj = new DsktpData();
ds = DsktpObj.retrieveWorkOrders(wonum, proj);
if (ds.Tables[0].Rows.Count != 0)
{
GridView1.Visible = true;
GridView1.DataSource = ds;
GridView1.DataBind();
GridView1.SelectedIndex = -1;
}
else
{
clearPage();
lblInfo.Text = "There were no records returned for the search criteria.";
infoDiv1.Visible = true;
}
}
protected void btnRetrieve_Click(object sender, EventArgs e)
{
infoDiv1.Visible = false;
DsktpData DtopData = new DsktpData();
if (!string.IsNullOrEmpty(txtSSNo.Text))
{
if (DtopData.checkExistHipCertRecord(txtSSNo.Text))
{
string ssn = txtSSNo.Text;
clearPage();
HipCertRecord rRec = new HipCertRecord();
rRec = DtopData.getHipCertData(ssn);
bindHipCertRecord(rRec);
DataSet ds = DtopData.getHipHistCvg(ssn);
grvCoverage.DataSource = ds;
grvCoverage.DataBind();
DataSet ds2 = DtopData.getHipDeps(ssn);
grvDependents.DataSource = ds2;
grvDependents.DataBind();
}
else
{
clearPage();
infoDiv1.Visible = true;
lblInfo.Text = "There were no records returned for the search criteria.";
}
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
ds.Clear();
string uid = txtUserID.Text.ToUpper();
DsktpData DsktpObj = new DsktpData();
ds = DsktpObj.getTransLog(uid);
if (ds.Tables[0].Rows.Count != 0)
{
GridView1.Visible = true;
GridView1.DataSource = ds;
GridView1.DataBind();
GridView1.SelectedIndex = -1;
}
else
{
clearPage();
infoDiv1.Visible = true;
lblInfo.Text = "There were no records returned for the search criteria.";
}
}
protected void LoadView4(int wonum, string proj)
{
DataSet ds = new DataSet();
ds.Clear();
DataSet ds1 = new DataSet();
ds1.Clear();
proj = proj.ToUpper();
DsktpData DsktpObj = new DsktpData();
ds = DsktpObj.retrieveStatHist(wonum, proj);
if (ds.Tables[0].Rows.Count != 0)
{
grvStatHist.Visible = true;
grvStatHist.DataSource = ds;
grvStatHist.DataBind();
grvStatHist.SelectedIndex = -1;
}
ds1 = DsktpObj.retrieveUserHist(wonum, proj);
if (ds1.Tables[0].Rows.Count != 0)
{
grvUserChanges.Visible = true;
grvUserChanges.DataSource = ds1;
grvUserChanges.DataBind();
grvUserChanges.SelectedIndex = -1;
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
ds.Clear();
int empno = Convert.ToInt32(txtEmpno.Text);
DsktpData DtopData = new DsktpData();
if (!string.IsNullOrEmpty(txtEmpno.Text))
{
if (DtopData.checkExistTermRecord(empno))
{
clearPage();
TermFileRecord dRec = new TermFileRecord();
dRec = DtopData.getTermFileData(empno);
bindTermRecord(dRec);
}
else
{
clearPage();
infoDiv1.Visible = true;
lblInfo.Text = "There were no records returned for the search criteria.";
}
}
else
{
clearPage();
infoDiv1.Visible = true;
lblInfo.Text = "There were no records returned for the search criteria.";
}
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Select")
{
int index = Convert.ToInt32(e.CommandArgument);
GridViewRow gvr = GridView1.Rows[index];
string seqno = Server.HtmlDecode(gvr.Cells[1].Text);
string proj = Server.HtmlDecode(gvr.Cells[3].Text);
txtWOno.Text = seqno;
txtReqType.Text = proj;
DsktpData DtopData = new DsktpData();
if (!string.IsNullOrEmpty(txtWOno.Text) && !string.IsNullOrEmpty(txtReqType.Text))
{
if (DtopData.checkExistWOrecord(Convert.ToInt32(txtWOno.Text), proj))
{
int wonum = Convert.ToInt32(txtWOno.Text);
clearPage();
WOdetailRecord dRec = new WOdetailRecord();
dRec = DtopData.getWOdetailData(wonum, proj);
WOresponseRecord rRec = new WOresponseRecord();
rRec = DtopData.getWOresponseData(wonum, proj);
WOstatusRecord sRec = new WOstatusRecord();
sRec = DtopData.getWOstatusData(wonum, proj);
bindWORecords(dRec, rRec, sRec);
LoadView4(wonum, proj);
//DataSet ds = DtopData.getSpDepElections(ssn);
//grvElections.DataSource = ds;
//grvElections.DataBind();
//int empno = Convert.ToInt32(txtXrefEmpno.Text);
//DataSet ds2 = DtopData.getSpDepNotes(empno, ssn);
//grvNotes.DataSource = ds2;
//grvNotes.DataBind();
}
else
{
infoDiv1.Visible = true;
lblInfo.Text = "There were no records returned for the search criteria.";
}
}
}
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Select")
{
int index = Convert.ToInt32(e.CommandArgument);
GridViewRow gvr = GridView1.Rows[index];
string dssn = Server.HtmlDecode(gvr.Cells[4].Text);
txtSSNo.Text = dssn;
DsktpData DtopData = new DsktpData();
if (!string.IsNullOrEmpty(txtSSNo.Text))
{
if (DtopData.checkExistRetRecord(txtSSNo.Text))
{
string ssn = txtSSNo.Text;
clearPage();
RetPartRecord dRec = new RetPartRecord();
dRec = DtopData.getRetPartData(ssn);
bindRetPartRecord(dRec);
DataSet ds = DtopData.searchRetElects(ssn);
grvElections.DataSource = ds;
grvElections.DataBind();
int empno = Convert.ToInt32(txtEmpNo.Text);
DataSet ds2 = DtopData.searchRetPayHist(ssn);
grvPayments.DataSource = ds2;
grvPayments.DataBind();
DataSet ds3 = DtopData.searchRetPayrollHist(ssn);
grvDeductions.DataSource = ds3;
grvDeductions.DataBind();
}
else
{
infoDiv1.Visible = true;
lblInfo.Text = "There were no records returned for the search criteria.";
}
}
}
}
protected void btnRetrieve_Click(object sender, EventArgs e)
{
DsktpData DtopData = new DsktpData();
if (!string.IsNullOrEmpty(txtSSNo.Text))
{
if (DtopData.checkExistTowerRecord(txtSSNo.Text))
{
string ssn = txtSSNo.Text;
clearPage();
TowerEmpRecord dRec = new TowerEmpRecord();
dRec = DtopData.getTowerEmpData(ssn);
bindTowerRecord(dRec);
}
else
{
clearPage();
infoDiv1.Visible = true;
lblInfo.Text = "There were no records returned for the search criteria.";
}
}
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Select")
{
infoDiv1.Visible = false;
int index = Convert.ToInt32(e.CommandArgument);
GridViewRow gvr = GridView1.Rows[index];
string dssn = Server.HtmlDecode(gvr.Cells[4].Text);
txtSSNo.Text = dssn;
DsktpData DtopData = new DsktpData();
if (!string.IsNullOrEmpty(txtSSNo.Text))
{
if (DtopData.checkExistHipCertRecord(txtSSNo.Text))
{
string ssn = txtSSNo.Text;
clearPage();
HipCertRecord rRec = new HipCertRecord();
rRec = DtopData.getHipCertData(ssn);
bindHipCertRecord(rRec);
DataSet ds = DtopData.getHipHistCvg(ssn);
grvCoverage.DataSource = ds;
grvCoverage.DataBind();
DataSet ds2 = DtopData.getHipDeps(ssn);
grvDependents.DataSource = ds2;
grvDependents.DataBind();
txtSrchLname.Text = "";
txtSrchFname.Text = "";
txtSrchEmpno.Text = "";
}
}
}
}
protected void btnRetrieve_Click(object sender, EventArgs e)
{
DsktpData DtopData = new DsktpData();
if (!string.IsNullOrEmpty(txtSSNo.Text))
{
if (DtopData.checkExistRetRecord(txtSSNo.Text))
{
string ssn = txtSSNo.Text;
clearPage();
RetPartRecord rRec = new RetPartRecord();
rRec = DtopData.getRetPartData(ssn);
bindRetPartRecord(rRec);
DataSet ds = DtopData.searchRetElects(ssn);
grvElections.DataSource = ds;
grvElections.DataBind();
int empno = Convert.ToInt32(txtEmpNo.Text);
DataSet ds2 = DtopData.searchRetPayHist(ssn);
grvPayments.DataSource = ds2;
grvPayments.DataBind();
DataSet ds3 = DtopData.searchRetPayrollHist(ssn);
grvDeductions.DataSource = ds3;
grvDeductions.DataBind();
}
else
{
clearPage();
infoDiv1.Visible = true;
lblInfo.Text = "There were no records returned for the search criteria.";
}
}
}
