public static int UpdateEmpStatus(A2ZEMPLOYEEDTO dto) { SqlDateTime sqldatenull; sqldatenull = SqlDateTime.Null; SqlParameter param1 = new SqlParameter("@EmpStatusDate", DBNull.Value); if (dto.StatusNullDate == "") { param1 = new SqlParameter("@EmpStatusDate", DBNull.Value); } else { param1 = new SqlParameter("@EmpStatusDate", dto.StatusDate); } int result = Helper.SqlHelper.ExecuteNonQuery(DataAccessLayer.Constants.DBConstants.GetConnectionString("A2ZHRMCUS"), "Sp_EmpStatusChangeUpdate", new object[] { dto.EmployeeID, dto.Status, dto.StatusDesc, param1 }); if (result == 0) { return(0); } else { return(1); } }
public static int UpdateInformation(A2ZEMPLOYEEDTO dto) { SqlDateTime sqldatenull; sqldatenull = SqlDateTime.Null; SqlParameter param1 = new SqlParameter("@EmpJoinDate", DBNull.Value); SqlParameter param2 = new SqlParameter("@EmpPerDate", DBNull.Value); SqlParameter param3 = new SqlParameter("@EmpLastPostingDate ", DBNull.Value); SqlParameter param4 = new SqlParameter("@EmpLastPromotionDate ", DBNull.Value); SqlParameter param5 = new SqlParameter("@EmpLastIncrementDate ", DBNull.Value); SqlParameter param6 = new SqlParameter("@EmpDOB ", DBNull.Value); SqlParameter param7 = new SqlParameter("@EmpIssueDate", DBNull.Value); SqlParameter param8 = new SqlParameter("@EmpPExpireDate", DBNull.Value); SqlParameter param9 = new SqlParameter("@EmpLExpiryDate", DBNull.Value); SqlParameter param10 = new SqlParameter("@StatusDate", DBNull.Value); if (dto.EmpJoinNullDate == "") { param1 = new SqlParameter("@EmpJoinDate", DBNull.Value); } else { param1 = new SqlParameter("@EmpJoinDate", dto.EmpJoinDate); } if (dto.EmpPerNullDate == "") { param2 = new SqlParameter("@EmpPerDate", DBNull.Value); } else { param2 = new SqlParameter("@EmpPerDate", dto.EmpPerDate); } if (dto.EmpLastPostingNullDate == "") { param3 = new SqlParameter("@EmpLastPostingDate", DBNull.Value); } else { param3 = new SqlParameter("@EmpLstPostingDate", dto.EmpLastPostingDate); } if (dto.EmpLastPromotionNullDate == "") { param4 = new SqlParameter("@EmpLastPromotionDate", DBNull.Value); } else { param4 = new SqlParameter("@EmpLastPromotionDate", dto.EmpLastPromotionDate); } if (dto.EmpLastIncrementNullDate == "") { param5 = new SqlParameter("@EmpLastIncrementDate", DBNull.Value); } else { param5 = new SqlParameter("@EmpLastIncrementDate", dto.EmpLastIncrementDate); } if (dto.EmpDOBNullDate == "") { param6 = new SqlParameter("@EmpDOB", DBNull.Value); } else { param6 = new SqlParameter("@EmpDOB", dto.EmpDOB); } if (dto.EmpIssueNullDate == "") { param7 = new SqlParameter("@EmpIssueDate", DBNull.Value); } else { param7 = new SqlParameter("@EmpIssueDate", dto.EmpIssueDate); } if (dto.EmpPExpireNullDate == "") { param8 = new SqlParameter("@EmpPExpireDate", DBNull.Value); } else { param8 = new SqlParameter("@EmpPExpireDate", dto.EmpPExpireDate); } if (dto.EmpLExpiryNullDate == "") { param9 = new SqlParameter("@EmpLExpiryDate", DBNull.Value); } else { param9 = new SqlParameter("@EmpLExpiryDate", dto.EmpLExpiryDate); } int result = Helper.SqlHelper.ExecuteNonQuery(DataAccessLayer.Constants.DBConstants.GetConnectionString("A2ZHRMCUS"), "Sp_EmployeeDataUpdate", new object[] { dto.EmployeeID, dto.EmployeeName, dto.EmpBaseGrade, dto.EmpGrade, dto.EmpGradeDesc, dto.EmpDesignation, dto.ServiceType, dto.EmpSTypeDesc, dto.EmpArea, dto.EmpLocation, dto.EmpDepartment, dto.EmpSection, dto.EmpProject, param1, param2, param3, param4, param5, param6, dto.EmpBank, dto.EmpAccNo, dto.EmpFatherName, dto.EmpMotherName, dto.EmpSpouseName, dto.EmpNationality, dto.EmpNationalityDesc, dto.EmpRelagion, dto.EmpRelagionDesc, dto.EmpGender, dto.EmpGenderDesc, dto.EmpMaritalStat, dto.EmpMaritalStatDesc, dto.EmpBloodGrp, dto.EmpHeight, dto.EmpNationalID, dto.TIN, dto.EmpPPNo, param7, param8, dto.EmpPlaceofIssue, dto.EmpLicenseNo, param9, dto.EmpPayLabel, dto.EmpConsolidatedAmt, dto.EmpConsolidatedDesc }); if (result == 0) { return(0); } else { return(1); } }
public static A2ZEMPLOYEEDTO GetInformation(int EmpID) { DataTable dt = new DataTable(); string strQuery = "SELECT * FROM A2ZEMPLOYEE WHERE EmpCode = '" + EmpID + "'"; dt = BLL.CommonManager.Instance.GetDataTableByQuery(strQuery, "A2ZHRMCUS"); var p = new A2ZEMPLOYEEDTO(); if (dt.Rows.Count > 0) { p.EmployeeID = Converter.GetInteger(dt.Rows[0]["EmpCode"]); p.EmployeeName = Converter.GetString(dt.Rows[0]["EmpName"]); p.EmpBaseGrade = Converter.GetSmallInteger(dt.Rows[0]["EmpBaseGrade"]); p.EmpGrade = Converter.GetSmallInteger(dt.Rows[0]["EmpGrade"]); p.EmpGradeDesc = Converter.GetString(dt.Rows[0]["EmpGradeDesc"]); p.EmpDesignation = Converter.GetSmallInteger(dt.Rows[0]["EmpDesignation"]); p.EmpDesigDesc = Converter.GetString(dt.Rows[0]["EmpDesigDesc"]); p.ServiceType = Converter.GetSmallInteger(dt.Rows[0]["EmpServiceType"]); p.EmpSTypeDesc = Converter.GetString(dt.Rows[0]["EmpSTypeDesc"]); p.EmpArea = Converter.GetInteger(dt.Rows[0]["EmpArea"]); p.EmpAreaDesc = Converter.GetString(dt.Rows[0]["EmpAreaDesc"]); p.EmpLocation = Converter.GetInteger(dt.Rows[0]["EmpLocation"]); p.EmpLocationDesc = Converter.GetString(dt.Rows[0]["EmpLocationDesc"]); p.EmpSection = Converter.GetSmallInteger(dt.Rows[0]["EmpSection"]); p.EmpSectionDesc = Converter.GetString(dt.Rows[0]["EmpSectionDesc"]); p.EmpDepartment = Converter.GetSmallInteger(dt.Rows[0]["EmpDepartment"]); p.EmpDepartmentDesc = Converter.GetString(dt.Rows[0]["EmpDepartmentDesc"]); p.EmpProject = Converter.GetSmallInteger(dt.Rows[0]["EmpProject"]); p.EmpProjectDesc = Converter.GetString(dt.Rows[0]["EmpProjectDesc"]); p.EmpCashCode = Converter.GetInteger(dt.Rows[0]["EmpCashCode"]); p.EmpJoinDate = Converter.GetDateTime(dt.Rows[0]["EmpJoinDate"]); p.EmpPerDate = Converter.GetDateTime(dt.Rows[0]["EmpPerDate"]); p.EmpLastPostingDate = Converter.GetDateTime(dt.Rows[0]["EmpLastPostingDate"]); p.EmpLastPromotionDate = Converter.GetDateTime(dt.Rows[0]["EmpLastPromotionDate"]); p.EmpLastIncrementDate = Converter.GetDateTime(dt.Rows[0]["EmpLastIncrementDate"]); p.EmpBank = Converter.GetSmallInteger(dt.Rows[0]["EmpBank"]); p.EmpAccNo = Converter.GetString(dt.Rows[0]["EmpAccNo"]); p.EmpFatherName = Converter.GetString(dt.Rows[0]["EmpFName"]); p.EmpMotherName = Converter.GetString(dt.Rows[0]["EmpMName"]); p.EmpDOB = Converter.GetDateTime(dt.Rows[0]["EmpDOB"]); p.EmpSpouseName = Converter.GetString(dt.Rows[0]["EmpSpouseName"]); p.EmpNationality = Converter.GetSmallInteger(dt.Rows[0]["EmpNationality"]); p.EmpNationalityDesc = Converter.GetString(dt.Rows[0]["EmpNationalityDesc"]); p.EmpRelagion = Converter.GetSmallInteger(dt.Rows[0]["EmpRelagion"]); p.EmpRelagionDesc = Converter.GetString(dt.Rows[0]["EmpRelagionDesc"]); p.EmpGender = Converter.GetSmallInteger(dt.Rows[0]["EmpGender"]); p.EmpGenderDesc = Converter.GetString(dt.Rows[0]["EmpGenderDesc"]); p.EmpMaritalStat = Converter.GetSmallInteger(dt.Rows[0]["EmpMaritalStat"]); p.EmpMaritalStatDesc = Converter.GetString(dt.Rows[0]["EmpMaritalStatDesc"]); p.EmpBloodGrp = Converter.GetString(dt.Rows[0]["EmpBloodGrp"]); p.EmpHeight = Converter.GetString(dt.Rows[0]["EmpHeight"]); p.EmpNationalID = Converter.GetString(dt.Rows[0]["EmpNationalID"]); p.TIN = Converter.GetString(dt.Rows[0]["EmpTIN"]); p.EmpPPNo = Converter.GetString(dt.Rows[0]["EmpPPNo"]); p.EmpIssueDate = Converter.GetDateTime(dt.Rows[0]["EmpIssueDate"]); p.EmpPExpireDate = Converter.GetDateTime(dt.Rows[0]["EmpPExpireDate"]); p.EmpPlaceofIssue = Converter.GetString(dt.Rows[0]["EmpPlaceofIssue"]); p.EmpLicenseNo = Converter.GetString(dt.Rows[0]["EmpLicenseNo"]); p.EmpLExpiryDate = Converter.GetDateTime(dt.Rows[0]["EmpLExpiryDate"]); p.EmpPayLabel = Converter.GetSmallInteger(dt.Rows[0]["EmpPayLabel"]); p.EmpConsolidatedAmt = Converter.GetDecimal(dt.Rows[0]["EmpConsolidatedAmt"]); p.EmpConsolidatedDesc = Converter.GetString(dt.Rows[0]["EmpConsolidatedDesc"]); p.Status = Converter.GetSmallInteger(dt.Rows[0]["Status"]); p.StatusDate = Converter.GetDateTime(dt.Rows[0]["StatusDate"]); return(p); } p.EmployeeID = 0; return(p); }