protected void btnsubmitpop1_Click(object sender, EventArgs e)
{
if (chkdepartment.Checked)
{
foreach (GridViewRow gdr in grddepartment.Rows)
{
Label lbldepartmasterid = (Label)gdr.FindControl("lbldepartmasterid");
CheckBox chkactive123 = (CheckBox)gdr.FindControl("chkactive123");
if (chkactive123.Checked)
{
String strdept = "Insert Into Procedurebydefaulttbl (ProcedureMasterId,version,DepartmentId,status)values('" + ddlproceduretitle.SelectedValue + "','" + lblversion.Text + "','" + lbldepartmasterid.Text + "','" + chkactive123.Checked + "')";
SqlCommand cmddept = new SqlCommand(strdept, con);
if (con.State.ToString() != "Open")
{
con.Open();
}
cmddept.ExecuteNonQuery();
con.Close();
}
ModalPopupExtenderAddnew.Hide();
chkdepartment.Checked = false;
}
}
}
protected void chkdepartment_CheckedChanged(object sender, EventArgs e)
{
if (chkdepartment.Checked)
{
ModalPopupExtenderAddnew.Show();
}
else
{
ModalPopupExtenderAddnew.Hide();
}
}
protected void grid_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Send")
{
ViewState["TaskId"] = Convert.ToInt32(e.CommandArgument);
DataTable dtcrNew11 = MainAcocount.SelectOfficedocforGeneral(Convert.ToString(ViewState["TaskId"]), 9);
GridView1.DataSource = dtcrNew11;
GridView1.DataBind();
ModalPopupExtenderAddnew.Show();
}
if (e.CommandName == "Add")
{
string te = "AddDocMaster.aspx?takid=" + ViewState["idd1"].ToString() + "&storeid=" + ViewState["idd"].ToString() + "";
// objm=" + ViewState["idd1"].ToString() + "&storeid=" + + "";
ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", "window.open('" + te + "');", true);
}
}
protected void btnupdatepop1_Click(object sender, EventArgs e)
{
foreach (GridViewRow gdr in grddepartment.Rows)
{
Label lbldepartmasterid = (Label)gdr.FindControl("lbldepartmasterid");
CheckBox chkactive123 = (CheckBox)gdr.FindControl("chkactive123");
string strdept = "Select * from Policybydefaulttbl where DepartmentId='" + lbldepartmasterid.Text + "' and PolicyMasterId='" + ViewState["policymasterid"] + "' and version='" + ViewState["getversion"] + "'";
SqlCommand cmddept = new SqlCommand(strdept, con);
SqlDataAdapter addept = new SqlDataAdapter(cmddept);
DataSet ds = new DataSet();
addept.Fill(ds);
if (ds.Tables[0].Rows.Count > 0)
{
String strupdate = "Update Policybydefaulttbl set DepartmentId='" + lbldepartmasterid.Text + "',status='" + chkactive123.Checked + "' where PolicyMasterId='" + ViewState["policymasterid"] + "' and version = '" + ViewState["getversion"] + "'";
SqlCommand cmdupdate = new SqlCommand(strupdate, con);
if (con.State.ToString() != "Open")
{
con.Open();
}
cmdupdate.ExecuteNonQuery();
con.Close();
}
else
{
String strupdate = "insert into Policybydefaulttbl (PolicyMasterId,version,DepartmentId,status) values ('" + ViewState["policymasterid"] + "','" + ViewState["getversion"] + "','" + lbldepartmasterid.Text + "','" + chkactive123.Checked + "')";
SqlCommand cmdupdate = new SqlCommand(strupdate, con);
if (con.State.ToString() != "Open")
{
con.Open();
}
cmdupdate.ExecuteNonQuery();
con.Close();
}
}
ModalPopupExtenderAddnew.Hide();
chkdepartment.Checked = false;
btnsubmitpop1.Visible = true;
btnupdatepop1.Visible = false;
fillgrid();
}
protected void Button11_Click(object sender, EventArgs e)
{
for (int i = 0; i < GridView1.Rows.Count; i++)
{
CheckBox cb = (CheckBox)GridView1.Rows[i].FindControl("CheckBox1");
if (cb.Checked == true)
{
Label lbl = (Label)GridView1.Rows[i].FindControl("Label123");
if (dt5.Rows.Count < 1)
{
dt5.Columns.Add("ID");
}
DataRow dr = dt5.NewRow();
dr["ID"] = lbl.Text;
dt5.Rows.Add(dr);
ViewState["VacancyID"] = dt5;
ModalPopupExtenderAddnew.Show();
}
}
}
protected void Button4_Click(object sender, EventArgs e)
{
string str = " select Login_master.username,Login_master.password FROM Login_master inner join User_master on User_master.UserID = Login_master.UserID inner join Party_master on Party_master.PartyID = User_master.PartyID inner join EmployeeMaster on EmployeeMaster.PartyID=Party_master.PartyID where EmployeeMaster.EmployeeMasterID='" + ViewState["ID"] + "'";
SqlDataAdapter da = new SqlDataAdapter(str, con);
DataTable dt = new DataTable();
da.Fill(dt);
string oldpass = PageMgmt.Encrypted(dt.Rows[0]["password"].ToString());
string username = dt.Rows[0]["username"].ToString();
string Password = TextBox2.Text;
if (oldpass == Password && username == TextBox1.Text)
{
TextBox2.Text = "";
TextBox1.Text = "";
SqlCommand cmd = new SqlCommand("update GatepassDetails set TimeLeft='" + System.DateTime.Now.ToShortTimeString().Substring(0, 5) + "' where GatePassID='" + ViewState["gateid"] + "'", con);
if (con.State.ToString() != "Open")
{
con.Open();
}
cmd.ExecuteNonQuery();
con.Close();
fillgriddata();
string te = "frmgatepassreturn.aspx?gatepass="******"gateid"];
ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", "window.open('" + te + "');", true);
}
else
{
Label5.Text = "User Name or Password Possibally Incorrect.";
ModalPopupExtenderAddnew.Show();
}
}
protected void ImageButton3_Click(object sender, ImageClickEventArgs e)
{
ModalPopupExtenderAddnew.Hide();
}
protected void ImageButton3_Click(object sender, ImageClickEventArgs e)
{
ModalPopupExtenderAddnew.Hide();
chkdepartment.Checked = false;
}
protected void grid_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Edit")
{
lbllegend.Text = "Edit Policy";
btnadd.Visible = false;
statuslable.Text = "";
Pnladdnew.Visible = true;
int mm = Convert.ToInt32(e.CommandArgument);
ViewState["id"] = mm;
//ViewState["id"] = grid.DataKeys[e.NewEditIndex].Value.ToString();
string str = "select * from ProcedureAddManagetbl where Id='" + ViewState["id"] + "'";
SqlCommand cmd = new SqlCommand(str, con);
SqlDataAdapter adpt = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
adpt.Fill(dt);
btnupdate.Visible = true;
btncancel.Visible = true;
btnsubmit.Visible = false;
btnreset.Visible = false;
fillstore();
ddlstore.SelectedIndex = ddlstore.Items.IndexOf(ddlstore.Items.FindByValue(dt.Rows[0]["whid"].ToString()));
fillproceduretitle();
ddlproceduretitle.SelectedIndex = ddlproceduretitle.Items.IndexOf(ddlproceduretitle.Items.FindByValue(dt.Rows[0]["ProcedureId"].ToString()));
ViewState["proceduremasterid"] = dt.Rows[0]["ProcedureId"].ToString();
lblversion.Text = dt.Rows[0]["Version"].ToString();
ViewState["getversion"] = dt.Rows[0]["Version"].ToString();
txtprocedurename.Text = dt.Rows[0]["ProcedureName"].ToString();
if (Convert.ToString(dt.Rows[0]["ProcedureDescription"]) != "")
{
Button2.Checked = true;
Pnl1.Visible = true;
txtdescription.Text = Convert.ToString(dt.Rows[0]["ProcedureDescription"].ToString());;
}
else
{
Button2.Checked = false;
Pnl1.Visible = false;
txtdescription.Text = "";
}
txtpenaltypoint.Text = dt.Rows[0]["Penaltypoint"].ToString();
if (dt.Rows[0]["DesignationId"].ToString() != "0")
{
pnldesignation.Visible = true;
fillDesignation();
ddldesignation.SelectedIndex = ddldesignation.Items.IndexOf(ddldesignation.Items.FindByValue(dt.Rows[0]["DesignationId"].ToString()));
}
else
{
pnldesignation.Visible = false;
}
if (dt.Rows[0]["EmployeeId"].ToString() != "0")
{
pnlemployee.Visible = true;
fillemployee();
ddlemployee.SelectedIndex = ddlemployee.Items.IndexOf(ddlemployee.Items.FindByValue(dt.Rows[0]["EmployeeId"].ToString()));
}
else
{
pnlemployee.Visible = false;
}
txtestartdate.Text = dt.Rows[0]["Startdate"].ToString();
txteenddate.Text = dt.Rows[0]["Enddate"].ToString();
if (dt.Rows[0]["Status"].ToString() == "True")
{
chkstatus.Checked = true;
}
else
{
chkstatus.Checked = false;
}
ModalPopupExtenderAddnew.Show();
btnsubmitpop1.Visible = false;
btnupdatepop1.Visible = true;
}
}
