public void LoadData()
{
try
{
DataTable dt;
DAC_Employee oDAV_Employe = new DAC_Employee();
dt = oDAV_Employe.SelectEmployee();
String StrInnserHtml = "";
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
StrInnserHtml = StrInnserHtml + "<tr><td>" + dt.Rows[i][1].ToString() +
"</td><td>" + dt.Rows[i][2].ToString() +
"</td><td>" + dt.Rows[i][3].ToString() +
"</td><td>" + dt.Rows[i][4].ToString() +
"</td><td>" +
"</td></tr>";
}
}
divInnerHtml.InnerHtml = StrInnserHtml;
}
catch (Exception ex)
{
throw;
}
}
protected void btnsubmitEmployee_Click(object sender, EventArgs e)
{
try
{
DAC_Employee oDAV_Employee = new DAC_Employee();
REF_Employee oREF_Employee = new REF_Employee();
oREF_Employee.name = nameid.Text;
oREF_Employee.address = addressid.Text;
oREF_Employee.jobtype = jobtyid.Text;
oREF_Employee.basicsal = bsalid.Text;
if (!oREF_Employee.name.Equals(""))
{
oDAV_Employee.Insert(oREF_Employee);
ShowMessage("Data Insert Successfully!");
}
else
{
ShowMessage("Something went wrong! Please try again!");
}
}
catch (Exception ex)
{
ShowMessage("Something went wrong! Please try again!");
}
}
protected void btndelete_Click(object sender, EventArgs e)
{
DAC_Employee oDAC_Employee = new DAC_Employee();
REF_Employee oREF_Employee = new REF_Employee();
oREF_Employee.id = Convert.ToInt32(empID);
oDAC_Employee.Delete(oREF_Employee);
Response.Redirect("./frmViewEmployee.aspx", true);
}
protected void btnupdate_Click(object sender, EventArgs e)
{
DAC_Employee oDAC_Employee = new DAC_Employee();
REF_Employee oREF_Employee = new REF_Employee();
oREF_Employee.id = Convert.ToInt32(empID);
oREF_Employee.name = nameid.Text;
oREF_Employee.address = addressid.Text;
oREF_Employee.jobtype = jobtyid.Text;
oREF_Employee.basicsal = bsalid.Text;
oDAC_Employee.Update(oREF_Employee);
Response.Redirect("./frmViewEmployee.aspx", true);
}
public void LoadData(REF_Employee oREF_Employee)
{
DataTable dt;
DAC_Employee oDAV_Employee = new DAC_Employee();
oREF_Employee.id = Convert.ToInt32(empID);
dt = oDAV_Employee.SelectEmployeesByID(oREF_Employee);
nameid.Text = dt.Rows[0][1].ToString();
addressid.Text = dt.Rows[0][2].ToString();
jobtyid.Text = dt.Rows[0][3].ToString();
bsalid.Text = dt.Rows[0][4].ToString();
btnupdate.Visible = true;
btndelete.Visible = true;
Button1.Visible = false;
}
