public List <Department> GetListAll() { List <Department> listDepartment = null; using (DataTable table = SqlDBHelper.ExecuteSelectCommand("Department_GetListAll", CommandType.StoredProcedure)) { if (table.Rows.Count > 0) { listDepartment = new List <Department>(); foreach (DataRow row in table.Rows) { Department department = new Department(); department.DepartmentID = (row["DepartmentID"] != DBNull.Value) ? Convert.ToInt32(row["DepartmentID"]) : 0; department.DividerFullName = row["DividerFullName"].ToString(); department.ComputationTypeIDTitle = row["ComputationTypeIDTitle"].ToString(); department.MainOfficeTypeIDTitle = row["MainOfficeTypeIDTitle"].ToString(); department.AdjutancyTypeIDTitle = row["AdjutancyTypeIDTitle"].ToString(); department.ComputationTypeID = (row["ComputationTypeID"] != DBNull.Value) ? Convert.ToInt32(row["ComputationTypeID"]) : 0; department.MainOfficeTypeID = (row["MainOfficeTypeID"] != DBNull.Value) ? Convert.ToInt32(row["MainOfficeTypeID"]) : 0; department.AdjutancyTypeID = (row["AdjutancyTypeID"] != DBNull.Value) ? Convert.ToInt32(row["AdjutancyTypeID"]) : 0; department.TotalEmployeeNumber = (row["TotalEmployeeNumber"] != DBNull.Value) ? Convert.ToInt32(row["TotalEmployeeNumber"]) : 0; department.TotalContractualEmployeeNumber = (row["TotalContractualEmployeeNumber"] != DBNull.Value) ? Convert.ToInt32(row["TotalContractualEmployeeNumber"]) : 0; department.TotalPersonalScore = (row["TotalPersonalScore"] != DBNull.Value) ? Convert.ToDecimal(row["TotalPersonalScore"]) : 0; department.DividerNationalCode = (row["DividerNationalCode"] != DBNull.Value) ? Convert.ToInt64(row["DividerNationalCode"]) : 0; department.Title = row["Title"].ToString(); listDepartment.Add(department); } } } return(listDepartment); }
public List <MainOfficeType> GetListAll() { List <MainOfficeType> listMainOfficeType = null; using (DataTable table = SqlDBHelper.ExecuteSelectCommand("MainOfficeType_GetListAll", CommandType.StoredProcedure)) { if (table.Rows.Count > 0) { listMainOfficeType = new List <MainOfficeType>(); foreach (DataRow row in table.Rows) { MainOfficeType mainOfficeType = new MainOfficeType(); mainOfficeType.MainOfficeTypeID = (row["MainOfficeTypeID"] != DBNull.Value) ? Convert.ToInt32(row["MainOfficeTypeID"]) : 0; mainOfficeType.ContractualEmployeesNumber = (row["ContractualEmployeesNumber"] != DBNull.Value) ? Convert.ToInt64(row["ContractualEmployeesNumber"]) : 0; mainOfficeType.Title = row["Title"].ToString(); mainOfficeType.TotalScore = (row["TotalScore"] != DBNull.Value) ? Convert.ToDecimal(row["TotalScore"]) : 0; mainOfficeType.TotalScoreCat1 = (row["TotalScoreCat1"] != DBNull.Value) ? Convert.ToDecimal(row["TotalScoreCat1"]) : 0; mainOfficeType.TotalScoreCat2 = (row["TotalScoreCat2"] != DBNull.Value) ? Convert.ToDecimal(row["TotalScoreCat2"]) : 0; listMainOfficeType.Add(mainOfficeType); } } } return(listMainOfficeType); }
public List <Employee> GetListAll() { List <Employee> listEmployee = null; using (DataTable table = SqlDBHelper.ExecuteSelectCommand("Employee_GetListAll", CommandType.StoredProcedure)) { if (table.Rows.Count > 0) { listEmployee = new List <Employee>(); foreach (DataRow row in table.Rows) { Employee employee = new Employee(); employee.NationalCode = (row["NationalCode"] != DBNull.Value) ? Convert.ToInt64(row["NationalCode"]) : 0; employee.ContractTypeIDTitle = row["ContractTypeIDTitle"].ToString(); employee.RoleTypeIDTitle = row["RoleTypeIDTitle"].ToString(); employee.FullName = row["FullName"].ToString(); employee.DepartmentIDTitle = row["DepartmentIDTitle"].ToString(); employee.RoleTypeIDFactor = (row["RoleTypeIDFactor"] != DBNull.Value) ? Convert.ToDecimal(row["RoleTypeIDFactor"]) : 0; employee.PersonalCode = row["PersonalCode"].ToString(); employee.FirstName = row["FirstName"].ToString(); employee.LastName = row["LastName"].ToString(); employee.AccountNumber = row["AccountNumber"].ToString(); employee.ContractTypeID = (row["ContractTypeID"] != DBNull.Value) ? Convert.ToInt32(row["ContractTypeID"]) : 0; employee.RoleTypeID = (row["RoleTypeID"] != DBNull.Value) ? Convert.ToInt32(row["RoleTypeID"]) : 0; employee.DepartmentID = (row["DepartmentID"] != DBNull.Value) ? Convert.ToInt32(row["DepartmentID"]) : 0; employee.IsActiveEmployee = (row["IsActiveEmployee"] != DBNull.Value) ? Convert.ToBoolean((row["IsActiveEmployee"].ToString() == "1" || row["IsActiveEmployee"].ToString().ToLower() == "true") ? true : false) : false; listEmployee.Add(employee); } } } return(listEmployee); }
public List <BaseMonthlyInformation> GetListAll() { List <BaseMonthlyInformation> listBaseMonthlyInformation = null; using (DataTable table = SqlDBHelper.ExecuteSelectCommand("BaseMonthlyInformation_GetListAll", CommandType.StoredProcedure)) { if (table.Rows.Count > 0) { listBaseMonthlyInformation = new List <BaseMonthlyInformation>(); foreach (DataRow row in table.Rows) { BaseMonthlyInformation baseMonthlyInformation = new BaseMonthlyInformation(); baseMonthlyInformation.YearTypeID = (row["YearTypeID"] != DBNull.Value) ? Convert.ToInt32(row["YearTypeID"]) : 0; baseMonthlyInformation.MonthTypeID = (row["MonthTypeID"] != DBNull.Value) ? Convert.ToInt32(row["MonthTypeID"]) : 0; baseMonthlyInformation.MainOfficeTypeID = (row["MainOfficeTypeID"] != DBNull.Value) ? Convert.ToInt32(row["MainOfficeTypeID"]) : 0; baseMonthlyInformation.ValueToScore = (row["ValueToScore"] != DBNull.Value) ? Convert.ToDecimal(row["ValueToScore"]) : 0; baseMonthlyInformation.TotalOperationalReward = (row["TotalOperationalReward"] != DBNull.Value) ? Convert.ToInt64(row["TotalOperationalReward"]) : 0; baseMonthlyInformation.TotalOrganizationalReward = (row["TotalOrganizationalReward"] != DBNull.Value) ? Convert.ToInt64(row["TotalOrganizationalReward"]) : 0; baseMonthlyInformation.ContractualDividableReward = (row["ContractualDividableReward"] != DBNull.Value) ? Convert.ToInt64(row["ContractualDividableReward"]) : 0; baseMonthlyInformation.ContractualBossReward = (row["ContractualBossReward"] != DBNull.Value) ? Convert.ToInt64(row["ContractualBossReward"]) : 0; baseMonthlyInformation.ContractualDevotedReward = (row["ContractualDevotedReward"] != DBNull.Value) ? Convert.ToInt64(row["ContractualDevotedReward"]) : 0; baseMonthlyInformation.ContractualRemainingReward = (row["ContractualRemainingReward"] != DBNull.Value) ? Convert.ToInt64(row["ContractualRemainingReward"]) : 0; baseMonthlyInformation.DividableReward = (row["DividableReward"] != DBNull.Value) ? Convert.ToInt64(row["DividableReward"]) : 0; baseMonthlyInformation.BossReward = (row["BossReward"] != DBNull.Value) ? Convert.ToInt64(row["BossReward"]) : 0; baseMonthlyInformation.DevotedReward = (row["DevotedReward"] != DBNull.Value) ? Convert.ToInt64(row["DevotedReward"]) : 0; baseMonthlyInformation.RemainingReward = (row["RemainingReward"] != DBNull.Value) ? Convert.ToInt64(row["RemainingReward"]) : 0; baseMonthlyInformation.YearTypeIDTitle = row["YearTypeIDTitle"].ToString(); baseMonthlyInformation.MonthTypeIDTitle = row["MonthTypeIDTitle"].ToString(); baseMonthlyInformation.ContractualReward = (row["ContractualReward"] != DBNull.Value) ? Convert.ToInt64(row["ContractualReward"]) : 0; baseMonthlyInformation.ContractualConstantReward = (row["ContractualConstantReward"] != DBNull.Value) ? Convert.ToInt64(row["ContractualConstantReward"]) : 0; baseMonthlyInformation.ExtraReward = (row["ExtraReward"] != DBNull.Value) ? Convert.ToInt64(row["ExtraReward"]) : 0; baseMonthlyInformation.Factor5 = (row["Factor5"] != DBNull.Value) ? Convert.ToDecimal(row["Factor5"]) : 0; baseMonthlyInformation.Factor6 = (row["Factor6"] != DBNull.Value) ? Convert.ToDecimal(row["Factor6"]) : 0; baseMonthlyInformation.Factor7 = (row["Factor7"] != DBNull.Value) ? Convert.ToDecimal(row["Factor7"]) : 0; baseMonthlyInformation.Factor8 = (row["Factor8"] != DBNull.Value) ? Convert.ToDecimal(row["Factor8"]) : 0; baseMonthlyInformation.Factor9 = (row["Factor9"] != DBNull.Value) ? Convert.ToDecimal(row["Factor9"]) : 0; baseMonthlyInformation.Factor10 = (row["Factor10"] != DBNull.Value) ? Convert.ToDecimal(row["Factor10"]) : 0; baseMonthlyInformation.OfficialReward = (row["OfficialReward"] != DBNull.Value) ? Convert.ToInt64(row["OfficialReward"]) : 0; baseMonthlyInformation.IsFanalized = (row["IsFanalized"] != DBNull.Value) ? Convert.ToBoolean((row["IsFanalized"].ToString() == "1" || row["IsFanalized"].ToString().ToLower() == "true") ? true : false) : false; baseMonthlyInformation.IsFainalizedEmployeesInformation = (row["IsFainalizedEmployeesInformation"] != DBNull.Value) ? Convert.ToBoolean((row["IsFainalizedEmployeesInformation"].ToString() == "1" || row["IsFainalizedEmployeesInformation"].ToString().ToLower() == "true") ? true : false) : false; baseMonthlyInformation.IsFainalizedRewardCalculation = (row["IsFainalizedRewardCalculation"] != DBNull.Value) ? Convert.ToBoolean((row["IsFainalizedRewardCalculation"].ToString() == "1" || row["IsFainalizedRewardCalculation"].ToString().ToLower() == "true") ? true : false) : false; baseMonthlyInformation.BossFactor = (row["BossFactor"] != DBNull.Value) ? Convert.ToDecimal(row["BossFactor"]) : 0; baseMonthlyInformation.OperationalFactor = (row["OperationalFactor"] != DBNull.Value) ? Convert.ToDecimal(row["OperationalFactor"]) : 0; baseMonthlyInformation.Factor1 = (row["Factor1"] != DBNull.Value) ? Convert.ToDecimal(row["Factor1"]) : 0; baseMonthlyInformation.Factor2 = (row["Factor2"] != DBNull.Value) ? Convert.ToDecimal(row["Factor2"]) : 0; baseMonthlyInformation.Factor3 = (row["Factor3"] != DBNull.Value) ? Convert.ToDecimal(row["Factor3"]) : 0; baseMonthlyInformation.Factor4 = (row["Factor4"] != DBNull.Value) ? Convert.ToDecimal(row["Factor4"]) : 0; listBaseMonthlyInformation.Add(baseMonthlyInformation); } } } return(listBaseMonthlyInformation); }
public List <OfficialEmployeeReward> GetListAll() { List <OfficialEmployeeReward> listOfficialEmployeeReward = null; using (DataTable table = SqlDBHelper.ExecuteSelectCommand("OfficialEmployeeReward_GetListAll", CommandType.StoredProcedure)) { if (table.Rows.Count > 0) { listOfficialEmployeeReward = new List <OfficialEmployeeReward>(); foreach (DataRow row in table.Rows) { OfficialEmployeeReward officialEmployeeReward = new OfficialEmployeeReward(); officialEmployeeReward.NationalCode = (row["NationalCode"] != DBNull.Value) ? Convert.ToInt64(row["NationalCode"]) : 0; officialEmployeeReward.YearTypeID = (row["YearTypeID"] != DBNull.Value) ? Convert.ToInt32(row["YearTypeID"]) : 0; officialEmployeeReward.MonthTypeID = (row["MonthTypeID"] != DBNull.Value) ? Convert.ToInt32(row["MonthTypeID"]) : 0; officialEmployeeReward.EmployeeFullName = row["EmployeeFullName"].ToString(); officialEmployeeReward.DepartmentIDTitle = row["DepartmentIDTitle"].ToString(); officialEmployeeReward.YearTypeIDTitle = row["YearTypeIDTitle"].ToString(); officialEmployeeReward.MonthTypeIDTitle = row["MonthTypeIDTitle"].ToString(); officialEmployeeReward.RoleTypeIDTitle = row["RoleTypeIDTitle"].ToString(); officialEmployeeReward.TotalReward = (row["TotalReward"] != DBNull.Value) ? Convert.ToInt64(row["TotalReward"]) : 0; officialEmployeeReward.Reward_ = (row["Reward_"] != DBNull.Value) ? Convert.ToInt64(row["Reward_"]) : 0; officialEmployeeReward.RoleTypeIDFactor = (row["RoleTypeIDFactor"] != DBNull.Value) ? Convert.ToDecimal(row["RoleTypeIDFactor"]) : 0; officialEmployeeReward.BossFactor = (row["BossFactor"] != DBNull.Value) ? Convert.ToDecimal(row["BossFactor"]) : 0; officialEmployeeReward.Reward = (row["Reward"] != DBNull.Value) ? Convert.ToInt64(row["Reward"]) : 0; officialEmployeeReward.BossFinalValue = (row["BossFinalValue"] != DBNull.Value) ? Convert.ToInt64(row["BossFinalValue"]) : 0; officialEmployeeReward.AssistantFinalValue = (row["AssistantFinalValue"] != DBNull.Value) ? Convert.ToInt64(row["AssistantFinalValue"]) : 0; officialEmployeeReward.ManagerFinalValue = (row["ManagerFinalValue"] != DBNull.Value) ? Convert.ToInt64(row["ManagerFinalValue"]) : 0; officialEmployeeReward.ExtraReward1 = (row["ExtraReward1"] != DBNull.Value) ? Convert.ToInt64(row["ExtraReward1"]) : 0; officialEmployeeReward.ExtraReward2 = (row["ExtraReward2"] != DBNull.Value) ? Convert.ToInt64(row["ExtraReward2"]) : 0; officialEmployeeReward.ExtraReward3 = (row["ExtraReward3"] != DBNull.Value) ? Convert.ToInt64(row["ExtraReward3"]) : 0; officialEmployeeReward.RoleTypeID = (row["RoleTypeID"] != DBNull.Value) ? Convert.ToInt32(row["RoleTypeID"]) : 0; officialEmployeeReward.Parameter1 = (row["Parameter1"] != DBNull.Value) ? Convert.ToInt32(row["Parameter1"]) : 0; officialEmployeeReward.Parameter2 = (row["Parameter2"] != DBNull.Value) ? Convert.ToInt32(row["Parameter2"]) : 0; officialEmployeeReward.Parameter3 = (row["Parameter3"] != DBNull.Value) ? Convert.ToInt32(row["Parameter3"]) : 0; listOfficialEmployeeReward.Add(officialEmployeeReward); } } } return(listOfficialEmployeeReward); }
public List <ActivityType> GetListAll() { List <ActivityType> listActivityType = null; using (DataTable table = SqlDBHelper.ExecuteSelectCommand("ActivityType_GetListAll", CommandType.StoredProcedure)) { if (table.Rows.Count > 0) { listActivityType = new List <ActivityType>(); foreach (DataRow row in table.Rows) { ActivityType activityType = new ActivityType(); activityType.ActivityTypeID = (row["ActivityTypeID"] != DBNull.Value) ? Convert.ToInt32(row["ActivityTypeID"]) : 0; activityType.Title = row["Title"].ToString(); listActivityType.Add(activityType); } } } return(listActivityType); }
public List <User> GetListAll() { List <User> listUser = null; using (DataTable table = SqlDBHelper.ExecuteSelectCommand("User_GetListAll", CommandType.StoredProcedure)) { if (table.Rows.Count > 0) { listUser = new List <User>(); foreach (DataRow row in table.Rows) { User user = new User(); user.NationalCode = (row["NationalCode"] != DBNull.Value) ? Convert.ToInt64(row["NationalCode"]) : 0; user.Password = row["Password"].ToString(); user.LastPassChangeDate = row["LastPassChangeDate"].ToString(); user.IsActiveUser = (row["IsActiveUser"] != DBNull.Value) ? Convert.ToBoolean((row["IsActiveUser"].ToString() == "1" || row["IsActiveUser"].ToString().ToLower() == "true") ? true : false) : false; Employee employee = employeeDBAccess.GetDetails(user.NationalCode); user.ContractTypeIDTitle = employee.ContractTypeIDTitle; user.RoleTypeIDTitle = employee.RoleTypeIDTitle; user.FullName = employee.FullName; user.DepartmentIDTitle = employee.DepartmentIDTitle; user.RoleTypeIDFactor = employee.RoleTypeIDFactor; user.PersonalCode = employee.PersonalCode; user.FirstName = employee.FirstName; user.LastName = employee.LastName; user.AccountNumber = employee.AccountNumber; user.ContractTypeID = employee.ContractTypeID; user.RoleTypeID = employee.RoleTypeID; user.DepartmentID = employee.DepartmentID; user.IsActiveEmployee = employee.IsActiveEmployee; listUser.Add(user); } } } return(listUser); }
public List <RoleType> GetListAll() { List <RoleType> listRoleType = null; using (DataTable table = SqlDBHelper.ExecuteSelectCommand("RoleType_GetListAll", CommandType.StoredProcedure)) { if (table.Rows.Count > 0) { listRoleType = new List <RoleType>(); foreach (DataRow row in table.Rows) { RoleType roleType = new RoleType(); roleType.RoleTypeID = (row["RoleTypeID"] != DBNull.Value) ? Convert.ToInt32(row["RoleTypeID"]) : 0; roleType.Factor = (row["Factor"] != DBNull.Value) ? Convert.ToDecimal(row["Factor"]) : 0; roleType.Title = row["Title"].ToString(); listRoleType.Add(roleType); } } } return(listRoleType); }
public List <EmployeeUserType> GetListAll() { List <EmployeeUserType> listEmployeeUserType = null; using (DataTable table = SqlDBHelper.ExecuteSelectCommand("EmployeeUserType_GetListAll", CommandType.StoredProcedure)) { if (table.Rows.Count > 0) { listEmployeeUserType = new List <EmployeeUserType>(); foreach (DataRow row in table.Rows) { EmployeeUserType employeeUserType = new EmployeeUserType(); employeeUserType.UserTypeID = (row["UserTypeID"] != DBNull.Value) ? Convert.ToInt32(row["UserTypeID"]) : 0; employeeUserType.NationalCode = (row["NationalCode"] != DBNull.Value) ? Convert.ToInt64(row["NationalCode"]) : 0; employeeUserType.EmployeeFullName = row["EmployeeFullName"].ToString(); employeeUserType.UserTypeIDTitle = row["UserTypeIDTitle"].ToString(); listEmployeeUserType.Add(employeeUserType); } } } return(listEmployeeUserType); }