public List <ContractualEmployeeReward> GetListContractualEmployeeReward(int yearTypeID)
{
List <ContractualEmployeeReward> listContractualEmployeeReward = new List <ContractualEmployeeReward>()
{
};
SqlParameter[] parametersYearType = new SqlParameter[]
{
new SqlParameter("@YearTypeID", yearTypeID)
};
//Lets get the list of ContractualEmployeeReward records from database
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("ContractualEmployeeReward_GetList_UseInYearType", CommandType.StoredProcedure, parametersYearType))
{
//check if any record exists or not
if (table.Rows.Count > 0)
{
//Lets go ahead and create the list of contractualEmployeeReward
listContractualEmployeeReward = new List <ContractualEmployeeReward>();
//Now lets populate the ContractualEmployeeReward details into the list of contractualEmployeeRewards
foreach (DataRow row in table.Rows)
{
ContractualEmployeeReward contractualEmployeeReward = ConvertRowToContractualEmployeeReward(row);
listContractualEmployeeReward.Add(contractualEmployeeReward);
}
}
}
return(listContractualEmployeeReward);
}
public List <BaseMonthlyInformation> GetListBaseMonthlyInformation(int mainOfficeTypeID)
{
List <BaseMonthlyInformation> listBaseMonthlyInformation = new List <BaseMonthlyInformation>()
{
};
SqlParameter[] parametersMainOfficeType = new SqlParameter[]
{
new SqlParameter("@MainOfficeTypeID", mainOfficeTypeID)
};
//Lets get the list of BaseMonthlyInformation records from database
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("BaseMonthlyInformation_GetList_UseInMainOfficeType", CommandType.StoredProcedure, parametersMainOfficeType))
{
//check if any record exists or not
if (table.Rows.Count > 0)
{
//Lets go ahead and create the list of baseMonthlyInformation
listBaseMonthlyInformation = new List <BaseMonthlyInformation>();
//Now lets populate the BaseMonthlyInformation details into the list of baseMonthlyInformations
foreach (DataRow row in table.Rows)
{
BaseMonthlyInformation baseMonthlyInformation = ConvertRowToBaseMonthlyInformation(row);
listBaseMonthlyInformation.Add(baseMonthlyInformation);
}
}
}
return(listBaseMonthlyInformation);
}
public List <RoleType> SearchLike(RoleType roleType)
{
List <RoleType> listRoleType = new List <RoleType>();
SqlParameter[] parametersRoleType = new SqlParameter[]
{
new SqlParameter("@RoleTypeID", roleType.RoleTypeID),
new SqlParameter("@Factor", roleType.Factor),
new SqlParameter("@Title", roleType.Title),
};
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("RoleType_SearchLike", CommandType.StoredProcedure, parametersRoleType))
{
if (table.Rows.Count > 0)
{
foreach (DataRow row in table.Rows)
{
RoleType tmpRoleType = new RoleType();
tmpRoleType.RoleTypeID = (row["RoleTypeID"] != DBNull.Value) ? Convert.ToInt32(row["RoleTypeID"]) : 0;
tmpRoleType.Factor = (row["Factor"] != DBNull.Value) ? Convert.ToDecimal(row["Factor"]) : 0;
tmpRoleType.Title = row["Title"].ToString();
listRoleType.Add(tmpRoleType);
}
}
}
return(listRoleType);
}
public List <Employee> GetListEmployee(int departmentID)
{
List <Employee> listEmployee = new List <Employee>()
{
};
SqlParameter[] parametersDepartment = new SqlParameter[]
{
new SqlParameter("@DepartmentID", departmentID)
};
//Lets get the list of Employee records from database
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("Employee_GetList_UseInDepartment", CommandType.StoredProcedure, parametersDepartment))
{
//check if any record exists or not
if (table.Rows.Count > 0)
{
//Lets go ahead and create the list of employee
listEmployee = new List <Employee>();
//Now lets populate the Employee details into the list of employees
foreach (DataRow row in table.Rows)
{
Employee employee = ConvertRowToEmployee(row);
listEmployee.Add(employee);
}
}
}
return(listEmployee);
}
public List <DepartmentMonthlyInformation> GetListDepartmentMonthlyInformation(int departmentID)
{
List <DepartmentMonthlyInformation> listDepartmentMonthlyInformation = new List <DepartmentMonthlyInformation>()
{
};
SqlParameter[] parametersDepartment = new SqlParameter[]
{
new SqlParameter("@DepartmentID", departmentID)
};
//Lets get the list of DepartmentMonthlyInformation records from database
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("DepartmentMonthlyInformation_GetList_UseInDepartment", CommandType.StoredProcedure, parametersDepartment))
{
//check if any record exists or not
if (table.Rows.Count > 0)
{
//Lets go ahead and create the list of departmentMonthlyInformation
listDepartmentMonthlyInformation = new List <DepartmentMonthlyInformation>();
//Now lets populate the DepartmentMonthlyInformation details into the list of departmentMonthlyInformations
foreach (DataRow row in table.Rows)
{
DepartmentMonthlyInformation departmentMonthlyInformation = ConvertRowToDepartmentMonthlyInformation(row);
listDepartmentMonthlyInformation.Add(departmentMonthlyInformation);
}
}
}
return(listDepartmentMonthlyInformation);
}
public Department GetDetails(int departmentID)
{
Department department = new Department();
SqlParameter[] parametersDepartment = new SqlParameter[]
{
new SqlParameter("@DepartmentID", departmentID)
};
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("Department_GetDetails", CommandType.StoredProcedure, parametersDepartment))
{
if (table.Rows.Count == 1)
{
DataRow row = table.Rows[0];
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();
}
}
return(department);
}
public MainOfficeType GetDetails(int mainOfficeTypeID)
{
MainOfficeType mainOfficeType = new MainOfficeType();
SqlParameter[] parametersMainOfficeType = new SqlParameter[]
{
new SqlParameter("@MainOfficeTypeID", mainOfficeTypeID)
};
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("MainOfficeType_GetDetails", CommandType.StoredProcedure, parametersMainOfficeType))
{
if (table.Rows.Count == 1)
{
DataRow row = table.Rows[0];
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;
}
}
return(mainOfficeType);
}
public List <Department> GetListDepartment(int mainOfficeTypeID)
{
List <Department> listDepartment = new List <Department>()
{
};
SqlParameter[] parametersMainOfficeType = new SqlParameter[]
{
new SqlParameter("@MainOfficeTypeID", mainOfficeTypeID)
};
//Lets get the list of Department records from database
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("Department_GetList_UseInMainOfficeType", CommandType.StoredProcedure, parametersMainOfficeType))
{
//check if any record exists or not
if (table.Rows.Count > 0)
{
//Lets go ahead and create the list of department
listDepartment = new List <Department>();
//Now lets populate the Department details into the list of departments
foreach (DataRow row in table.Rows)
{
Department department = ConvertRowToDepartment(row);
listDepartment.Add(department);
}
}
}
return(listDepartment);
}
public List <DepartmentMonthlyInformation> GetListDepartmentMonthlyInformation(int adjutancyTypeID)
{
List <DepartmentMonthlyInformation> listDepartmentMonthlyInformation = new List <DepartmentMonthlyInformation>()
{
};
SqlParameter[] parametersAdjutancyType = new SqlParameter[]
{
new SqlParameter("@AdjutancyTypeID", adjutancyTypeID)
};
//Lets get the list of DepartmentMonthlyInformation records from database
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("AdjutancyType_GetList_DepartmentMonthlyInformation", CommandType.StoredProcedure, parametersAdjutancyType))
{
//check if any record exists or not
if (table.Rows.Count > 0)
{
//Lets go ahead and create the list of DepartmentMonthlyInformation
listDepartmentMonthlyInformation = new List <DepartmentMonthlyInformation>();
//Now lets populate the DepartmentMonthlyInformation details into the list of DepartmentMonthlyInformations
foreach (DataRow row in table.Rows)
{
DepartmentMonthlyInformation departmentMonthlyInformation = departmentMonthlyInformationDBAccess.GetDetails(Convert.ToInt32(row["YearTypeID"]), Convert.ToInt32(row["MonthTypeID"]), Convert.ToInt32(row["DepartmentID"]));
listDepartmentMonthlyInformation.Add(departmentMonthlyInformation);
}
}
}
return(listDepartmentMonthlyInformation);
}
public List <EmployeeUserType> SearchLike(EmployeeUserType employeeUserType)
{
List <EmployeeUserType> listEmployeeUserType = new List <EmployeeUserType>();
SqlParameter[] parametersEmployeeUserType = new SqlParameter[]
{
new SqlParameter("@UserTypeID", employeeUserType.UserTypeID),
new SqlParameter("@NationalCode", employeeUserType.NationalCode),
new SqlParameter("@EmployeeFullName", employeeUserType.EmployeeFullName),
new SqlParameter("@UserTypeIDTitle", employeeUserType.UserTypeIDTitle),
};
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("EmployeeUserType_SearchLike", CommandType.StoredProcedure, parametersEmployeeUserType))
{
if (table.Rows.Count > 0)
{
foreach (DataRow row in table.Rows)
{
EmployeeUserType tmpEmployeeUserType = new EmployeeUserType();
tmpEmployeeUserType.UserTypeID = (row["UserTypeID"] != DBNull.Value) ? Convert.ToInt32(row["UserTypeID"]) : 0;
tmpEmployeeUserType.NationalCode = (row["NationalCode"] != DBNull.Value) ? Convert.ToInt64(row["NationalCode"]) : 0;
tmpEmployeeUserType.EmployeeFullName = row["EmployeeFullName"].ToString();
tmpEmployeeUserType.UserTypeIDTitle = row["UserTypeIDTitle"].ToString();
listEmployeeUserType.Add(tmpEmployeeUserType);
}
}
}
return(listEmployeeUserType);
}
public List <EmployeeUserType> GetListEmployeeUserType(Int64 nationalCode)
{
List <EmployeeUserType> listEmployeeUserType = new List <EmployeeUserType>()
{
};
SqlParameter[] parametersEmployee = new SqlParameter[]
{
new SqlParameter("@NationalCode", nationalCode)
};
//Lets get the list of EmployeeUserType records from database
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("EmployeeUserType_GetList_UseInEmployee", CommandType.StoredProcedure, parametersEmployee))
{
//check if any record exists or not
if (table.Rows.Count > 0)
{
//Lets go ahead and create the list of employeeUserType
listEmployeeUserType = new List <EmployeeUserType>();
//Now lets populate the EmployeeUserType details into the list of employeeUserTypes
foreach (DataRow row in table.Rows)
{
EmployeeUserType employeeUserType = ConvertRowToEmployeeUserType(row);
listEmployeeUserType.Add(employeeUserType);
}
}
}
return(listEmployeeUserType);
}
public List <MainOfficeType> SearchLike(MainOfficeType mainOfficeType)
{
List <MainOfficeType> listMainOfficeType = new List <MainOfficeType>();
SqlParameter[] parametersMainOfficeType = new SqlParameter[]
{
new SqlParameter("@MainOfficeTypeID", mainOfficeType.MainOfficeTypeID),
new SqlParameter("@ContractualEmployeesNumber", mainOfficeType.ContractualEmployeesNumber),
new SqlParameter("@Title", mainOfficeType.Title),
new SqlParameter("@TotalScore", mainOfficeType.TotalScore),
new SqlParameter("@TotalScoreCat1", mainOfficeType.TotalScoreCat1),
new SqlParameter("@TotalScoreCat2", mainOfficeType.TotalScoreCat2),
};
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("MainOfficeType_SearchLike", CommandType.StoredProcedure, parametersMainOfficeType))
{
if (table.Rows.Count > 0)
{
foreach (DataRow row in table.Rows)
{
MainOfficeType tmpMainOfficeType = new MainOfficeType();
tmpMainOfficeType.MainOfficeTypeID = (row["MainOfficeTypeID"] != DBNull.Value) ? Convert.ToInt32(row["MainOfficeTypeID"]) : 0;
tmpMainOfficeType.ContractualEmployeesNumber = (row["ContractualEmployeesNumber"] != DBNull.Value) ? Convert.ToInt64(row["ContractualEmployeesNumber"]) : 0;
tmpMainOfficeType.Title = row["Title"].ToString();
tmpMainOfficeType.TotalScore = (row["TotalScore"] != DBNull.Value) ? Convert.ToDecimal(row["TotalScore"]) : 0;
tmpMainOfficeType.TotalScoreCat1 = (row["TotalScoreCat1"] != DBNull.Value) ? Convert.ToDecimal(row["TotalScoreCat1"]) : 0;
tmpMainOfficeType.TotalScoreCat2 = (row["TotalScoreCat2"] != DBNull.Value) ? Convert.ToDecimal(row["TotalScoreCat2"]) : 0;
listMainOfficeType.Add(tmpMainOfficeType);
}
}
}
return(listMainOfficeType);
}
public List <ContractualEmployeeReward> GetListContractualEmployeeReward(int mainOfficeTypeID)
{
List <ContractualEmployeeReward> listContractualEmployeeReward = new List <ContractualEmployeeReward>()
{
};
SqlParameter[] parametersMainOfficeType = new SqlParameter[]
{
new SqlParameter("@MainOfficeTypeID", mainOfficeTypeID)
};
//Lets get the list of ContractualEmployeeReward records from database
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("MainOfficeType_GetList_ContractualEmployeeReward", CommandType.StoredProcedure, parametersMainOfficeType))
{
//check if any record exists or not
if (table.Rows.Count > 0)
{
//Lets go ahead and create the list of ContractualEmployeeReward
listContractualEmployeeReward = new List <ContractualEmployeeReward>();
//Now lets populate the ContractualEmployeeReward details into the list of ContractualEmployeeRewards
foreach (DataRow row in table.Rows)
{
ContractualEmployeeReward contractualEmployeeReward = contractualEmployeeRewardDBAccess.GetDetails(Convert.ToInt32(row["YearTypeID"]), Convert.ToInt32(row["MonthTypeID"]), Convert.ToInt64(row["NationalCode"]));
listContractualEmployeeReward.Add(contractualEmployeeReward);
}
}
}
return(listContractualEmployeeReward);
}
public Employee GetDetails(Int64 nationalCode)
{
Employee employee = new Employee();
SqlParameter[] parametersEmployee = new SqlParameter[]
{
new SqlParameter("@NationalCode", nationalCode)
};
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("Employee_GetDetails", CommandType.StoredProcedure, parametersEmployee))
{
if (table.Rows.Count == 1)
{
DataRow row = table.Rows[0];
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;
}
}
return(employee);
}
public List <OfficialEmployeeReward> GetListOfficialEmployeeReward(Int64 nationalCode)
{
List <OfficialEmployeeReward> listOfficialEmployeeReward = new List <OfficialEmployeeReward>()
{
};
SqlParameter[] parametersEmployee = new SqlParameter[]
{
new SqlParameter("@NationalCode", nationalCode)
};
//Lets get the list of OfficialEmployeeReward records from database
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("OfficialEmployeeReward_GetList_UseInEmployee", CommandType.StoredProcedure, parametersEmployee))
{
//check if any record exists or not
if (table.Rows.Count > 0)
{
//Lets go ahead and create the list of officialEmployeeReward
listOfficialEmployeeReward = new List <OfficialEmployeeReward>();
//Now lets populate the OfficialEmployeeReward details into the list of officialEmployeeRewards
foreach (DataRow row in table.Rows)
{
OfficialEmployeeReward officialEmployeeReward = ConvertRowToOfficialEmployeeReward(row);
listOfficialEmployeeReward.Add(officialEmployeeReward);
}
}
}
return(listOfficialEmployeeReward);
}
public List <ActivityType> SearchLike(ActivityType activityType)
{
List <ActivityType> listActivityType = new List <ActivityType>();
SqlParameter[] parametersActivityType = new SqlParameter[]
{
new SqlParameter("@ActivityTypeID", activityType.ActivityTypeID),
new SqlParameter("@Title", activityType.Title),
};
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("ActivityType_SearchLike", CommandType.StoredProcedure, parametersActivityType))
{
if (table.Rows.Count > 0)
{
foreach (DataRow row in table.Rows)
{
ActivityType tmpActivityType = new ActivityType();
tmpActivityType.ActivityTypeID = (row["ActivityTypeID"] != DBNull.Value) ? Convert.ToInt32(row["ActivityTypeID"]) : 0;
tmpActivityType.Title = row["Title"].ToString();
listActivityType.Add(tmpActivityType);
}
}
}
return(listActivityType);
}
public List <ActivityUserType> GetListActivityUserType(int activityTypeID)
{
List <ActivityUserType> listActivityUserType = new List <ActivityUserType>()
{
};
SqlParameter[] parametersActivityType = new SqlParameter[]
{
new SqlParameter("@ActivityTypeID", activityTypeID)
};
//Lets get the list of ActivityUserType records from database
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("ActivityUserType_GetList_UseInActivityType", CommandType.StoredProcedure, parametersActivityType))
{
//check if any record exists or not
if (table.Rows.Count > 0)
{
//Lets go ahead and create the list of activityUserType
listActivityUserType = new List <ActivityUserType>();
//Now lets populate the ActivityUserType details into the list of activityUserTypes
foreach (DataRow row in table.Rows)
{
ActivityUserType activityUserType = ConvertRowToActivityUserType(row);
listActivityUserType.Add(activityUserType);
}
}
}
return(listActivityUserType);
}
public BaseMonthlyInformation GetDetails(int yearTypeID, int monthTypeID, int mainOfficeTypeID)
{
BaseMonthlyInformation baseMonthlyInformation = new BaseMonthlyInformation();
SqlParameter[] parametersBaseMonthlyInformation = new SqlParameter[]
{
new SqlParameter("@YearTypeID", yearTypeID),
new SqlParameter("@MonthTypeID", monthTypeID),
new SqlParameter("@MainOfficeTypeID", mainOfficeTypeID)
};
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("BaseMonthlyInformation_GetDetails", CommandType.StoredProcedure, parametersBaseMonthlyInformation))
{
if (table.Rows.Count == 1)
{
DataRow row = table.Rows[0];
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;
}
}
return(baseMonthlyInformation);
}
public List <ContractualEmployeeReward> SearchLike(ContractualEmployeeReward contractualEmployeeReward)
{
List <ContractualEmployeeReward> listContractualEmployeeReward = new List <ContractualEmployeeReward>();
SqlParameter[] parametersContractualEmployeeReward = new SqlParameter[]
{
new SqlParameter("@YearTypeID", contractualEmployeeReward.YearTypeID),
new SqlParameter("@MonthTypeID", contractualEmployeeReward.MonthTypeID),
new SqlParameter("@NationalCode", contractualEmployeeReward.NationalCode),
new SqlParameter("@TotalReward", contractualEmployeeReward.TotalReward),
new SqlParameter("@Reward_", contractualEmployeeReward.Reward_),
new SqlParameter("@EmployeeFullName", contractualEmployeeReward.EmployeeFullName),
new SqlParameter("@DepartmentIDTitle", contractualEmployeeReward.DepartmentIDTitle),
new SqlParameter("@YearTypeIDTitle", contractualEmployeeReward.YearTypeIDTitle),
new SqlParameter("@MonthTypeIDTitle", contractualEmployeeReward.MonthTypeIDTitle),
new SqlParameter("@Reward", contractualEmployeeReward.Reward),
new SqlParameter("@BossFinalValue", contractualEmployeeReward.BossFinalValue),
new SqlParameter("@AssistantFinalValue", contractualEmployeeReward.AssistantFinalValue),
new SqlParameter("@ManagerFinalValue", contractualEmployeeReward.ManagerFinalValue),
new SqlParameter("@ExtraReward1", contractualEmployeeReward.ExtraReward1),
new SqlParameter("@ExtraReward2", contractualEmployeeReward.ExtraReward2),
new SqlParameter("@ExtraReward3", contractualEmployeeReward.ExtraReward3),
};
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("ContractualEmployeeReward_SearchLike", CommandType.StoredProcedure, parametersContractualEmployeeReward))
{
if (table.Rows.Count > 0)
{
foreach (DataRow row in table.Rows)
{
ContractualEmployeeReward tmpContractualEmployeeReward = new ContractualEmployeeReward();
tmpContractualEmployeeReward.YearTypeID = (row["YearTypeID"] != DBNull.Value) ? Convert.ToInt32(row["YearTypeID"]) : 0;
tmpContractualEmployeeReward.MonthTypeID = (row["MonthTypeID"] != DBNull.Value) ? Convert.ToInt32(row["MonthTypeID"]) : 0;
tmpContractualEmployeeReward.NationalCode = (row["NationalCode"] != DBNull.Value) ? Convert.ToInt64(row["NationalCode"]) : 0;
tmpContractualEmployeeReward.TotalReward = (row["TotalReward"] != DBNull.Value) ? Convert.ToInt64(row["TotalReward"]) : 0;
tmpContractualEmployeeReward.Reward_ = (row["Reward_"] != DBNull.Value) ? Convert.ToInt64(row["Reward_"]) : 0;
tmpContractualEmployeeReward.EmployeeFullName = row["EmployeeFullName"].ToString();
tmpContractualEmployeeReward.DepartmentIDTitle = row["DepartmentIDTitle"].ToString();
tmpContractualEmployeeReward.YearTypeIDTitle = row["YearTypeIDTitle"].ToString();
tmpContractualEmployeeReward.MonthTypeIDTitle = row["MonthTypeIDTitle"].ToString();
tmpContractualEmployeeReward.Reward = (row["Reward"] != DBNull.Value) ? Convert.ToInt64(row["Reward"]) : 0;
tmpContractualEmployeeReward.BossFinalValue = (row["BossFinalValue"] != DBNull.Value) ? Convert.ToInt64(row["BossFinalValue"]) : 0;
tmpContractualEmployeeReward.AssistantFinalValue = (row["AssistantFinalValue"] != DBNull.Value) ? Convert.ToInt64(row["AssistantFinalValue"]) : 0;
tmpContractualEmployeeReward.ManagerFinalValue = (row["ManagerFinalValue"] != DBNull.Value) ? Convert.ToInt64(row["ManagerFinalValue"]) : 0;
tmpContractualEmployeeReward.ExtraReward1 = (row["ExtraReward1"] != DBNull.Value) ? Convert.ToInt64(row["ExtraReward1"]) : 0;
tmpContractualEmployeeReward.ExtraReward2 = (row["ExtraReward2"] != DBNull.Value) ? Convert.ToInt64(row["ExtraReward2"]) : 0;
tmpContractualEmployeeReward.ExtraReward3 = (row["ExtraReward3"] != DBNull.Value) ? Convert.ToInt64(row["ExtraReward3"]) : 0;
listContractualEmployeeReward.Add(tmpContractualEmployeeReward);
}
}
}
return(listContractualEmployeeReward);
}
public List <Employee> SearchLike(Employee employee)
{
List <Employee> listEmployee = new List <Employee>();
SqlParameter[] parametersEmployee = new SqlParameter[]
{
new SqlParameter("@NationalCode", employee.NationalCode),
new SqlParameter("@ContractTypeIDTitle", employee.ContractTypeIDTitle),
new SqlParameter("@RoleTypeIDTitle", employee.RoleTypeIDTitle),
new SqlParameter("@FullName", employee.FullName),
new SqlParameter("@DepartmentIDTitle", employee.DepartmentIDTitle),
new SqlParameter("@RoleTypeIDFactor", employee.RoleTypeIDFactor),
new SqlParameter("@PersonalCode", employee.PersonalCode),
new SqlParameter("@FirstName", employee.FirstName),
new SqlParameter("@LastName", employee.LastName),
new SqlParameter("@AccountNumber", employee.AccountNumber),
new SqlParameter("@ContractTypeID", employee.ContractTypeID),
new SqlParameter("@RoleTypeID", employee.RoleTypeID),
new SqlParameter("@DepartmentID", employee.DepartmentID),
new SqlParameter("@IsActiveEmployee", employee.IsActiveEmployee),
};
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("Employee_SearchLike", CommandType.StoredProcedure, parametersEmployee))
{
if (table.Rows.Count > 0)
{
foreach (DataRow row in table.Rows)
{
Employee tmpEmployee = new Employee();
tmpEmployee.NationalCode = (row["NationalCode"] != DBNull.Value) ? Convert.ToInt64(row["NationalCode"]) : 0;
tmpEmployee.ContractTypeIDTitle = row["ContractTypeIDTitle"].ToString();
tmpEmployee.RoleTypeIDTitle = row["RoleTypeIDTitle"].ToString();
tmpEmployee.FullName = row["FullName"].ToString();
tmpEmployee.DepartmentIDTitle = row["DepartmentIDTitle"].ToString();
tmpEmployee.RoleTypeIDFactor = (row["RoleTypeIDFactor"] != DBNull.Value) ? Convert.ToDecimal(row["RoleTypeIDFactor"]) : 0;
tmpEmployee.PersonalCode = row["PersonalCode"].ToString();
tmpEmployee.FirstName = row["FirstName"].ToString();
tmpEmployee.LastName = row["LastName"].ToString();
tmpEmployee.AccountNumber = row["AccountNumber"].ToString();
tmpEmployee.ContractTypeID = (row["ContractTypeID"] != DBNull.Value) ? Convert.ToInt32(row["ContractTypeID"]) : 0;
tmpEmployee.RoleTypeID = (row["RoleTypeID"] != DBNull.Value) ? Convert.ToInt32(row["RoleTypeID"]) : 0;
tmpEmployee.DepartmentID = (row["DepartmentID"] != DBNull.Value) ? Convert.ToInt32(row["DepartmentID"]) : 0;
tmpEmployee.IsActiveEmployee = (row["IsActiveEmployee"] != DBNull.Value) ? Convert.ToBoolean((row["IsActiveEmployee"].ToString() == "1" || row["IsActiveEmployee"].ToString().ToLower() == "true") ? true : false) : false;
listEmployee.Add(tmpEmployee);
}
}
}
return(listEmployee);
}
public List <Department> SearchLike(Department department)
{
List <Department> listDepartment = new List <Department>();
SqlParameter[] parametersDepartment = new SqlParameter[]
{
new SqlParameter("@DepartmentID", department.DepartmentID),
new SqlParameter("@DividerFullName", department.DividerFullName),
new SqlParameter("@ComputationTypeIDTitle", department.ComputationTypeIDTitle),
new SqlParameter("@MainOfficeTypeIDTitle", department.MainOfficeTypeIDTitle),
new SqlParameter("@AdjutancyTypeIDTitle", department.AdjutancyTypeIDTitle),
new SqlParameter("@ComputationTypeID", department.ComputationTypeID),
new SqlParameter("@MainOfficeTypeID", department.MainOfficeTypeID),
new SqlParameter("@AdjutancyTypeID", department.AdjutancyTypeID),
new SqlParameter("@TotalEmployeeNumber", department.TotalEmployeeNumber),
new SqlParameter("@TotalContractualEmployeeNumber", department.TotalContractualEmployeeNumber),
new SqlParameter("@TotalPersonalScore", department.TotalPersonalScore),
new SqlParameter("@DividerNationalCode", department.DividerNationalCode),
new SqlParameter("@Title", department.Title),
};
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("Department_SearchLike", CommandType.StoredProcedure, parametersDepartment))
{
if (table.Rows.Count > 0)
{
foreach (DataRow row in table.Rows)
{
Department tmpDepartment = new Department();
tmpDepartment.DepartmentID = (row["DepartmentID"] != DBNull.Value) ? Convert.ToInt32(row["DepartmentID"]) : 0;
tmpDepartment.DividerFullName = row["DividerFullName"].ToString();
tmpDepartment.ComputationTypeIDTitle = row["ComputationTypeIDTitle"].ToString();
tmpDepartment.MainOfficeTypeIDTitle = row["MainOfficeTypeIDTitle"].ToString();
tmpDepartment.AdjutancyTypeIDTitle = row["AdjutancyTypeIDTitle"].ToString();
tmpDepartment.ComputationTypeID = (row["ComputationTypeID"] != DBNull.Value) ? Convert.ToInt32(row["ComputationTypeID"]) : 0;
tmpDepartment.MainOfficeTypeID = (row["MainOfficeTypeID"] != DBNull.Value) ? Convert.ToInt32(row["MainOfficeTypeID"]) : 0;
tmpDepartment.AdjutancyTypeID = (row["AdjutancyTypeID"] != DBNull.Value) ? Convert.ToInt32(row["AdjutancyTypeID"]) : 0;
tmpDepartment.TotalEmployeeNumber = (row["TotalEmployeeNumber"] != DBNull.Value) ? Convert.ToInt32(row["TotalEmployeeNumber"]) : 0;
tmpDepartment.TotalContractualEmployeeNumber = (row["TotalContractualEmployeeNumber"] != DBNull.Value) ? Convert.ToInt32(row["TotalContractualEmployeeNumber"]) : 0;
tmpDepartment.TotalPersonalScore = (row["TotalPersonalScore"] != DBNull.Value) ? Convert.ToDecimal(row["TotalPersonalScore"]) : 0;
tmpDepartment.DividerNationalCode = (row["DividerNationalCode"] != DBNull.Value) ? Convert.ToInt64(row["DividerNationalCode"]) : 0;
tmpDepartment.Title = row["Title"].ToString();
listDepartment.Add(tmpDepartment);
}
}
}
return(listDepartment);
}
public OfficialEmployeeReward GetDetails(Int64 nationalCode, int yearTypeID, int monthTypeID)
{
OfficialEmployeeReward officialEmployeeReward = new OfficialEmployeeReward();
SqlParameter[] parametersOfficialEmployeeReward = new SqlParameter[]
{
new SqlParameter("@NationalCode", nationalCode),
new SqlParameter("@YearTypeID", yearTypeID),
new SqlParameter("@MonthTypeID", monthTypeID)
};
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("OfficialEmployeeReward_GetDetails", CommandType.StoredProcedure, parametersOfficialEmployeeReward))
{
if (table.Rows.Count == 1)
{
DataRow row = table.Rows[0];
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;
}
}
return(officialEmployeeReward);
}
public YearType GetDetails(int yearTypeID)
{
YearType yearType = new YearType();
SqlParameter[] parametersYearType = new SqlParameter[]
{
new SqlParameter("@YearTypeID", yearTypeID)
};
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("YearType_GetDetails", CommandType.StoredProcedure, parametersYearType))
{
if (table.Rows.Count == 1)
{
DataRow row = table.Rows[0];
yearType.YearTypeID = (row["YearTypeID"] != DBNull.Value) ? Convert.ToInt32(row["YearTypeID"]) : 0;
yearType.Title = row["Title"].ToString();
}
}
return(yearType);
}
public ComputationType GetDetails(int computationTypeID)
{
ComputationType computationType = new ComputationType();
SqlParameter[] parametersComputationType = new SqlParameter[]
{
new SqlParameter("@ComputationTypeID", computationTypeID)
};
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("ComputationType_GetDetails", CommandType.StoredProcedure, parametersComputationType))
{
if (table.Rows.Count == 1)
{
DataRow row = table.Rows[0];
computationType.ComputationTypeID = (row["ComputationTypeID"] != DBNull.Value) ? Convert.ToInt32(row["ComputationTypeID"]) : 0;
computationType.Title = row["Title"].ToString();
}
}
return(computationType);
}
public ActivityType GetDetails(int activityTypeID)
{
ActivityType activityType = new ActivityType();
SqlParameter[] parametersActivityType = new SqlParameter[]
{
new SqlParameter("@ActivityTypeID", activityTypeID)
};
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("ActivityType_GetDetails", CommandType.StoredProcedure, parametersActivityType))
{
if (table.Rows.Count == 1)
{
DataRow row = table.Rows[0];
activityType.ActivityTypeID = (row["ActivityTypeID"] != DBNull.Value) ? Convert.ToInt32(row["ActivityTypeID"]) : 0;
activityType.Title = row["Title"].ToString();
}
}
return(activityType);
}
public RoleType GetDetails(int roleTypeID)
{
RoleType roleType = new RoleType();
SqlParameter[] parametersRoleType = new SqlParameter[]
{
new SqlParameter("@RoleTypeID", roleTypeID)
};
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("RoleType_GetDetails", CommandType.StoredProcedure, parametersRoleType))
{
if (table.Rows.Count == 1)
{
DataRow row = table.Rows[0];
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();
}
}
return(roleType);
}
public User GetDetails(Int64 nationalCode)
{
User user = new User();
SqlParameter[] parametersUser = new SqlParameter[]
{
new SqlParameter("@NationalCode", nationalCode)
};
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("User_GetDetails", CommandType.StoredProcedure, parametersUser))
{
if (table.Rows.Count == 1)
{
DataRow row = table.Rows[0];
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.NationalCode = employee.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;
}
}
return(user);
}
public AdjutancyType GetDetails(int adjutancyTypeID)
{
AdjutancyType adjutancyType = new AdjutancyType();
SqlParameter[] parametersAdjutancyType = new SqlParameter[]
{
new SqlParameter("@AdjutancyTypeID", adjutancyTypeID)
};
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("AdjutancyType_GetDetails", CommandType.StoredProcedure, parametersAdjutancyType))
{
if (table.Rows.Count == 1)
{
DataRow row = table.Rows[0];
adjutancyType.AdjutancyTypeID = (row["AdjutancyTypeID"] != DBNull.Value) ? Convert.ToInt32(row["AdjutancyTypeID"]) : 0;
adjutancyType.AdjutantFullName = row["AdjutantFullName"].ToString();
adjutancyType.AdjutantNationalCode = (row["AdjutantNationalCode"] != DBNull.Value) ? Convert.ToInt64(row["AdjutantNationalCode"]) : 0;
adjutancyType.Title = row["Title"].ToString();
}
}
return(adjutancyType);
}
public EmployeeUserType GetDetails(int userTypeID, Int64 nationalCode)
{
EmployeeUserType employeeUserType = new EmployeeUserType();
SqlParameter[] parametersEmployeeUserType = new SqlParameter[]
{
new SqlParameter("@UserTypeID", userTypeID),
new SqlParameter("@NationalCode", nationalCode)
};
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("EmployeeUserType_GetDetails", CommandType.StoredProcedure, parametersEmployeeUserType))
{
if (table.Rows.Count == 1)
{
DataRow row = table.Rows[0];
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();
}
}
return(employeeUserType);
}
public List <User> SearchLike(User user)
{
List <User> listUser = new List <User>();
SqlParameter[] parametersUser = new SqlParameter[]
{
new SqlParameter("@NationalCode", user.NationalCode),
new SqlParameter("@Password", user.Password),
new SqlParameter("@LastPassChangeDate", user.LastPassChangeDate),
new SqlParameter("@IsActiveUser", user.IsActiveUser),
new SqlParameter("@ContractTypeIDTitle", user.ContractTypeIDTitle),
new SqlParameter("@RoleTypeIDTitle", user.RoleTypeIDTitle),
new SqlParameter("@FullName", user.FullName),
new SqlParameter("@DepartmentIDTitle", user.DepartmentIDTitle),
new SqlParameter("@RoleTypeIDFactor", user.RoleTypeIDFactor),
new SqlParameter("@PersonalCode", user.PersonalCode),
new SqlParameter("@FirstName", user.FirstName),
new SqlParameter("@LastName", user.LastName),
new SqlParameter("@AccountNumber", user.AccountNumber),
new SqlParameter("@ContractTypeID", user.ContractTypeID),
new SqlParameter("@RoleTypeID", user.RoleTypeID),
new SqlParameter("@DepartmentID", user.DepartmentID),
new SqlParameter("@IsActiveEmployee", user.IsActiveEmployee)
};
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("User_SearchLike", CommandType.StoredProcedure, parametersUser))
{
if (table.Rows.Count > 0)
{
foreach (DataRow row in table.Rows)
{
User tmpUser = new User();
tmpUser.NationalCode = (row["NationalCode"] != DBNull.Value) ? Convert.ToInt64(row["NationalCode"]) : 0;
tmpUser.Password = row["Password"].ToString();
tmpUser.LastPassChangeDate = row["LastPassChangeDate"].ToString();
tmpUser.IsActiveUser = (row["IsActiveUser"] != DBNull.Value) ? Convert.ToBoolean((row["IsActiveUser"].ToString() == "1" || row["IsActiveUser"].ToString().ToLower() == "true") ? true : false) : false;
Employee employee = employeeDBAccess.GetDetails(tmpUser.NationalCode);
tmpUser.NationalCode = employee.NationalCode;
tmpUser.ContractTypeIDTitle = employee.ContractTypeIDTitle;
tmpUser.RoleTypeIDTitle = employee.RoleTypeIDTitle;
tmpUser.FullName = employee.FullName;
tmpUser.DepartmentIDTitle = employee.DepartmentIDTitle;
tmpUser.RoleTypeIDFactor = employee.RoleTypeIDFactor;
tmpUser.PersonalCode = employee.PersonalCode;
tmpUser.FirstName = employee.FirstName;
tmpUser.LastName = employee.LastName;
tmpUser.AccountNumber = employee.AccountNumber;
tmpUser.ContractTypeID = employee.ContractTypeID;
tmpUser.RoleTypeID = employee.RoleTypeID;
tmpUser.DepartmentID = employee.DepartmentID;
tmpUser.IsActiveEmployee = employee.IsActiveEmployee;
listUser.Add(tmpUser);
}
}
}
return(listUser);
}
