// Bind GrdSearchFaculty GrdSearchFaculty_DL
#region [Faculty ICard]
public DataSet FacultyIcard_DL(EWA_StaffView objEWA)
{
//throw new NotImplementedException();
DataSet ds = new DataSet();
try
{
prmList = new string[6];
prmList[0] = "@Action";
prmList[1] = "GetEmployeeProfileData";
prmList[2] = "@OrgId";
prmList[3] = Convert.ToString(objEWA.OrgId);
prmList[4] = "@EmpCode";
prmList[5] = Convert.ToString(objEWA.EmpCode);
ds = ObjHelper.FillControl(prmList, "SP_Employee");
if (ds.Tables[0].Rows.Count > 0)
{
return(ds);
}
else
{
}
return(ds);
}
catch (Exception)
{
throw;
}
}
//Faculty Data
#region [Faculty Data]
public DataSet DL_FacultyData(EWA_StaffView objEWA)
{
DataSet ds = new DataSet();
try
{
prmList = new string[6];
prmList[0] = "@Action";
prmList[1] = "FacultyProfile";
prmList[2] = "@OrgId";
prmList[3] = Convert.ToString(objEWA.OrgId);
prmList[4] = "@EmpCode";
prmList[5] = objEWA.EmpCode;
//Stored procedure name
ds = ObjHelper.FillControl(prmList, "SP_Employee");
if (ds.Tables[0].Rows.Count > 0)
{
return(ds);
}
else
{
}
return(ds);
}
catch (Exception)
{
throw;
}
}
//Bind Faculty Data
#region [Bind Faculty Data]
public DataSet DL_BindFacultyData(EWA_StaffView objEWA)
{
DataSet ds = new DataSet();
try
{
prmList = new string[8];
prmList[0] = "@Action";
prmList[1] = "GetEmployeeProfile";
prmList[2] = "@OrgId";
prmList[3] = objEWA.OrgId.ToString();
prmList[4] = "@DepartmentId";
prmList[5] = objEWA.DepartmentId;
prmList[6] = "@DesignationId";
prmList[7] = objEWA.Designation;
//Stored procedure name
ds = ObjHelper.FillControl(prmList, "SP_Employee");
if (ds.Tables[0].Rows.Count > 0)
{
return(ds);
}
else
{
}
return(ds);
}
catch (Exception)
{
throw;
}
}
//Delete Faculty
#region [Delete Faculty]
public int DeleteFaculty_BL(EWA_StaffView objEWA)
{
try
{
DL_StaffView ObjDL = new DL_StaffView();
return(ObjDL.DeleteFaculty_DL(objEWA));
}
catch (Exception)
{
return(0);
}
}
//Faculty Data
#region StaffView
public DataSet BL_ViewFacultyData(EWA_StaffView objEWA)
{
try
{
DL_StaffView objDL = new DL_StaffView();
DataSet ds = objDL.DL_FacultyData(objEWA);
return(ds);
}
catch (Exception)
{
throw;
}
}
//#region StaffView
//public DataSet BL_StaffViewId(EWA_StaffView objEWA)
//{
// try
// {
// DL_StaffView objDL = new DL_StaffView();
// DataSet ds = objDL.DL_ShowStaffViewProfile(objEWA);
// return ds;
// }
// catch (Exception)
// {
// throw;
// }
// finally
// {
// }
//}
//#endregion
public DataSet FacultyIcard_BL(EWA_StaffView objEWA)
{
try
{
DL_StaffView objDL = new DL_StaffView();
DataSet ds = objDL.FacultyIcard_DL(objEWA);
return(ds);
}
catch (Exception)
{
throw;
}
}
//#region Editing record
//public DataSet FacultyViewf_BL(EWA_StaffView objEWA)
//{
// try
// {
// DL_StaffView objDL = new DL_StaffView();
// DataSet ds = objDL.DL_ShowStaffViewProfilef(objEWA);
// return ds;
// }
// catch (Exception)
// {
// throw;
// }
// finally
// {
// }
//}
//#endregion
//#region Editing record
//public DataSet BL_StaffViewIdf(EWA_StaffView objEWA)
//{
// try
// {
// DL_StaffView objDL = new DL_StaffView();
// DataSet ds = objDL.FacultyIcardf_DL(objEWA);
// return ds;
// }
// catch (Exception)
// {
// throw;
// }
// finally
// {
// }
//}
//#endregion
#endregion
//Update Faculty
#region Editing record
public int BL_UpdateFaculty(EWA_StaffView objEWA)
{
try
{
DL_StaffView objDL = new DL_StaffView();
int flag = 0;// = objDL.UpdateFaculty_DL(objEWA);
return(flag);
}
catch (Exception)
{
throw;
}
}
protected void lnkBtnDelete_Click(object sender, EventArgs e)
{
try
{
lock (this)
{
LinkButton lnkBtnId = (LinkButton)sender;
GridViewRow grdrow = lnkBtnId.NamingContainer as GridViewRow;
//ViewState["StudentUserCode"]
//Session["EmpUserCode1"] = grd.DataKeys[grdrow.RowIndex].Values["UserCode"].ToString();
EWA_StaffView objEWA = new EWA_StaffView();
BL_StaffView objBAL = new BL_StaffView();
string msgact = "";
objEWA.Action = "DeleteProfile";
objEWA.StaffID = Convert.ToInt32(grd.DataKeys[grdrow.RowIndex].Values["UserCode"].ToString());
objEWA.OrgId = Convert.ToInt32(Session["OrgId"]);
if (Convert.ToBoolean(grd.DataKeys[grdrow.RowIndex].Values["IsActive"].ToString()))
{
objEWA.IsActive = 0;
msgact = "Deactivate";
}
else
{
objEWA.IsActive = 1;
msgact = "activate";
}
int result = objBAL.DeleteFaculty_BL(objEWA);
if (result > 0)
{
msgBox.ShowMessage("Faculty is " + msgact + "..! ", "Successfull", UserControls.MessageBox.MessageStyle.Successfull);
select_qry();
}
}
}
catch (Exception exp)
{
GeneralErr(exp.Message.ToString());
// throw;
}
}
//Bind Faculty grid
#region [Bind Faculty Grid]
private void BindFacultyGrid()
{
try
{
EWA_StaffView objEWA = new EWA_StaffView();
BL_StaffView objBAL = new BL_StaffView();
objEWA.OrgId = Convert.ToInt32(Session["OrgId"]);
objEWA.DepartmentId = ddlDepartment.SelectedValue;
objEWA.Designation = ddlDesignation.SelectedValue;
DataSet ds = new DataSet();
ds = objBAL.FacultyView_BL(objEWA);
if (ds.Tables[0].Rows.Count == 0 || ds == null)
{
ds.Tables[0].Rows.Add(ds.Tables[0].NewRow());
grdSearchFaculty.DataSource = ds;
grdSearchFaculty.DataBind();
int columncount = grdSearchFaculty.Rows[0].Cells.Count;
grdSearchFaculty.Rows[0].Cells.Clear();
grdSearchFaculty.Rows[0].Cells.Add(new TableCell());
grdSearchFaculty.Rows[0].Cells[0].ColumnSpan = columncount;
grdSearchFaculty.Rows[0].Cells[0].Text = "No Records Found";
}
else
{
grdSearchFaculty.DataSource = ds.Tables[0];
grdSearchFaculty.DataBind();
}
}
catch (Exception exp)
{
GeneralErr(exp.Message.ToString());
}
}
protected void btnGo_Click(object sender, EventArgs e)
{
Panel3.Visible = true;
BL_StaffView objBAL = new BL_StaffView();
EWA_StaffView objEWA = new EWA_StaffView();
try
{
objEWA.Designation = ddlDesignation.SelectedValue;
objEWA.DepartmentId = ddlDepartment.SelectedValue;
objEWA.OrgId = Convert.ToInt32(Session["OrgId"]);
DataSet ds = new DataSet();
ds = objBAL.BL_GetFacultyIcardData(objEWA);
if (ds.Tables[0].Rows.Count > 0)
{
grdIcard.DataSource = ds.Tables[0];
grdIcard.DataBind();
btnPrintLoad.Visible = true;
}
else
{
DataTable dt = new DataTable();
//dt.Columns.Add("UserCode");
//dt.Columns.Add("FullName");
//dt.Rows.Add();
//dt.Rows.Add();
grdIcard.DataSource = dt;
grdIcard.DataBind();
btnPrintLoad.Visible = false;
}
}
catch (Exception exp)
{
GeneralErr(exp.Message.ToString());
}
}
//Commented
#region [Commented]
// Update Staff
//public int UpdateFaculty_DL(EWA_StaffView objEWA)
//{
// try
// {
// cmd = new SqlCommand("SP_Staff", con);
// cmd.CommandType = CommandType.StoredProcedure;
// //personal Information
// cmd.Parameters.AddWithValue("@Action", objEWA.Action);
// cmd.Parameters.AddWithValue("@FirstName", objEWA.FirstName);
// cmd.Parameters.AddWithValue("@MiddleName", objEWA.MiddleName);
// //cmd.Parameters.AddWithValue("@LastName", objEWA.LastName);
// //cmd.Parameters.AddWithValue("@MotherName", objEWA.MotherName);
// //cmd.Parameters.AddWithValue("@Gender", objEWA.Gender);
// //cmd.Parameters.AddWithValue("@DOB", objEWA.DOB);
// //cmd.Parameters.AddWithValue("@BloodGroup", objEWA.BloodGroup);
// //cmd.Parameters.AddWithValue("@MaritalStatus", objEWA.MaritalStatus);
// //Contact Information
// //cmd.Parameters.AddWithValue("@PresentAddress", objEWA.PresentAddress);
// //cmd.Parameters.AddWithValue("@PresentCountry", objEWA.PresentCountry);
// //cmd.Parameters.AddWithValue("@PresentState", objEWA.PresentState);
// //cmd.Parameters.AddWithValue("@PresentCity", objEWA.PresentCity);
// //cmd.Parameters.AddWithValue("@PresentPinCode", objEWA.PresentPinCode);
// //cmd.Parameters.AddWithValue("@PermanentAddress", objEWA.PermanentAddress);
// //cmd.Parameters.AddWithValue("@PermanentCountry", objEWA.PermanentCountry);
// //cmd.Parameters.AddWithValue("@PermanentState", objEWA.PermanentState);
// //cmd.Parameters.AddWithValue("@PermanentCity", objEWA.PermanentCity);
// //cmd.Parameters.AddWithValue("@PermanentPinCode", objEWA.PermanentPinCode);
// //cmd.Parameters.AddWithValue("@PhoneNo", objEWA.PhoneNo);
// //cmd.Parameters.AddWithValue("@Mobile", objEWA.Mobile);
// //cmd.Parameters.AddWithValue("@Fax", objEWA.Fax);
// //cmd.Parameters.AddWithValue("@Email", objEWA.Email);
// //cmd.Parameters.AddWithValue("@CasteCategory", objEWA.CasteCategory);
// //cmd.Parameters.AddWithValue("@Nationality", objEWA.Nationality);
// //cmd.Parameters.AddWithValue("@WebsiteBlog", objEWA.WebsiteBlog);
// //cmd.Parameters.AddWithValue("@PanCardNo", objEWA.PanCardNo);
// //cmd.Parameters.AddWithValue("@DateOfJoining", objEWA.DateOfJoining);
// //Education Qualification
// //cmd.Parameters.AddWithValue("@UGDegree", objEWA.UGDegree);
// //cmd.Parameters.AddWithValue("@PGDegree", objEWA.PGDegree);
// //cmd.Parameters.AddWithValue("@DoctrateDegree", objEWA.DoctrateDegree);
// //cmd.Parameters.AddWithValue("@OtherQualification", objEWA.OtherQualification);
// //cmd.Parameters.AddWithValue("@Specialization", objEWA.Specialization);
// //cmd.Parameters.AddWithValue("@TeachingExperience", objEWA.TeachingExperience);
// //cmd.Parameters.AddWithValue("@IndustrialExperience", objEWA.IndustrialExperience);
// //cmd.Parameters.AddWithValue("@ResearchExperience", objEWA.ResearchExperience);
// //cmd.Parameters.AddWithValue("@NationalPublication", objEWA.NationalPublication);
// //cmd.Parameters.AddWithValue("@InternationalPublication", objEWA.InternationalPublication);
// //cmd.Parameters.AddWithValue("@BookPublished", objEWA.BookPublished);
// //cmd.Parameters.AddWithValue("@Patents", objEWA.Patents);
// //Other Information
// //cmd.Parameters.AddWithValue("@PFNumber", objEWA.PFNumber);
// //cmd.Parameters.AddWithValue("@BankAccountNumber", objEWA.BankAccountNumber);
// //cmd.Parameters.AddWithValue("@BankName", objEWA.BankName);
// //cmd.Parameters.AddWithValue("@BankBranchName", objEWA.BankBranchName);
// //cmd.Parameters.AddWithValue("@BankIFSCCode", objEWA.BankIFSCCode);
// //cmd.Parameters.AddWithValue("@OrgId", objEWA.OrgId);
// //// cmd.Parameters.AddWithValue("@OrgId", objEWA.OrgId);
// //cmd.Parameters.AddWithValue("@StaffID", objEWA.StaffID);
// ////cmd.Parameters.AddWithValue("@UserId", objEWA.UserId);
// //cmd.Parameters.AddWithValue("@TransDate", objEWA.TransDate);
// //cmd.Parameters.AddWithValue("@IsActive", objEWA.IsActive);
// con.Open();
// int flag = cmd.ExecuteNonQuery();
// con.Close();
// return flag;
// }
// catch (Exception)
// {
// // throw;
// }
// //return ds;
//}
#endregion
//Delete Faculty
#region [Delete Faculty]
public int DeleteFaculty_DL(EWA_StaffView objEWA)
{
int flag = 0;
try
{
SqlCommand cmd = new SqlCommand();
cmd = new SqlCommand("SP_Employee", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Action", objEWA.Action);
cmd.Parameters.AddWithValue("@UserCode", objEWA.StaffID);
cmd.Parameters.AddWithValue("@OrgId", objEWA.OrgId);
cmd.Parameters.AddWithValue("@IsActive", objEWA.IsActive);
con.Open();
flag = cmd.ExecuteNonQuery();
con.Close();
return(flag);
}
catch (Exception)
{
return(flag);
}
}
