protected void Button1_Click(object sender, EventArgs e)
{
DataAccess da = new DataAccess();
SqlDataReader dr = da.GetSingleUser(txtLoignName.Text);
while (dr.Read())
{
prssid = Convert.ToInt32(dr["prss"]);
}
Response.Redirect("FormI9.aspx?id=" + prssid + "&name=" + txtLoignName.Text);
SqlDataReader dr2 = da.GetPRSS(prssid);
while (dr2.Read())
{
prss = Convert.ToInt32(dr2["prss"]);
}
DataContext masterContext = new DataContext(false);
masterContext.Settings.Server = "10.1.1.20";
masterContext.Settings.Partition = "DEV";
masterContext.Settings.PortNumber = 4745;
masterContext.Connect("languest01", "usr5979x01");
masterContext.Clear();
var Condition = PRPF001Exprs.PRSS == prss;
PRPF001 Employee = masterContext.PRPF001.RetrieveItem(Condition);
masterContext.Disconnect();
if (Employee != null)
{
Response.Write(Employee.PRLAST + " " + Employee.PRFIRST + " " + Employee.PRMI + "<BR />" + Employee.PRADDR1 + "<BR />" + Employee.PRCITY +
", " + Employee.PRSTABBR + " " + Employee.PRZIP);
}
}
protected void prpf001Date()
{
DataContext masterContext = new DataContext(false);
masterContext.Settings.Server = "10.1.1.20";
masterContext.Settings.Partition = "DEV";
masterContext.Settings.PortNumber = 4745;
masterContext.Connect("languest01", "usr5979x01");
masterContext.Clear();
var Condition = PRPF001Exprs.PRSS == prss;
PRPF001 Employee = masterContext.PRPF001.RetrieveItem(Condition);
masterContext.Disconnect();
//txtLastName.Text = Employee.PRLAST;
//txtFirstName.Text = Employee.PRFIRST;
//txtMiddle.Text = Employee.PRMI;
//txtAddress.Text = Employee.PRADDR1;
//txtCity.Text = Employee.PRCITY;
//txtState.Text = Employee.PRSTABBR;
//txtZip.Text = Employee.PRZIP.ToString();
txtBirth.Text = formatDate(Employee.PRBRTHDT.ToString());
txtBirthH.Value = formatDate(Employee.PRBRTHDT.ToString());
txtSSN1.Text = Employee.PRSS.ToString().Substring(0, 3);
txtSSN1H.Value = Employee.PRSS.ToString().Substring(0, 3);
txtSSN2.Text = Employee.PRSS.ToString().Substring(3, 2);
txtSSN2H.Value = Employee.PRSS.ToString().Substring(3, 2);
txtSSN3.Text = Employee.PRSS.ToString().Substring(5, 4);
txtSSN3H.Value = Employee.PRSS.ToString().Substring(5, 4);
}
protected void getData(int prssid)
{
DataAccess da = new DataAccess();
SqlDataReader dr2 = da.GetPRSS(prssid);
while (dr2.Read())
{
prss = Convert.ToInt32(dr2["prss"]);
//email = dr2["email"].ToString();
}
DataContext masterContext = new DataContext(false);
masterContext.Settings.Server = "10.1.1.20";
masterContext.Settings.Partition = "DEV";
masterContext.Settings.PortNumber = 4745;
masterContext.Connect("languest01", "usr5979x01");
masterContext.Clear();
var Condition = PRPF001Exprs.PRSS == prss;
PRPF001 Employee = masterContext.PRPF001.RetrieveItem(Condition);
masterContext.Disconnect();
txtLastName.Text = Employee.PRLAST;
txtFirstName.Text = Employee.PRFIRST;
txtMiddle.Text = Employee.PRMI;
txtAddress.Text = Employee.PRADDR1;
txtCity.Text = Employee.PRCITY;
txtState.Text = Employee.PRSTABBR;
txtZip.Text = Employee.PRZIP.ToString();
txtBirth.Text = formatDate(Employee.PRBRTHDT.ToString());
txtSSN1.Text = Employee.PRSS.ToString().Substring(0, 3);
txtSSN2.Text = Employee.PRSS.ToString().Substring(3, 2);
txtSSN3.Text = Employee.PRSS.ToString().Substring(5, 4);
txtEmail.Text = Request["em"];
SqlDataReader dr = da.GetSingleUser(Request["name"]);
while (dr.Read())
{
txtEmail.Text = dr["email"].ToString();
if (dr["UserTxt"].ToString() != "")
{
txtPhone.Text = dr["UserTxt"].ToString().Substring(0, 3) + "-" + dr["UserTxt"].ToString().Substring(3, 3) + "-" + dr["UserTxt"].ToString().Substring(6, 4);
}
}
while (dr.Read())
{
prssid = Convert.ToInt32(dr["prss"]);
}
}
