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);
}
