protected void Page_Load(object sender, EventArgs e)
{
//this.SrchGrid.Height = Unit.Pixel(0);
Response.ExpiresAbsolute = DateTime.Now.AddDays(-1d);
Response.Expires = -1500;
Response.CacheControl = "no-cache";
//block if without login
if (Session["Login_User_Detail"] == null)
{
Response.Redirect("~/MODULES/Login.aspx", true);
}
//block if from URL
ATTUserLogin user = ((ATTUserLogin)Session["Login_User_Detail"]);
//if (user.MenuList.ContainsKey("3,59,1") == true)
//{
if (!IsPostBack)
{
LoadAllOrganizationNameList();
Session["EmployeeDuptation"] = new ATTEmployeeDeputaion();
LoadEmpCurentPostingInfo(user.PID);
LoadEmpDeputationInfo();
}
//}
//else
// Response.Redirect("~/MODULES/Login.aspx", true);
}
protected void btnAdd_Click(object sender, EventArgs e)
{
ATTUserLogin user = ((ATTUserLogin)Session["Login_User_Detail"]);
ATTEmployeeDeputaion obj = (ATTEmployeeDeputaion)Session["EmployeeDuptation"];
ATTEmployeePosting objEcp = (ATTEmployeePosting)Session["EmployeeCurentPosting"];
obj.EmpID = user.PID;
obj.OrgID = user.OrgID;
obj.DesID = objEcp.DesID;
obj.CreatedDate = objEcp.CreatedDate;
obj.PostID = objEcp.PostID;
obj.FromDate = objEcp.FromDate;
obj.ApplicationDate = txtAppdate_DT.Text;
obj.DepOrgID = int.Parse(ddlOrganization.SelectedValue);
//obj.DecisionVerifiedBy = "";
//obj.LeaveDate = "";
//obj.LeaveVerifiedBy = "";
//obj.ReturnDate = "";
//obj.ReturnVerifiedBy = "";
obj.Responsibilities = txtdescription.Text;
obj.Active = "Y";
obj.EntryBy = user.UserName;
//obj.TipOrgID = "";
// obj.TippaniID = "";
//obj.DecisionDate = "";
obj.Action = "A";
if (this.ddlOrganization.SelectedIndex <= 0)
{
this.lblStatusMessage.Text = "Please select organization Name.";
this.programmaticModalPopup.Show();
this.lblStatus.Focus();
return;
}
if (this.txtAppdate_DT.Text == "")
{
this.lblStatusMessage.Text = "Please Enter Application Date.";
this.programmaticModalPopup.Show();
this.lblStatus.Focus();
return;
}
if (this.txtdescription.Text == "")
{
this.lblStatusMessage.Text = "Please Enter Responsibilities.";
this.programmaticModalPopup.Show();
this.lblStatus.Focus();
return;
}
if (BLLEmployeeDeputation.AddEmpForDeputationDetail(obj))
{
this.lblStatusMessage.Text = "Information Saved";
this.programmaticModalPopup.Show();
}
else
{
this.lblStatusMessage.Text = "Information could not be Saved";
this.programmaticModalPopup.Show();
}
ClearControl();
}
public static List <ATTEmployeeDeputaion> SearchEmployeeDeputation(ATTEmployeeDeputaion objEmployee, string searchType)
//flag defines whether or not to load employee other attributes.0-no,1-yes
{
List <ATTEmployeeDeputaion> lstEmployee = new List <ATTEmployeeDeputaion>();
foreach (DataRow row in DLLEmployeeDeputation.SearchEmployeeDeputation(objEmployee, searchType).Rows)
{
ATTEmployeeDeputaion obj = new ATTEmployeeDeputaion();
obj.EmpName = row["EMP_NAME"].ToString();
obj.EmpID = int.Parse(row["EMP_ID"].ToString());
obj.SymbolNo = ((row["SYMBOL_NO"] == System.DBNull.Value) ? "" : (string)row["SYMBOL_NO"]);
obj.Gender = ((row["GENDER"] == System.DBNull.Value) ? "" : (string)row["GENDER"]);
obj.DOB = ((row["DOB"] == System.DBNull.Value) ? "" : (string)row["DOB"]);
if (!(row["ORG_EMP_NO"] == System.DBNull.Value))
{
obj.OrgEmpNo = int.Parse(row["ORG_EMP_NO"].ToString());
}
else
{
obj.OrgEmpNo = null;
}
lstEmployee.Add(obj);
}
return(lstEmployee);
}
public static List <ATTEmployeeDeputaion> GetEmpForDeputationReturn(int orgid, string active)
{
try
{
List <ATTEmployeeDeputaion> LSTEmpDepReturn = new List <ATTEmployeeDeputaion>();
foreach (DataRow row in DLLEmployeeDeputation.GetEmpForDepReturn(orgid, active).Rows)
{
ATTEmployeeDeputaion objEmpDepReturn = new ATTEmployeeDeputaion();
objEmpDepReturn.EmpID = int.Parse(row["p_id"].ToString());
objEmpDepReturn.EmpName = row["employeename"].ToString();
objEmpDepReturn.Gender = row["gender"].ToString();
objEmpDepReturn.OrgID = int.Parse(row["org_id"].ToString());
objEmpDepReturn.OrgName = row["org_name"].ToString();
objEmpDepReturn.DesID = int.Parse(row["des_id"].ToString());
objEmpDepReturn.DesName = row["des_name"].ToString();
objEmpDepReturn.CreatedDate = row["created_date"].ToString();
objEmpDepReturn.PostID = int.Parse(row["post_id"].ToString());
objEmpDepReturn.PostFromDate = row["from_date"].ToString();
objEmpDepReturn.DecisionDate = row["decision_date"].ToString();
objEmpDepReturn.DepOrgID = int.Parse(row["dep_org_id"].ToString());
objEmpDepReturn.DepOrgName = row["dep_org_name"].ToString();
objEmpDepReturn.LeaveDate = row["leave_date"].ToString();
objEmpDepReturn.ReturnDate = row["return_date"].ToString();
objEmpDepReturn.Responsibilities = row["responsibilities"].ToString();
LSTEmpDepReturn.Add(objEmpDepReturn);
}
return(LSTEmpDepReturn);
}
catch (Exception ex)
{
throw ex;
}
}
public static bool AddEmpForDeputationDetail(ATTEmployeeDeputaion obj)
{
try
{
return(DLLEmployeeDeputation.AddEmpForDeputationDetail(obj));
}
catch (Exception ex)
{
throw new Exception("Error occur while adding Duptation" + ex.Message);
}
}
private ATTEmployeeDeputaion GetEmployeeFilterDep()
{
ATTEmployeeDeputaion EmployeeSearch = new ATTEmployeeDeputaion();
EmployeeSearch.OrgID = int.Parse(Session["Orgid"].ToString());
EmployeeSearch.Active = "Y";
//if (this.ddlPost.SelectedIndex > 0) EmployeeSearch.DesID = int.Parse(this.ddlPost.SelectedValue);
//if (this.ddlUnit.SelectedIndex > 0) EmployeeSearch.UnitID = int.Parse(this.ddlBranch.SelectedValue);
//if (this.ddlSection.SelectedIndex > 0) EmployeeSearch.SectionID = int.Parse(this.ddlFant.SelectedValue);
//EmployeeSearch.DesType = "O";
//EmployeeSearch.ToDate = null;
return(EmployeeSearch);
}
private ATTEmployeeDeputaion GetEmployeeFilter()
{
ATTEmployeeDeputaion EmployeeSearch = new ATTEmployeeDeputaion();
if (this.ddlOrganization.SelectedIndex > 0)
{
EmployeeSearch.OrgID = int.Parse(this.ddlOrganization.SelectedValue);
}
EmployeeSearch.Active = "Y";
//if (this.ddlPost.SelectedIndex > 0) EmployeeSearch.DesID = int.Parse(this.ddlPost.SelectedValue);
//if (this.ddlUnit.SelectedIndex > 0) EmployeeSearch.UnitID = int.Parse(this.ddlBranch.SelectedValue);
//if (this.ddlSection.SelectedIndex > 0) EmployeeSearch.SectionID = int.Parse(this.ddlFant.SelectedValue);
//EmployeeSearch.DesType = "O";
//EmployeeSearch.ToDate = null;
return(EmployeeSearch);
}
public static bool AddEmpForDeputationDetail(ATTEmployeeDeputaion obj) // added by shanjeev
{
string sp = "";
if (obj.Action == "A")
{
sp = "SP_ADD_EMP_DEPUTATION";
}
List <OracleParameter> paramArray = new List <OracleParameter>();
paramArray.Add(Utilities.GetOraParam("p_emp_id", obj.EmpID, OracleDbType.Double, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam("p_org_id", obj.OrgID, OracleDbType.Int32, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam("p_des_id", obj.DesID, OracleDbType.Int32, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam("p_created_date", obj.CreatedDate, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam("p_post_id ", obj.PostID, OracleDbType.Int32, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam("p_from_date ", obj.FromDate, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam("p_application_date ", obj.ApplicationDate, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam("p_decision_date", obj.DecisionDate, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam("p_dep_org_id ", obj.DepOrgID, OracleDbType.Int32, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam("p_decision_ver_by", obj.DecisionVerifiedBy, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam("p_responsibilities", obj.Responsibilities, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam("p_active", obj.Active, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam("p_entry_by", obj.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam("P_TIP_ORG_ID", obj.TipOrgID, OracleDbType.Int32, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam("P_TIPPANI_ID", obj.TippaniID, OracleDbType.Int32, ParameterDirection.Input));
GetConnection GetConn = new GetConnection();
OracleTransaction Tran = GetConn.GetDbConn(Module.PMS).BeginTransaction();
try
{
SqlHelper.ExecuteNonQuery(Tran, System.Data.CommandType.StoredProcedure, sp, paramArray.ToArray());
Tran.Commit();
return(true);
}
catch (Exception ex)
{
Tran.Rollback();
throw new Exception("Error occur while adding duptation details" + ex.Message);
}
finally
{
GetConn.CloseDbConn();
}
}
public static List <ATTEmployeeDeputaion> GetDeputationOrganisation()
{
List <ATTEmployeeDeputaion> lstDepOrg = new List <ATTEmployeeDeputaion>();
try
{
foreach (DataRow row in DLLEmployeeDeputation.GetDeputationOrganisations().Rows)
{
ATTEmployeeDeputaion obj = new ATTEmployeeDeputaion();
obj.DepOrgID = int.Parse(row["DEP_ORG_ID"].ToString());
obj.DepOrgName = row["DEP_ORG_NAME"].ToString();
lstDepOrg.Add(obj);
}
}
catch (Exception ex)
{
throw ex;
}
return(lstDepOrg);
}
public static List <ATTEmployeeDeputaion> GetEmpForDeputationInfo(int?orgid, string active, double empid)
{
try
{
List <ATTEmployeeDeputaion> lstEmployeeDeputaion = new List <ATTEmployeeDeputaion>();
foreach (DataRow row in DLLEmployeeDeputation.GetEmpForDeputationInfo(orgid, active, empid).Rows)
{
ATTEmployeeDeputaion objEmpDeputation = new ATTEmployeeDeputaion();
//if (row["org_id"].ToString() != "")
//{
// objEmpDeputation.OrgID = int.Parse(row["org_id"].ToString());
//}
objEmpDeputation.DepOrgName = row["dep_org_name"].ToString();
//objEmpDeputation.DesName = row["des_name"].ToString();
if (row["des_id"].ToString() != "")
{
objEmpDeputation.DesID = int.Parse(row["des_id"].ToString());
}
objEmpDeputation.DecisionDate = row["decision_date"].ToString();
if (row["decision_ver_by"].ToString() != "")
{
objEmpDeputation.DecisionVerifiedBy = int.Parse(row["decision_ver_by"].ToString());
}
objEmpDeputation.ApplicationDate = row["application_date"].ToString();
//if (row["dep_org_id"].ToString() != "")
//{
// objEmpDeputation.DepOrgID = int.Parse(row["dep_org_id"].ToString());
//}
objEmpDeputation.DepOrgName = row["dep_org_name"].ToString();
objEmpDeputation.LeaveDate = row["leave_date"].ToString();
objEmpDeputation.ReturnDate = row["return_date"].ToString();
objEmpDeputation.Responsibilities = row["responsibilities"].ToString();
lstEmployeeDeputaion.Add(objEmpDeputation);
}
return(lstEmployeeDeputaion);
}
catch (Exception ex)
{
throw ex;
}
}
private ATTEmployeeDeputaion GetFilter()
{
ATTEmployeeDeputaion DeputedEmployeeSearch = new ATTEmployeeDeputaion();
if (this.txtSymbolNo.Text.Trim() != "")
{
DeputedEmployeeSearch.SymbolNo = this.txtSymbolNo.Text.Trim();
}
if (this.txtFName.Text.Trim() != "")
{
DeputedEmployeeSearch.FirstName = this.txtFName.Text.Trim();
}
if (this.txtMName.Text.Trim() != "")
{
DeputedEmployeeSearch.MiddleName = this.txtMName.Text.Trim();
}
if (this.txtSurName.Text.Trim() != "")
{
DeputedEmployeeSearch.LastName = this.txtSurName.Text.Trim();
}
if (this.ddlGender.SelectedIndex > 0)
{
DeputedEmployeeSearch.Gender = this.ddlGender.SelectedValue;
}
if (this.txtDOB.Text.Trim() != "")
{
DeputedEmployeeSearch.DOB = this.txtDOB.Text.Trim();
}
if (this.ddlOrganization.SelectedIndex > 0)
{
DeputedEmployeeSearch.OrgID = int.Parse(this.ddlOrganization.SelectedValue);
}
if (this.ddlDeputedOrgs.SelectedIndex > 0)
{
DeputedEmployeeSearch.DepOrgID = int.Parse(this.ddlDeputedOrgs.SelectedValue);
}
return(DeputedEmployeeSearch);
}
public static DataTable GetEmpForDeputation(ATTEmployeeDeputaion objDP, string choice)
{
GetConnection conn = new GetConnection();
OracleConnection obj = conn.GetDbConn(Module.PMS);
string SelectSP = "";
if (choice == "wod")
{
SelectSP = "SP_GET_EMP_WO_DEPUTATION";
}
else if (choice == "wld")
{
SelectSP = "SP_GET_EMP_W_DEP_WO_LEAVE";
}
else if (choice == "wd")
{
SelectSP = "SP_GET_EMP_W_DEPUTATION";
}
List <OracleParameter> paramArray = new List <OracleParameter>();
paramArray.Add(Utilities.GetOraParam("P_ORG_ID", objDP.OrgID, OracleDbType.Double, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam("P_ACTIVE", objDP.Active, OracleDbType.Varchar2, ParameterDirection.Input));
//paramArray.Add(Utilities.GetOraParam("P_ORG_ID", objEmpDep.OrgID, OracleDbType.Double, ParameterDirection.Input));
//paramArray.Add(Utilities.GetOraParam("P_ORG_ID", objEmpDep.OrgID, OracleDbType.Double, ParameterDirection.Input));
//paramArray.Add(Utilities.GetOraParam("P_ORG_ID", objEmpDep.OrgID, OracleDbType.Double, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam("P_RC", null, OracleDbType.RefCursor, ParameterDirection.Output));
try
{
DataSet ds = SqlHelper.ExecuteDataset(obj, CommandType.StoredProcedure, SelectSP, paramArray.ToArray());
return((DataTable)ds.Tables[0]);
}
catch (Exception ex)
{
throw ex;
}
}
public static DataTable SearchEmployeeDeputation(ATTEmployeeDeputaion objEmployee, string searchType)
{
try
{
string strSelectSQL = "";
if (searchType == "All")
{
strSelectSQL = "SELECT DISTINCT A.EMP_ID,A.EMP_NAME,A.FIRST_NAME,A.MID_NAME,A.SUR_NAME,A.DOB,A.GENDER,A.SYMBOL_NO,"
+ "A.ORG_EMP_NO,A.ORG_ID,A.ORG_NAME,A.DES_ID,A.DES_NAME,A.DES_TYPE,A.FROM_DATE FROM VW_EMP_DEPUTATION A WHERE 1=1";
}
else if (searchType == "Current")
{
strSelectSQL = "SELECT DISTINCT A.EMP_ID,A.EMP_NAME,A.FIRST_NAME,A.MID_NAME,A.SUR_NAME,A.DOB,A.GENDER,A.SYMBOL_NO,"
+ "A.ORG_EMP_NO,A.ORG_ID,A.ORG_NAME,A.DES_ID,A.DES_NAME,A.DES_TYPE,A.FROM_DATE FROM VW_EMP_DEPUTATION A WHERE A.ORG_ID IS NOT NULL";
}
int i = 0;
if (objEmployee.EmpID != 0.0)
{
i++;
}
if (objEmployee.FirstName != null)
{
i++;
}
if (objEmployee.MiddleName != null)
{
i++;
}
if (objEmployee.LastName != null)
{
i++;
}
if (objEmployee.Gender != null)
{
i++;
}
if (objEmployee.DOB != null)
{
i++;
}
if (objEmployee.SymbolNo != null)
{
i++;
}
if (objEmployee.DesID != 0)
{
i++;
}
if (objEmployee.OrgID != 0)
{
i++;
}
if (objEmployee.DepOrgID != 0)
{
i++;
}
OracleParameter[] ParamArray = new OracleParameter[i];
int j = 0;
if (objEmployee.EmpID != 0.0)
{
strSelectSQL += " AND A.EMP_ID =:EmpID";
ParamArray[j] = Utilities.GetOraParam(":EmpID", objEmployee.EmpID, OracleDbType.Varchar2, ParameterDirection.Input);
j++;
}
if (objEmployee.FirstName != null)
{
strSelectSQL += " AND A.FIRST_NAME LIKE :FName||'%'";
ParamArray[j] = Utilities.GetOraParam(":FName", objEmployee.FirstName, OracleDbType.Varchar2, ParameterDirection.Input);
j++;
}
if (objEmployee.MiddleName != null)
{
strSelectSQL += " AND A.MID_NAME LIKE :MName||'%'";
ParamArray[j] = Utilities.GetOraParam(":MName", objEmployee.MiddleName, OracleDbType.Varchar2, ParameterDirection.Input);
j++;
}
if (objEmployee.LastName != null)
{
strSelectSQL += " AND A.SUR_NAME LIKE :SurName||'%'";
ParamArray[j] = Utilities.GetOraParam(":SurName", objEmployee.LastName, OracleDbType.Varchar2, ParameterDirection.Input);
j++;
}
if (objEmployee.Gender != null)
{
strSelectSQL += " AND A.GENDER = :Gender";
ParamArray[j] = Utilities.GetOraParam(":Gender", objEmployee.Gender, OracleDbType.Varchar2, ParameterDirection.Input);
j++;
}
if (objEmployee.DOB != null)
{
strSelectSQL += " AND A.DOB = :DOB";
ParamArray[j] = Utilities.GetOraParam(":DOB", objEmployee.DOB, OracleDbType.Varchar2, ParameterDirection.Input);
j++;
}
if (objEmployee.SymbolNo != null)
{
strSelectSQL += " AND A.SYMBOL_NO = :SymbolNo";
ParamArray[j] = Utilities.GetOraParam(":SymbolNo", objEmployee.SymbolNo, OracleDbType.Varchar2, ParameterDirection.Input);
j++;
}
if (objEmployee.DesID != 0)
{
strSelectSQL += " AND A.DES_ID = :DesID";
ParamArray[j] = Utilities.GetOraParam(":DesID", objEmployee.DesID, OracleDbType.Int64, ParameterDirection.Input);
j++;
}
if (objEmployee.OrgID != 0)
{
strSelectSQL += " AND A.ORG_ID = :OrgID";
ParamArray[j] = Utilities.GetOraParam(":OrgID", objEmployee.OrgID, OracleDbType.Int64, ParameterDirection.Input);
j++;
}
if (objEmployee.DepOrgID != 0)
{
strSelectSQL += " AND A.DEP_ORG_ID = :DepOrgID";
ParamArray[j] = Utilities.GetOraParam(":DepOrgID", objEmployee.DepOrgID, OracleDbType.Int64, ParameterDirection.Input);
j++;
}
strSelectSQL += " ORDER BY A.EMP_ID";
DataSet ds = SqlHelper.ExecuteDataset(CommandType.Text, strSelectSQL, Module.PMS, ParamArray);
return((DataTable)ds.Tables[0]);
}
catch (OracleException oex)
{
PCS.COREDL.OracleError oe = new PCS.COREDL.OracleError();
throw new ArgumentException(oe.GetOraError(oex.Number, oex.Message));
}
catch (Exception ex)
{
throw ex;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (this.txtDecisionDate.Text == "")
{
this.lblStatusMessage.Text = "र्कपया काज निर्णय मिति बर्नुहोस्";
this.programmaticModalPopup.Show();
return;
}
double empId = double.Parse(Server.HtmlDecode(grdEmployee.Rows[grdEmployee.SelectedIndex].Cells[0].Text).ToString());
foreach (GridViewRow row in this.grdEmpDepRamana.Rows)
{
if (int.Parse(row.Cells[0].Text) == empId)
{
this.lblStatusMessage.Text = "**कर्मचारी काजको लागि सिफारिस भैसकेको छ";
this.programmaticModalPopup.Show();
return;
}
}
int orgId = int.Parse(Server.HtmlDecode(grdEmployee.Rows[grdEmployee.SelectedIndex].Cells[3].Text).ToString());
int desId = int.Parse(Server.HtmlDecode(grdEmployee.Rows[grdEmployee.SelectedIndex].Cells[5].Text).ToString());
string createdDate = Server.HtmlDecode(grdEmployee.Rows[grdEmployee.SelectedIndex].Cells[7].Text).ToString();
int postId = int.Parse(Server.HtmlDecode(grdEmployee.Rows[grdEmployee.SelectedIndex].Cells[8].Text).ToString());
string fromDate = Server.HtmlDecode(grdEmployee.Rows[grdEmployee.SelectedIndex].Cells[9].Text).ToString();
string decisionDate = this.txtDecisionDate.Text;
int dep_org_id = int.Parse(this.ddlDeputationOrganization.SelectedValue);
int dicision_ver_by = 0;
string responsibility = this.txtResponsibility.Text;
string active = "Y";
string entry_by = Session["UserName"].ToString();
List <ATTEmployeeDeputaion> LSTAddDep;
if (Session["EmpDepNoLeave"] != null)
{
LSTAddDep = (List <ATTEmployeeDeputaion>)Session["EmpDepNoLeave"];
}
else
{
LSTAddDep = new List <ATTEmployeeDeputaion>();
}
if (this.ddlDeputationOrganization.SelectedIndex < -1)
{
this.lblStatusMessage.Text = "काज कार्यालय छान्नुहोस्";
this.programmaticModalPopup.Show();
}
else if (this.ddlDeputationOrganization.SelectedIndex > 0)
{
ATTEmployeeDeputaion objAddDep = new ATTEmployeeDeputaion();
objAddDep.EmpID = empId;
objAddDep.OrgID = orgId;
objAddDep.DesID = desId;
objAddDep.CreatedDate = createdDate;
objAddDep.PostID = postId;
objAddDep.FromDate = fromDate;
objAddDep.DecisionDate = decisionDate;
objAddDep.DepOrgID = dep_org_id;
objAddDep.DecisionVerifiedBy = dicision_ver_by;
objAddDep.Responsibilities = responsibility;
objAddDep.Active = active;
objAddDep.EntryBy = entry_by;
objAddDep.Action = "A";
objAddDep.LeaveDate = "";
objAddDep.LeaveVerifiedBy = 0;
LSTAddDep.Add(objAddDep);
//Session["DeputaionWOLeave"] = LSTAddDep;
if (BLLEmployeeDeputation.SaveEmpForDeputation(LSTAddDep))
{
this.lblStatusMessage.Text = "Employee Deputation Saved Successfully";
this.programmaticModalPopup.Show();
Session["EmpDepNoLeave"] = BLLEmployeeDeputation.GetEmpForDeputation(GetEmployeeFilterDep(), "wld");
grdEmpDepRamana.DataSource = Session["EmpDepNoLeave"];
grdEmpDepRamana.DataBind();
//grdEmployee.DataSource = BLLEmployeeDeputation.GetEmpForDeputation(GetEmployeeFilter(), "wod");
//this.grdEmployee.DataBind();
this.ddlDeputationOrganization.SelectedIndex = -1;
this.txtDecisionDate.Text = "";
this.txtResponsibility.Text = "";
this.txtVerifiedBy.Text = "";
return;
}
}
}
public static List <ATTEmployeeDeputaion> GetEmpForDeputation(ATTEmployeeDeputaion obj, string choice)
{
try
{
List <ATTEmployeeDeputaion> LSTDep = new List <ATTEmployeeDeputaion>();
if (choice == "wod")
{
foreach (DataRow row in DLLEmployeeDeputation.GetEmpForDeputation(obj, choice).Rows)
{
ATTEmployeeDeputaion objDep = new ATTEmployeeDeputaion();
objDep.EmpID = double.Parse(row["p_id"].ToString());
objDep.EmpName = row["employeename"].ToString();
objDep.Gender = row["gender"].ToString();
objDep.OrgID = int.Parse(row["org_id"].ToString());
objDep.OrgName = row["org_name"].ToString();
objDep.DesID = int.Parse(row["des_id"].ToString());
objDep.DesName = row["des_name"].ToString();
objDep.CreatedDate = row["created_date"].ToString();
objDep.PostID = int.Parse(row["post_id"].ToString());
objDep.FromDate = row["from_date"].ToString();
objDep.Action = "";
LSTDep.Add(objDep);
}
}
else if (choice == "wld")
{
foreach (DataRow row in DLLEmployeeDeputation.GetEmpForDeputation(obj, choice).Rows)
{
ATTEmployeeDeputaion objDep = new ATTEmployeeDeputaion();
objDep.EmpID = double.Parse(row["p_id"].ToString());
objDep.EmpName = row["employeename"].ToString();
objDep.Gender = row["gender"].ToString();
objDep.OrgID = int.Parse(row["org_id"].ToString());
objDep.OrgName = row["org_name"].ToString();
objDep.DesID = int.Parse(row["des_id"].ToString());
objDep.DesName = row["des_name"].ToString();
objDep.CreatedDate = row["created_date"].ToString();
objDep.PostID = int.Parse(row["post_id"].ToString());
objDep.FromDate = row["from_date"].ToString();
objDep.DecisionDate = row["decision_date"].ToString();
objDep.DepOrgID = int.Parse(row["dep_org_id"].ToString());
objDep.DepOrgName = row["dep_org_name"].ToString();
objDep.Responsibilities = row["responsibilities"].ToString();
objDep.Action = "";
LSTDep.Add(objDep);
}
}
else if (choice == "wd")
{
foreach (DataRow row in DLLEmployeeDeputation.GetEmpForDeputation(obj, choice).Rows)
{
ATTEmployeeDeputaion objDep = new ATTEmployeeDeputaion();
objDep.EmpID = double.Parse(row["p_id"].ToString());
objDep.EmpName = row["employeename"].ToString();
objDep.Gender = row["gender"].ToString();
objDep.OrgID = int.Parse(row["org_id"].ToString());
objDep.OrgName = row["org_name"].ToString();
objDep.DesID = int.Parse(row["des_id"].ToString());
objDep.DesName = row["des_name"].ToString();
objDep.CreatedDate = row["created_date"].ToString();
objDep.PostID = int.Parse(row["post_id"].ToString());
objDep.FromDate = row["from_date"].ToString();
objDep.DecisionDate = row["decision_date"].ToString();
objDep.DepOrgID = int.Parse(row["dep_org_id"].ToString());
objDep.DepOrgName = row["dep_org_name"].ToString();
objDep.Responsibilities = row["responsibilities"].ToString();
objDep.LeaveDate = row["leave_date"].ToString();
objDep.ReturnDate = row["return_date"].ToString();
objDep.Action = "";
LSTDep.Add(objDep);
}
}
return(LSTDep);
}
catch (Exception ex)
{
throw ex;
}
}
