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_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string strEmpID = gdvDept.Rows[e.RowIndex].Cells[0].Text;
try
{
/*string strExistQry = "select count(*) from emp_mst where department = " + strdeptID;
* object objExist = objPayroll.GetScalar(strExistQry);
* if (Convert.ToInt32(objExist) > 0)
* {
* lblMessage.Text = "Can't Delete This Value becoz it Contains Record...";
* SqlDSdept.DeleteCommand = "Delete from dept_mst WHERE dept_no=0";
* SqlDSdept.Delete();
* gdvDept.DataBind();
* return;
* }*/
SqlDSdept.DeleteCommand = "Delete from emp_mst WHERE [emp_no] = " + strEmpID;
SqlDSdept.Delete();
lblMessage.Text = "RECORD DELETED SUCCESSFULLY...";
gdvDept.DataBind();
}
catch (Exception ex1)
{
lblMessage.Text = "Access Denied... :: " + ex1.Message;
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string strMaxNoQry = "select isnull(max(dept_no),0) from dept_mst";
object objMaxNo = objPayroll.GetScalar(strMaxNoQry);
string strExistQty = "select count(*) from dept_mst where dept_name = '" + txtdept_name.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;
}
//strMaxNoQry = "select iif(max(dept_no) != null,max(dept_no)+1,1) from dept_mst";
string strInsQry = "insert into dept_mst(dept_no,dept_name) values(" + (Convert.ToInt32(objMaxNo) + 1).ToString() + ", '" + txtdept_name.Text.Trim() + "')";
int strQryRes = objPayroll.insertdata(strInsQry);
if (strQryRes > 0)
{
lblMessage.Text = "Record Saved Successfully.";
txtdept_name.Text = "";
SqlDSdept.DataBind();
gdvDept.DataBind();
}
else
{
lblMessage.Text = "Record is not saved.";
}
}
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 btnSubmit_Click(object sender, EventArgs e)
{
string strMaxNoQry = "select isnull(max(bank_id),0) from bank_mst";
object objMaxNo = objPayroll.GetScalar(strMaxNoQry);
string strExistQty = "select count(*) from bank_mst where bank_name = '" + txtbank_name.Text.Trim() + "'";
object intExistCnt = objPayroll.GetScalar(strExistQty);
if (Convert.ToInt32(intExistCnt) > 0)
{
lblMessage.Text = "Record Already Exists...!!!";
return;
}
string strInsQry = "insert into bank_mst(bank_id,bank_name,branch_name) values(" + (Convert.ToInt32(objMaxNo) + 1).ToString() + ", '" + txtbank_name.Text.Trim() + "', '" + txtbranch_name.Text.Trim() + "')";
int strQryRes = objPayroll.insertdata(strInsQry);
if (strQryRes > 0)
{
lblMessage.Text = "Record Saved Successfully.";
txtbank_name.Text = "";
txtbranch_name.Text = "";
SqlDSdept.DataBind();
gdvDept.DataBind();
}
else
{
lblMessage.Text = "Record is not saved.";
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try { decimal tmpValue = Convert.ToDecimal(txtded_rate.Text.Trim()); }
catch
{
lblMessage.Text = "Enter Proper Rate.";
txtded_rate.Focus();
return;
}
string strMaxNoQry = "select isnull(max(ded_id),0) from ded_mst";
object objMaxNo = objPayroll.GetScalar(strMaxNoQry);
string strExistQty = "select count(*) from ded_mst where ded_name = '" + txtded_name.Text.Trim() + "'";
object intExistCnt = objPayroll.GetScalar(strExistQty);
if (Convert.ToInt32(intExistCnt) > 0)
{
lblMessage.Text = "Record Already Exists...!!!";
return;
}
string strInsQry = "insert into ded_mst(ded_id,ded_name,ded_rate) values(" + (Convert.ToInt32(objMaxNo) + 1).ToString() + ", '" + txtded_name.Text.Trim() + "', " + Convert.ToDecimal(txtded_rate.Text.Trim()) + ")";
int strQryRes = objPayroll.insertdata(strInsQry);
if (strQryRes > 0)
{
lblMessage.Text = "Record Saved Successfully.";
txtded_name.Text = "";
txtded_rate.Text = "";
SqlDSdept.DataBind();
gdvDept.DataBind();
}
else
{
lblMessage.Text = "Record is not saved.";
}
}
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;
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
String temp = null;
foreach (char enc in txtemp_password.Text)
{
temp = temp + Convert.ToChar(enc + 2);
}
try { int age = Convert.ToInt32(txtage.Text.Trim()); }
catch
{
lblMessage.Text = "Enter Proper Age.";
txtage.Focus();
return;
}
DateTime dtbdate;
try { dtbdate = Convert.ToDateTime(txtbdate.Text.Trim()); }
catch
{
lblMessage.Text = "Enter Proper Birth Date.";
txtbdate.Focus();
return;
}
DateTime dtDoj;
try{ dtDoj = Convert.ToDateTime(txtLdate.Text.Trim()); }
catch {
lblMessage.Text = "Enter Proper Date of Joining.";
txtLdate.Focus();
return;
}
string strMaxNoQry = "select isnull(max(emp_no),0) from emp_mst";
object objMaxNo = objPayroll.GetScalar(strMaxNoQry);
string strExistQty = "select count(*) from emp_mst where emp_username = '******'";
object intExistCnt = objPayroll.GetScalar(strExistQty);
if (Convert.ToInt32(intExistCnt) > 0)
{
lblMessage.Text = "Username already assigned to another Employee.";
return;
}
string strFields = "emp_no,emp_name,address1,address2,city,pincode,bdate,age,emp_doj,desgnation,department,type,emp_bankdetail,emp_username,emp_password,question,answer";
string strInsQry = "insert into emp_mst(" + strFields + ") values(" + (Convert.ToInt32(objMaxNo) + 1).ToString() + ", '" + txtemp_name.Text.Trim() + "', '" + txtaddress1.Text.Trim() + "', '" + txtaddress2.Text.Trim() + "', '" + txtcity.Text.Trim() + "', '" + txtpincode.Text.Trim() + "','" + dtbdate.Date + "'," + Convert.ToInt32(txtage.Text.Trim()).ToString() + ",'" + dtDoj.Date + "', " + ddlDesignation.SelectedValue.ToString() + ", " + ddlDepartment.SelectedValue.ToString() + ", '" + txttype.Text.Trim() + "', '" + txtBankDetail.Text.Trim() + "', '" + txtemp_username.Text.Trim() + "', '" + temp.ToString() + "','" + DropDownList1.Text + "','" + TextBox1.Text + "')";
int strQryRes = objPayroll.insertdata(strInsQry);
if (strQryRes > 0)
{
lblMessage.Text = "Record Saved Successfully.";
ClearControls();
SqlDSdept.DataBind();
gdvDept.DataBind();
}
else
{
lblMessage.Text = "Record is not saved.";
}
}
