public void LoadData()
{
try
{
DataTable dt;
DAC_SalaryService oDAC_SalaryService = new DAC_SalaryService();
dt = oDAC_SalaryService.Selectsalary();
String StrInnserHtml = "";
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
StrInnserHtml = StrInnserHtml + "<tr><td>" + dt.Rows[i][0].ToString() +
"</td><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>" + dt.Rows[i][5].ToString() +
"</td><td><a href='frmSalaryCalculate.aspx?ID=" + dt.Rows[i][0].ToString() + "'>Edit</a></td></tr>";
}
}
divInnerHtml.InnerHtml = StrInnserHtml;
}
catch (Exception ex)
{
throw;
}
}
protected void dropService_SelectedIndexChanged(object sender, EventArgs e)
{
REF_Employee oREF_Employee = new REF_Employee();
oREF_Employee.id = Convert.ToInt32(dropService.SelectedValue.ToString());
DAC_SalaryService oDAC_SalaryService = new DAC_SalaryService();
DataTable dt = oDAC_SalaryService.Selectbasicsalary(oREF_Employee);
BasicSalary = Double.Parse(dt.Rows[0][4].ToString());
Basicsalid.Text = dt.Rows[0][4].ToString();
}
private void LoadService()
{
DataTable dt;
DAC_SalaryService oDAC_SalaryService = new DAC_SalaryService();
dt = oDAC_SalaryService.SelectServiceSalary();
if (dt.Rows.Count > 0)
{
dropService.DataSource = null;
dropService.DataSource = dt;
dropService.DataTextField = "name";
dropService.DataValueField = "id";
dropService.DataBind();
}
}
protected void btnsubmitEmployee_Click1(object sender, EventArgs e)
{
try
{
DAC_SalaryService oDAV_Empsalary = new DAC_SalaryService();
REF_Employee oREF_Employee = new REF_Employee();
oREF_Employee.id = Convert.ToInt32(dropService.SelectedValue.ToString());
oREF_Employee.name = dropService.SelectedItem.ToString();
oREF_Employee.othours = OTid.Text;
oREF_Employee.bonous = Bonousid.Text;
oREF_Employee.salary = netsalid.Text;
oDAV_Empsalary.Insert(oREF_Employee);
ShowMessage("Data Insert successfully!");
}
catch (Exception ex)
{
ShowMessage("Something went wrong! Please try again!");
}
}
protected void btnupdate_Click(object sender, EventArgs e)
{
try {
DAC_SalaryService oDAV_Empsalary = new DAC_SalaryService();
REF_Employee oREF_Employee = new REF_Employee();
oREF_Employee.salaryID = Request.QueryString["ID"];
oREF_Employee.id = Convert.ToInt32(EmpID);
oREF_Employee.name = nameid.Text;
oREF_Employee.othours = OTid.Text;
oREF_Employee.bonous = Bonousid.Text;
oREF_Employee.salary = netsalid.Text;
oDAV_Empsalary.Update(oREF_Employee);
btnupdate.Visible = false;
Button1.Visible = true;
nameid.Visible = false;
dropService.Visible = true;
ShowMessage("Data Insert successfully!");
}catch (Exception ex)
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
nameid.Visible = false;
btnupdate.Visible = false;
if (!IsPostBack)
{
if (Request.QueryString["ID"] != null)
{
btnupdate.Visible = true;
Button1.Visible = false;
nameid.Visible = true;
dropService.Visible = false;
DataTable dt;
DAC_SalaryService oDAC_SalaryService = new DAC_SalaryService();
REF_Employee oREF_Employee = new REF_Employee();
oREF_Employee.salaryID = Request.QueryString["ID"];
salaryID = Request.QueryString["ID"];
dt = oDAC_SalaryService.SelectsalaryByID(oREF_Employee);
oREF_Employee.id = Convert.ToInt32(dt.Rows[0][1].ToString());
nameid.Text = dt.Rows[0][2].ToString();
EmpID = dt.Rows[0][1].ToString();
OTid.Text = dt.Rows[0][3].ToString();
Bonousid.Text = dt.Rows[0][4].ToString();
netsalid.Text = dt.Rows[0][5].ToString();
DataTable tdt = oDAC_SalaryService.SelectsalaryByID(oREF_Employee);
BasicSalary = Double.Parse(tdt.Rows[0][4].ToString());
Basicsalid.Text = tdt.Rows[0][4].ToString();
}
else
{
LoadService();
}
salaryID = Request.QueryString["ID"];
}
}
