protected void gdvDept_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
TextBox txtNewAllow = (TextBox)gdvDept.Rows[e.RowIndex].Cells[1].Controls[0];
TextBox txtNewRate = (TextBox)gdvDept.Rows[e.RowIndex].Cells[2].Controls[0];
//string strSectionName = gdvCart.Rows[e.RowIndex].Cells[2].Text;
//lblMsg.Text = txtNewValu.Text;
try
{
string strExistQty = "select count(*) from all_mst where all_name = '" + txtNewAllow.Text.Trim() + "' and all_id <> " + Convert.ToInt32(Session["intAllowNo"]).ToString();
object intExistCnt = objPayroll.GetScalar(strExistQty);
if (Convert.ToInt32(intExistCnt) > 0)
{
lblMessage.Text = "Record Already Exists...!!!";
SqlDSdept.UpdateCommand = "Update all_mst set all_name = '" + Session["strAllowName"] + "',all_rate = " + Convert.ToDecimal(Session["strAllowRate"]) + " WHERE all_id = " + Session["intAllowNo"];
return;
}
SqlDSdept.UpdateCommand = "Update all_mst set all_name ='" + txtNewAllow.Text.Trim() + "',all_rate = " + Convert.ToDecimal(txtNewRate.Text.Trim()) + " WHERE all_id=" + Session["intAllowNo"];
SqlDSdept.Update();
lblMessage.Text = "RECORD UPDATED SUCCESSFULLY...!!!";
}
catch (Exception ex1)
{
lblMessage.Text = "Access Denied... :: " + ex1.Message;
}
}
protected void gdvDept_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
TextBox txtNewDept = (TextBox)gdvDept.Rows[e.RowIndex].Cells[1].Controls[0];
//string strSectionName = gdvCart.Rows[e.RowIndex].Cells[2].Text;
//lblMsg.Text = txtNewValu.Text;
try
{
string strExistQty = "select count(*) from dept_mst where dept_name = '" + txtNewDept.Text.Trim() + "'";
object intExistCnt = objPayroll.GetScalar(strExistQty);
if (Convert.ToInt32(intExistCnt) > 0)
{
lblMessage.Text = "Record Already Exists...!!!";
SqlDSdept.UpdateCommand = "Update dept_mst set dept_name = '" + Session["strDeptName"] + "' WHERE dept_no = " + Session["intDeptNo"];
return;
}
SqlDSdept.UpdateCommand = "Update dept_mst set dept_name ='" + txtNewDept.Text.Trim() + "' WHERE dept_no=" + Session["intDeptNo"];
SqlDSdept.Update();
lblMessage.Text = "RECORD UPDATED SUCCESSFULLY...!!!";
}
catch (Exception ex1)
{
lblMessage.Text = "Access Denied... :: " + ex1.Message;
}
}
protected void gdvDept_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
TextBox txtNewBank = (TextBox)gdvDept.Rows[e.RowIndex].Cells[1].Controls[0];
TextBox txtNewBrName = (TextBox)gdvDept.Rows[e.RowIndex].Cells[2].Controls[0];
try
{
string strExistQty = "select count(*) from bank_mst where bank_name = '" + txtNewBank.Text.Trim() + "' and bank_id <> " + Convert.ToInt32(Session["intBankNo"]).ToString();
object intExistCnt = objPayroll.GetScalar(strExistQty);
if (Convert.ToInt32(intExistCnt) > 0)
{
lblMessage.Text = "Record Already Exists...!!!";
SqlDSdept.UpdateCommand = "Update bank_mst set bank_name = '" + Session["strBankName"] + "',branch_name = '" + Session["strBrName"].ToString() + "' WHERE bank_id = " + Session["intBankNo"];
return;
}
SqlDSdept.UpdateCommand = "Update bank_mst set bank_name ='" + txtNewBank.Text.Trim() + "',branch_name = '" + txtNewBrName.Text.Trim() + "' WHERE bank_id=" + Session["intBankNo"];
SqlDSdept.Update();
lblMessage.Text = "RECORD UPDATED SUCCESSFULLY...!!!";
}
catch (Exception ex1)
{
lblMessage.Text = "Access Denied... :: " + ex1.Message;
}
}
