protected void Btn1_Click(object sender, EventArgs e) { GridViewRow gvRow = (GridViewRow)(sender as Control).Parent.Parent; int rowIndex = gvRow.RowIndex; String sap_id = GridView_leaves.Rows[rowIndex].Cells[1].Text; byte x = Data_Access.Approve_Reject(sap_id, "warden", 1, "branch not req(hostel Leave)"); if (x == 1) { Response.Write("Approved"); } SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ConnectionString); SqlDataAdapter da = new SqlDataAdapter(); if (Session["post"].ToString() == "warden") { da.SelectCommand = new SqlCommand("select student.sap_id,student.name,student.year,student.course,student.mobile_self,hostel_leave.date_from,hostel_leave.reason,hostel_leave.time_departure from student inner join hostel_leave on hostel_leave.sap_id=student.sap_id where hostel_leave.leave_status=0 and hostel_leave.departed='False'", con); } DataTable dt = new DataTable(); da.Fill(dt); if (dt.Columns.Count != 0) { GridView_leaves.DataSource = dt; GridView_leaves.DataBind(); } else { Label_leave_available.Visible = true; Label_leave_available.Text = "No Leaves Found"; } }
protected void Btn_disapprove_Click(object sender, EventArgs e) { GridViewRow gvRow = (GridViewRow)(sender as Control).Parent.Parent; int rowIndex = gvRow.RowIndex; String sap_id = GridView_leaves.Rows[rowIndex].Cells[1].Text; byte x = Data_Access.Approve_Reject(sap_id, "warden", 0, "branch not req(hostel Leave)"); if (x == 1) { Response.Write("Rejected"); } }
protected void Btn1_Click(object sender, EventArgs e) { GridViewRow gvRow = (GridViewRow)(sender as Control).Parent.Parent; int index = gvRow.RowIndex; //Fetches the employee id corresponding to the row index string sap_id = GridView_leaves.Rows[index].Cells[2].Text; string student_branch = GridView_leaves.Rows[index].Cells[4].Text; byte x = Data_Access.Approve_Reject(sap_id, Session["post"].ToString(), 1, student_branch); if (x == 1) { Response.Write("Approved"); } SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ConnectionString); SqlDataAdapter da = new SqlDataAdapter(); if (Session["post"].ToString() == "mentor") { da.SelectCommand = new SqlCommand("select student.sap_id,student.name,student.branch,student.year,student.course,student.mobile_self,leave.date_from,leave.date_to,leave.reason from student inner join leave on leave.sap_id=student.sap_id where leave.leave_status=0 and leave.departed='False' and leave.emp_id='" + Session["emp_id"].ToString() + "'", con); } else if (Session["post"].ToString() == "hod") { da.SelectCommand = new SqlCommand("select student.sap_id,student.name,student.branch,student.year,student.course,student.mobile_self,leave.date_from,leave.date_to,leave.reason from student inner join leave on leave.sap_id=student.sap_id where leave.leave_status=1 and leave.departed='False' and student.branch='" + Session["branch"].ToString() + "'", con); } else if (Session["post"].ToString() == "dean") { da.SelectCommand = new SqlCommand("select student.sap_id,student.name,student.branch,student.year,student.course,student.mobile_self,leave.date_from,leave.date_to,leave.reason from student inner join leave on leave.sap_id=student.sap_id where leave.leave_status=2 and leave.departed='False'", con); } DataTable dt = new DataTable(); da.Fill(dt); if (dt.Columns.Count != 0) { GridView_leaves.DataSource = dt; GridView_leaves.DataBind(); } else { Label_leave_available.Visible = true; Label_leave_available.Text = "No Leaves Found"; } }