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