protected void btncancel_Click(object sender, EventArgs e)
{
LDT = LAdapter.Select_By_Status_Ename("Cancel", Session["ename"].ToString());
GridView1.DataSource = LDT;
GridView1.DataBind();
lbl.Text = GridView1.Rows.Count.ToString() + " Record Found";
}
protected void btnselect_Click(object sender, EventArgs e)
{
LDT = LAdapter.Select_By_Status_Ename("New", drpemployee.SelectedItem.Text);
GridView1.DataSource = LDT;
GridView1.DataBind();
}
protected void Button10_Click(object sender, EventArgs e)
{
LDT = LAdapter.Seelct_By_Status("Cancel");
drpemployee1.DataSource = LDT;
drpemployee1.DataTextField = "Ename";
drpemployee1.DataValueField = "Ename";
drpemployee1.DataBind();
MultiView1.ActiveViewIndex = 2;
lbltitle.Text = "Cancel";
GridView3.DataSource = null;
GridView3.DataBind();
lblmsg1.Text = drpemployee1.Items.Count.ToString() + " Result Found";
}
protected void GridView3_RowCommand(object sender, GridViewCommandEventArgs e)
{
LAdapter.Delete(Convert.ToInt32(e.CommandArgument.ToString()));
lblmsg1.Text = "Leave deleted";
LDT = LAdapter.Select_By_Status_Ename("Cancel", drpemployee1.SelectedItem.Text);
GridView3.DataSource = LDT;
GridView3.DataBind();
LDT = LAdapter.Seelct_By_Status("Cancel");
drpemployee1.DataSource = LDT;
drpemployee1.DataTextField = "Ename";
drpemployee1.DataValueField = "Ename";
drpemployee1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
EDT = EAdapter.select();
lblemp.Text = EDT.Rows.Count.ToString();
EDT = EAdapter.Select_By_Status("Active");
lblaemp.Text = EDT.Rows.Count.ToString();
EDT = EAdapter.Select_By_Status("InActive");
lbldemp.Text = EDT.Rows.Count.ToString();
LDT = LAdapter.Seelct_By_Status("New");
lblnleave.Text = LDT.Rows.Count.ToString();
LDT = LAdapter.Seelct_By_Status("Approve");
lblaleave.Text = LDT.Rows.Count.ToString();
LDT = LAdapter.Seelct_By_Status("Cancel");
lblrleave.Text = LDT.Rows.Count.ToString();
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "app")
{
LAdapter.LEAVEMST_UPADTE_STATUS("Approve", Convert.ToInt32(e.CommandArgument.ToString()));
LDT = LAdapter.Select_By_Status_Ename("New", drpemployee.SelectedItem.Text);
GridView1.DataSource = LDT;
GridView1.DataBind();
LDT = LAdapter.Seelct_By_Status("New");
drpemployee.DataSource = LDT;
drpemployee.DataTextField = "Ename";
drpemployee.DataValueField = "Ename";
drpemployee.DataBind();
lblmsg.Text = "Leave Approved";
}
else if (e.CommandName == "rej")
{
LAdapter.LEAVEMST_UPADTE_STATUS("Cancel", Convert.ToInt32(e.CommandArgument.ToString()));
LDT = LAdapter.Select_By_Status_Ename("New", drpemployee.SelectedItem.Text);
GridView1.DataSource = LDT;
GridView1.DataBind();
LDT = LAdapter.Seelct_By_Status("New");
drpemployee.DataSource = LDT;
drpemployee.DataTextField = "Ename";
drpemployee.DataValueField = "Ename";
drpemployee.DataBind();
lblmsg.Text = "Leave Canceled";
}
MultiView1.ActiveViewIndex = 0;
}