public static bool SaveEmpRetirement(List <ATTRetirement> LSTRet)
 {
     try
     {
         return(DLLRetirement.SaveEmpRetirement(LSTRet));
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
 public static List <ATTRetirement> SearchEmployee(ATTRetirement objEmpRet)
 {
     try
     {
         List <ATTRetirement> LSTEmpRet = new List <ATTRetirement>();
         foreach (DataRow row in DLLRetirement.SearchEmployee(objEmpRet).Rows)
         {
             ATTRetirement obj = new ATTRetirement();
             obj.empID = int.Parse(row["P_ID"].ToString());
             string first_name = row["FIRST_NAME"].ToString();
             string mid_name   = row["MID_NAME"].ToString();
             string sur_name   = row["SUR_NAME"].ToString();
             if (mid_name != "")
             {
                 obj.fullName = first_name + " " + mid_name + " " + sur_name;
             }
             else
             {
                 obj.fullName = first_name + " " + sur_name;
             }
             //obj.OrgEmpNo = int.Parse(row["ORG_EMP_NO"].ToString());
             obj.gender      = row["GENDER"].ToString();
             obj.orgID       = int.Parse(row["ORG_ID"].ToString());
             obj.orgName     = row["ORG_NAME"].ToString();
             obj.desID       = int.Parse(row["DES_ID"].ToString());
             obj.desName     = row["DES_NAME"].ToString();
             obj.desType     = row["DES_TYPE"].ToString();
             obj.createdDate = row["CREATED_DATE"].ToString();
             obj.postID      = int.Parse(row["POST_ID"].ToString());
             obj.fromDate    = row["POST_FROM_DATE"].ToString();
             obj.action      = "";
             LSTEmpRet.Add(obj);
         }
         return(LSTEmpRet);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
        public static List <ATTRetirement> GetEmployeeRetirement(ATTRetirement objRetirement, string opt)
        {
            List <ATTRetirement> LST = new List <ATTRetirement>();

            try
            {
                if (opt == "appl")
                {
                    foreach (DataRow row in DLLRetirement.GetEmployeeRetirement(objRetirement, opt).Rows)
                    {
                        ATTRetirement objEmpRet = new ATTRetirement();
                        objEmpRet.empID          = int.Parse(row["EMP_ID"].ToString());
                        objEmpRet.orgID          = int.Parse(row["ORG_ID"].ToString());
                        objEmpRet.postID         = int.Parse(row["POST_ID"].ToString());
                        objEmpRet.desID          = int.Parse(row["DES_ID"].ToString());
                        objEmpRet.createdDate    = row["CREATED_DATE"].ToString();
                        objEmpRet.fromDate       = row["FROM_DATE"].ToString();
                        objEmpRet.fullName       = row["EMP_NAME"].ToString();
                        objEmpRet.gender         = row["GENDER"].ToString();
                        objEmpRet.retirementDate = row["RETIREMENT_DATE"].ToString();
                        objEmpRet.isSelf         = row["IS_SELF"].ToString();
                        objEmpRet.retirementType = row["RETIREMENT_TYPE"].ToString();
                        objEmpRet.ApplDesc       = row["APP_DESC"].ToString();
                        objEmpRet.isDecided      = row["IS_DECIDED"].ToString();
                        objEmpRet.isApproved     = row["IS_APPROVED"].ToString();
                        LST.Add(objEmpRet);
                    }
                }
                else if (opt == "dec")
                {
                    foreach (DataRow row in DLLRetirement.GetEmployeeRetirement(objRetirement, opt).Rows)
                    {
                        ATTRetirement objEmpRet = new ATTRetirement();
                        objEmpRet.empID          = int.Parse(row["EMP_ID"].ToString());
                        objEmpRet.orgID          = int.Parse(row["ORG_ID"].ToString());
                        objEmpRet.postID         = int.Parse(row["POST_ID"].ToString());
                        objEmpRet.desID          = int.Parse(row["DES_ID"].ToString());
                        objEmpRet.createdDate    = row["CREATED_DATE"].ToString();
                        objEmpRet.fromDate       = row["FROM_DATE"].ToString();
                        objEmpRet.fullName       = row["EMP_NAME"].ToString();
                        objEmpRet.gender         = row["GENDER"].ToString();
                        objEmpRet.retirementDate = row["RETIREMENT_DATE"].ToString();
                        objEmpRet.isSelf         = row["IS_SELF"].ToString();
                        objEmpRet.retirementType = row["RETIREMENT_TYPE"].ToString();
                        objEmpRet.ApplDesc       = row["APP_DESC"].ToString();
                        objEmpRet.decisionDate   = row["DECISION_DATE"].ToString();
                        if (row["DECISION_BY"] != System.DBNull.Value)
                        {
                            objEmpRet.decisionBy = int.Parse(row["DECISION_BY"].ToString());
                        }
                        objEmpRet.decPerson    = row["DECISION_PERSON"].ToString();
                        objEmpRet.decisionDesc = row["DECISION_DESC"].ToString();
                        objEmpRet.isDecided    = row["IS_DECIDED"].ToString();
                        objEmpRet.isApproved   = row["IS_APPROVED"].ToString();
                        LST.Add(objEmpRet);
                    }
                }
                else if (opt == "appr")
                {
                    foreach (DataRow row in DLLRetirement.GetEmployeeRetirement(objRetirement, opt).Rows)
                    {
                        ATTRetirement objEmpRet = new ATTRetirement();
                        objEmpRet.empID          = int.Parse(row["EMP_ID"].ToString());
                        objEmpRet.orgID          = int.Parse(row["ORG_ID"].ToString());
                        objEmpRet.postID         = int.Parse(row["POST_ID"].ToString());
                        objEmpRet.createdDate    = row["CREATED_DATE"].ToString();
                        objEmpRet.fromDate       = row["FROM_DATE"].ToString();
                        objEmpRet.fullName       = row["EMP_NAME"].ToString();
                        objEmpRet.gender         = row["GENDER"].ToString();
                        objEmpRet.retirementDate = row["RETIREMENT_DATE"].ToString();
                        objEmpRet.isSelf         = row["IS_SELF"].ToString();
                        objEmpRet.retirementType = row["RETIREMENT_TYPE"].ToString();
                        objEmpRet.ApplDesc       = row["APP_DESC"].ToString();
                        objEmpRet.decisionDate   = row["DECISION_DATE"].ToString();
                        objEmpRet.decisionBy     = int.Parse(row["DECISION_BY"].ToString());
                        objEmpRet.decPerson      = row["DECISION_PERSON"].ToString();
                        objEmpRet.decisionDesc   = row["DECISION_DESC"].ToString();
                        objEmpRet.appDate        = row["APP_DATE"].ToString();
                        if (row["APP_BY"] != System.DBNull.Value)
                        {
                            objEmpRet.appBy = int.Parse(row["APP_BY"].ToString());
                        }
                        objEmpRet.apprPerson = row["APP_PERSON"].ToString();
                        objEmpRet.appDesc    = row["APP_DESC"].ToString();
                        objEmpRet.isDecided  = row["IS_DECIDED"].ToString();
                        objEmpRet.isApproved = row["IS_APPROVED"].ToString();
                        LST.Add(objEmpRet);
                    }
                }
                return(LST);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }