//Linkbtn Event
#region [LnkBtb Event]
protected void lnkbtn_Click(object sender, EventArgs e)
{
try
{
string[] confirmValue = Request.Form["confirm_value"].Split(',');
if (confirmValue[confirmValue.Length - 1] == "Yes")
{
int flag;
EWA_EmpAssignSubject ObjEWA = new EWA_EmpAssignSubject();
BL_EmpAssignSubject ObjBL = new BL_EmpAssignSubject();
GridViewRow grdrow = (GridViewRow)((LinkButton)sender).NamingContainer;
ObjEWA.Action = "Delete";
ObjEWA.UserCode = grdrow.Cells[0].Text;
ObjEWA.CourseId = ddlCourse.SelectedValue.ToString();
ObjEWA.ClassId = ddlClass.SelectedValue.ToString();
ObjEWA.SubjectId = ddlSubject.SelectedValue.ToString();
ObjEWA.OrgId = Session["OrgId"].ToString();
flag = ObjBL.EmpCourseClassAction_BL(ObjEWA);
if (flag > 0)
{
msgBox.ShowMessage("deleted !!!", "Deleted", UserControls.MessageBox.MessageStyle.Successfull);
}
GrdViewEmployeeBind();
GrdEmployeeBind();
}
}
catch (Exception exp)
{
GeneralErr(exp.Message.ToString());
}
}
//Emp Data Bind
#region [Emp Data Bind]
protected void GrdEmployee_RowDataBound(object sender, GridViewRowEventArgs e)
{
try
{
if (e.Row.RowIndex > -1)
{
GridViewRow GrdRow = e.Row;
EWA_EmpAssignSubject ObjEWA = new EWA_EmpAssignSubject();
BL_EmpAssignSubject ObjBL = new BL_EmpAssignSubject();
ObjEWA.Action = "FetchSubject";
ObjEWA.UserCode = GrdRow.Cells[0].Text;
ObjEWA.OrgId = Session["OrgId"].ToString();
DataSet ds = ObjBL.FetchSubject_BL(ObjEWA);
string joinstr = "No record found";
if (ds.Tables[0].Rows.Count != 0)
{
joinstr = ds.Tables[0].Rows[0][0].ToString();
for (int i = 1; i < ds.Tables[0].Rows.Count; i++)
{
joinstr += "," + ds.Tables[0].Rows[i][0].ToString();
}
}
GrdRow.Cells[2].Text = joinstr;
}
}
catch (Exception exp)
{
GeneralErr(exp.Message.ToString());
}
}
//Emp Grid Bind
#region [Emp Grid Bind]
private void GrdViewEmployeeBind()
{
try
{
EWA_EmpAssignSubject objEWA = new EWA_EmpAssignSubject();
BL_EmpAssignSubject objBL = new BL_EmpAssignSubject();
objEWA.Action = "FetchAssignedEmployee";
objEWA.OrgId = Session["OrgId"].ToString();
objEWA.DesignationTypeId = "1";
objEWA.ClassId = ddlClass.SelectedValue.ToString();
objEWA.CourseId = ddlCourse.SelectedValue.ToString();
objEWA.BranchId = ddlBranch.SelectedValue.ToString();
objEWA.SubjectId = ddlSubject.SelectedValue.ToString();
DataSet ds = objBL.EmployeeGridBind_BL(objEWA);
if (ds.Tables[0].Rows.Count != 0)
{
GrdViewEmployee.DataSource = ds;
GrdViewEmployee.DataBind();
GrdViewEmployee.Columns[3].Visible = true;
}
else
{
ShowEmptyGridView(GrdViewEmployee);
}
}
catch (Exception exp)
{
GeneralErr(exp.Message.ToString());
}
}
//Insert Update Delete operaeion on EmployeeDeptDes Table
#region [ActionPerformed For EmployeeDeptDes]
public int EmpCourseClassAction_BL(EWA_EmpAssignSubject objEWA)
{
try
{
int flag = objDL.EmpCourseClassAction_DL(objEWA);
return(flag);
}
catch (Exception)
{
throw;
}
}
//To Bind EmployeeGrid
#region [BindEmployeeGrid]
public DataSet BindEmployeeGrid_DL(EWA_EmpAssignSubject objEWA)
{
DataSet ds = new DataSet();
try
{
prmList = new string[14];
prmList[0] = "@Action";
prmList[1] = objEWA.Action;
prmList[2] = "@OrgId";
prmList[3] = objEWA.OrgId.ToString();
prmList[4] = "@DesignationTypeId";
prmList[5] = objEWA.DesignationTypeId.ToString();
prmList[6] = "@CourseId";
prmList[7] = objEWA.CourseId;
prmList[8] = "@ClassId";
prmList[9] = objEWA.ClassId;
prmList[10] = "@SubjectId";
prmList[11] = objEWA.SubjectId;
prmList[12] = "@BranchId";
prmList[13] = objEWA.BranchId;
ds = ObjHelper.FillControl(prmList, "SP_EmpAssignSubject");
//if (ds.Tables[0].Rows.Count > 0)
//{
// return ds;
//}
//else
//{
// DataTable dt = new DataTable();
// dt.Columns.Add("UserCode");
// dt.Columns.Add("SubjectCode");
// dt.Columns.Add("SubjectName");
// dt.Rows.Add();
// dt.Rows.Add();
// dt.Rows.Add();
// //return dsCode;
//}
return(ds);
}
catch (Exception)
{
// GeneralErr(exp.Message.ToString());
throw;
}
}
//Fetch Subject
#region [Fetch Subject]
public DataSet FetchSubject_BL(EWA_EmpAssignSubject ObjEWA)
{
try
{
DL_EmpAssignSubject objDL = new DL_EmpAssignSubject();
DataSet ds = objDL.FetchSubject_DL(ObjEWA);
return(ds);
}
catch (Exception)
{
throw;
}
finally
{
objDL = null;
}
}
//To Call EmployeeGridBind
#region [EmployeeGridBind]
public System.Data.DataSet EmployeeGridBind_BL(EWA_EmpAssignSubject objEWA)
{
try
{
DL_EmpAssignSubject objDL = new DL_EmpAssignSubject();
DataSet ds = objDL.BindEmployeeGrid_DL(objEWA);
return(ds);
}
catch (Exception)
{
throw;
}
finally
{
objDL = null;
}
}
//Fetch Subject
#region [Fetch Subject]
public DataSet FetchSubject_DL(EWA_EmpAssignSubject ObjEWA)
{
DataSet ds = new DataSet();
try
{
prmList = new string[6];
prmList[0] = "@Action";
prmList[1] = ObjEWA.Action;
prmList[2] = "@UserCode";
prmList[3] = ObjEWA.UserCode;
prmList[4] = "@OrgId";
prmList[5] = ObjEWA.OrgId;
ds = ObjHelper.FillControl(prmList, "SP_EmpAssignSubject");
return(ds);
}
catch (Exception e)
{
throw e;
}
}
//To Perform Insert,Update,Delete and Search Actions On EmpDeptDes Table
#region [Perform Actions On Emp Dept Des]
public int EmpCourseClassAction_DL(EWA_EmpAssignSubject objEWA)
{
try
{
cmd = new SqlCommand("SP_EmpAssignSubject", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Action", objEWA.Action);
cmd.Parameters.AddWithValue("@UserCode", objEWA.UserCode);
cmd.Parameters.AddWithValue("@CourseId", objEWA.CourseId);
cmd.Parameters.AddWithValue("@ClassId", objEWA.ClassId);
cmd.Parameters.AddWithValue("@SubjectId", objEWA.SubjectId);
cmd.Parameters.AddWithValue("@OrgId", objEWA.OrgId);
cmd.Parameters.AddWithValue("@UserId", objEWA.UserId);
cmd.Parameters.AddWithValue("@BranchId", objEWA.BranchId);
cmd.Parameters.AddWithValue("@IsActive", objEWA.IsActive);
con.Open();
int flag = cmd.ExecuteNonQuery();
con.Close();
return(flag);
}
catch (Exception ex)
{
int err = ((System.Data.SqlClient.SqlException)(ex)).Number;
if (err == 547 && objEWA.Action == "Delete")
{
throw new SystemException("Record is in use !!!");
}
else
{
throw ex;
}
}
//finally
//{
// con.Close();
// cmd.Dispose();
//}
}
