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