protected void btnSubmit_Click(object sender, EventArgs e)
{
//string str1 = "SELECT * from JobFunctionCategory where CategoryName='" + txtCategoryName.Text + "' and Whid='" + ddlbusiness.SelectedValue + "'";
//SqlCommand cmd1 = new SqlCommand(str1, con);
//SqlDataAdapter da1 = new SqlDataAdapter(cmd1);
//DataTable dt1 = new DataTable();
//da1.Fill(dt1);
if (btnSubmit.Text == "Submit")
{
CLS_JobFunctionCategory jfc = new CLS_JobFunctionCategory();
jfc.Whid = ddlbusiness.SelectedValue;
jfc.CategoryName = txtCategoryName.Text;
DataTable dt1 = jfc.cls_jobfunctioncategory2();
if (dt1.Rows.Count > 0)
{
lblmsg.Visible = true;
lblmsg.Text = "Category already exist";
}
else
{
jfc.Name = txtCategoryName.Text;
jfc.Whid = ddlbusiness.SelectedValue;
jfc.Status = Convert.ToInt32(ddlStatus.SelectedValue);
int i = jfc.cls_jobfunctioncategory1();
if (i > 0)
{
lblmsg.Visible = true;
lblmsg.Text = "Record inserted successfully";
fillgrid();
}
}
}
if (btnSubmit.Text == "Update")
{
SqlCommand cmd = new SqlCommand("update JobFunctionCategory set CategoryName='" + txtCategoryName.Text + "',Whid='" + ddlbusiness.SelectedValue + "',Status='" + ddlStatus.SelectedValue + "' where id='" + ViewState["EID"] + "'", con);
if (con.State.ToString() != "Open")
{
con.Open();
}
cmd.ExecuteNonQuery();
con.Close();
lblmsg.Visible = true;
lblmsg.Text = "Record updated successfully";
fillgrid();
btnSubmit.Text = "Submit";
}
txtCategoryName.Text = "";
ddlStatus.SelectedIndex = 0;
pnladdd.Visible = false;
btnnewcat.Visible = true;
lbllegend.Text = "";
}
protected void fillDDl(DropDownList ddl, string Textfild, string valfild)
{
CLS_JobFunctionCategory jfc = new CLS_JobFunctionCategory();
jfc.comid = Session["comid"].ToString();
DataTable dt11 = jfc.cls_fillddl();
ddl.DataSource = dt11;
ddl.DataTextField = Textfild;
ddl.DataValueField = valfild;
ddl.DataBind();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
try
{
int dk = Convert.ToInt32(GridView1.DataKeys[GridView1.EditIndex].Value);
TextBox cat = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtCategory1");
DropDownList wh = (DropDownList)GridView1.Rows[GridView1.EditIndex].FindControl("ddlBusiness1");
CheckBox cb = (CheckBox)GridView1.Rows[e.RowIndex].FindControl("cbxStatus1");
//string str1 = "SELECT * from JobFunctionCategory where CategoryName ='" + cat.Text + "' and Whid='" + wh.SelectedValue + "' and Id<>'" + dk + "'";
//SqlCommand cmd1 = new SqlCommand(str1, con);
//SqlDataAdapter da1 = new SqlDataAdapter(cmd1);
//DataTable dt1 = new DataTable();
//da1.Fill(dt1);
CLS_JobFunctionCategory jfc = new CLS_JobFunctionCategory();
jfc.Whid = wh.SelectedValue;
jfc.CategoryName = cat.Text;
jfc.Id = dk.ToString();
DataTable dt1 = jfc.cls_jobfunctioncategory5();
if (dt1.Rows.Count > 0)
{
lblmsg.Visible = true;
lblmsg.Text = "Category already exist";
}
else
{
int i;
if (cb.Checked == true)
{
i = 1;
}
else
{
i = 0;
}
string sr51 = ("update JobFunctionCategory set CategoryName ='" + cat.Text + "',Whid='" + wh.SelectedValue + "',Status = " + i + " where Id='" + dk + "' ");
SqlCommand cmd801 = new SqlCommand(sr51, con);
if (con.State.ToString() != "Open")
{
con.Open();
}
cmd801.ExecuteNonQuery();
con.Close();
//jfc.Whid = wh.SelectedValue;
//jfc.CategoryName = cat.Text;
//jfc.Id = dk.ToString();
//jfc.cls_update_jobfunction();
GridView1.EditIndex = -1;
fillgrid();
lblmsg.Visible = true;
lblmsg.Text = "Record updated successfully";
//ddl();
}
}
catch (Exception ert)
{
lblmsg.Visible = true;
lblmsg.Text = "Error :" + ert.Message;
}
}
