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"]; } }