public Int64 Insert(BaseMonthlyInformation baseMonthlyInformation) { SqlParameter[] parametersBaseMonthlyInformation = new SqlParameter[] { new SqlParameter("@YearTypeID", (baseMonthlyInformation.YearTypeID > 0) ? baseMonthlyInformation.YearTypeID : (object)DBNull.Value), new SqlParameter("@MonthTypeID", (baseMonthlyInformation.MonthTypeID > 0) ? baseMonthlyInformation.MonthTypeID : (object)DBNull.Value), new SqlParameter("@MainOfficeTypeID", (baseMonthlyInformation.MainOfficeTypeID > 0) ? baseMonthlyInformation.MainOfficeTypeID : (object)DBNull.Value), new SqlParameter("@ContractualReward", (baseMonthlyInformation.ContractualReward != null) ? baseMonthlyInformation.ContractualReward : (object)DBNull.Value), new SqlParameter("@ContractualConstantReward", (baseMonthlyInformation.ContractualConstantReward != null) ? baseMonthlyInformation.ContractualConstantReward : (object)DBNull.Value), new SqlParameter("@ExtraReward", (baseMonthlyInformation.ExtraReward != null) ? baseMonthlyInformation.ExtraReward : (object)DBNull.Value), new SqlParameter("@Factor5", baseMonthlyInformation.Factor5), new SqlParameter("@Factor6", baseMonthlyInformation.Factor6), new SqlParameter("@Factor7", baseMonthlyInformation.Factor7), new SqlParameter("@Factor8", baseMonthlyInformation.Factor8), new SqlParameter("@Factor9", baseMonthlyInformation.Factor9), new SqlParameter("@Factor10", baseMonthlyInformation.Factor10), new SqlParameter("@OfficialReward", (baseMonthlyInformation.OfficialReward != null) ? baseMonthlyInformation.OfficialReward : (object)DBNull.Value), new SqlParameter("@IsFanalized", (baseMonthlyInformation.IsFanalized != null) ? baseMonthlyInformation.IsFanalized : (object)DBNull.Value), new SqlParameter("@IsFainalizedEmployeesInformation", (baseMonthlyInformation.IsFainalizedEmployeesInformation != null) ? baseMonthlyInformation.IsFainalizedEmployeesInformation : (object)DBNull.Value), new SqlParameter("@IsFainalizedRewardCalculation", (baseMonthlyInformation.IsFainalizedRewardCalculation != null) ? baseMonthlyInformation.IsFainalizedRewardCalculation : (object)DBNull.Value), new SqlParameter("@BossFactor", baseMonthlyInformation.BossFactor), new SqlParameter("@OperationalFactor", baseMonthlyInformation.OperationalFactor), new SqlParameter("@Factor1", baseMonthlyInformation.Factor1), new SqlParameter("@Factor2", baseMonthlyInformation.Factor2), new SqlParameter("@Factor3", baseMonthlyInformation.Factor3), new SqlParameter("@Factor4", baseMonthlyInformation.Factor4) }; return(SqlDBHelper.ExecuteScalar("BaseMonthlyInformation_Insert", CommandType.StoredProcedure, parametersBaseMonthlyInformation)); }
public bool Exists(int adjutancyTypeID) { SqlParameter[] parametersAdjutancyType = new SqlParameter[] { new SqlParameter("@AdjutancyTypeID", adjutancyTypeID) }; return(SqlDBHelper.ExecuteScalar("AdjutancyType_Exists", CommandType.StoredProcedure, parametersAdjutancyType) > 0); }
public bool Exists(User user) { SqlParameter[] parametersUser = new SqlParameter[] { new SqlParameter("@NationalCode", user.NationalCode) }; return(SqlDBHelper.ExecuteScalar("User_Exists", CommandType.StoredProcedure, parametersUser) > 0); }
public bool Exists(YearType yearType) { SqlParameter[] parametersYearType = new SqlParameter[] { new SqlParameter("@YearTypeID", yearType.YearTypeID) }; return(SqlDBHelper.ExecuteScalar("YearType_Exists", CommandType.StoredProcedure, parametersYearType) > 0); }
public bool Exists(UserType userType) { SqlParameter[] parametersUserType = new SqlParameter[] { new SqlParameter("@UserTypeID", userType.UserTypeID) }; return(SqlDBHelper.ExecuteScalar("UserType_Exists", CommandType.StoredProcedure, parametersUserType) > 0); }
public bool Exists(int monthTypeID) { SqlParameter[] parametersMonthType = new SqlParameter[] { new SqlParameter("@MonthTypeID", monthTypeID) }; return(SqlDBHelper.ExecuteScalar("MonthType_Exists", CommandType.StoredProcedure, parametersMonthType) > 0); }
public bool Exists(Employee employee) { SqlParameter[] parametersEmployee = new SqlParameter[] { new SqlParameter("@NationalCode", employee.NationalCode) }; return(SqlDBHelper.ExecuteScalar("Employee_Exists", CommandType.StoredProcedure, parametersEmployee) > 0); }
public bool Exists(ComputationType computationType) { SqlParameter[] parametersComputationType = new SqlParameter[] { new SqlParameter("@ComputationTypeID", computationType.ComputationTypeID) }; return(SqlDBHelper.ExecuteScalar("ComputationType_Exists", CommandType.StoredProcedure, parametersComputationType) > 0); }
public bool Exists(ActivityType activityType) { SqlParameter[] parametersActivityType = new SqlParameter[] { new SqlParameter("@ActivityTypeID", activityType.ActivityTypeID) }; return(SqlDBHelper.ExecuteScalar("ActivityType_Exists", CommandType.StoredProcedure, parametersActivityType) > 0); }
public bool Exists(RoleType roleType) { SqlParameter[] parametersRoleType = new SqlParameter[] { new SqlParameter("@RoleTypeID", roleType.RoleTypeID) }; return(SqlDBHelper.ExecuteScalar("RoleType_Exists", CommandType.StoredProcedure, parametersRoleType) > 0); }
public bool Exists(Department department) { SqlParameter[] parametersDepartment = new SqlParameter[] { new SqlParameter("@DepartmentID", department.DepartmentID) }; return(SqlDBHelper.ExecuteScalar("Department_Exists", CommandType.StoredProcedure, parametersDepartment) > 0); }
public bool Exists(MainOfficeType mainOfficeType) { SqlParameter[] parametersMainOfficeType = new SqlParameter[] { new SqlParameter("@MainOfficeTypeID", mainOfficeType.MainOfficeTypeID) }; return(SqlDBHelper.ExecuteScalar("MainOfficeType_Exists", CommandType.StoredProcedure, parametersMainOfficeType) > 0); }
public Int64 Insert(UserType userType) { SqlParameter[] parametersUserType = new SqlParameter[] { new SqlParameter("@Title", userType.Title) }; userType.UserTypeID = Convert.ToInt32(SqlDBHelper.ExecuteScalar("UserType_Insert", CommandType.StoredProcedure, parametersUserType)); return(userType.UserTypeID); }
public Int64 Insert(MonthType monthType) { SqlParameter[] parametersMonthType = new SqlParameter[] { new SqlParameter("@Title", (monthType.Title != null) ? monthType.Title : (object)DBNull.Value) }; monthType.MonthTypeID = Convert.ToInt32(SqlDBHelper.ExecuteScalar("MonthType_Insert", CommandType.StoredProcedure, parametersMonthType)); return(monthType.MonthTypeID); }
public Int64 Insert(ComputationType computationType) { SqlParameter[] parametersComputationType = new SqlParameter[] { new SqlParameter("@Title", computationType.Title) }; computationType.ComputationTypeID = Convert.ToInt32(SqlDBHelper.ExecuteScalar("ComputationType_Insert", CommandType.StoredProcedure, parametersComputationType)); return(computationType.ComputationTypeID); }
public bool Exists(int userTypeID, Int64 nationalCode) { SqlParameter[] parametersEmployeeUserType = new SqlParameter[] { new SqlParameter("@UserTypeID", userTypeID), new SqlParameter("@NationalCode", nationalCode) }; return(SqlDBHelper.ExecuteScalar("EmployeeUserType_Exists", CommandType.StoredProcedure, parametersEmployeeUserType) > 0); }
public Int64 Insert(EmployeeUserType employeeUserType) { SqlParameter[] parametersEmployeeUserType = new SqlParameter[] { new SqlParameter("@UserTypeID", (employeeUserType.UserTypeID > 0) ? employeeUserType.UserTypeID : (object)DBNull.Value), new SqlParameter("@NationalCode", (employeeUserType.NationalCode > 0) ? employeeUserType.NationalCode : (object)DBNull.Value) }; return(SqlDBHelper.ExecuteScalar("EmployeeUserType_Insert", CommandType.StoredProcedure, parametersEmployeeUserType)); }
public Int64 Insert(ActivityType activityType) { SqlParameter[] parametersActivityType = new SqlParameter[] { new SqlParameter("@Title", activityType.Title) }; activityType.ActivityTypeID = Convert.ToInt32(SqlDBHelper.ExecuteScalar("ActivityType_Insert", CommandType.StoredProcedure, parametersActivityType)); return(activityType.ActivityTypeID); }
public Int64 Insert(ActivityUserType activityUserType) { SqlParameter[] parametersActivityUserType = new SqlParameter[] { new SqlParameter("@ActivityTypeID", (activityUserType.ActivityTypeID > 0) ? activityUserType.ActivityTypeID : (object)DBNull.Value), new SqlParameter("@UserTypeID", (activityUserType.UserTypeID > 0) ? activityUserType.UserTypeID : (object)DBNull.Value) }; return(SqlDBHelper.ExecuteScalar("ActivityUserType_Insert", CommandType.StoredProcedure, parametersActivityUserType)); }
public Int64 Insert(YearType yearType) { SqlParameter[] parametersYearType = new SqlParameter[] { new SqlParameter("@YearTypeID", yearType.YearTypeID), new SqlParameter("@Title", yearType.Title) }; return(SqlDBHelper.ExecuteScalar("YearType_Insert", CommandType.StoredProcedure, parametersYearType)); }
public bool Exists(BaseMonthlyInformation baseMonthlyInformation) { SqlParameter[] parametersBaseMonthlyInformation = new SqlParameter[] { new SqlParameter("@YearTypeID", baseMonthlyInformation.YearTypeID), new SqlParameter("@MonthTypeID", baseMonthlyInformation.MonthTypeID), new SqlParameter("@MainOfficeTypeID", baseMonthlyInformation.MainOfficeTypeID) }; return(SqlDBHelper.ExecuteScalar("BaseMonthlyInformation_Exists", CommandType.StoredProcedure, parametersBaseMonthlyInformation) > 0); }
public bool Exists(OfficialEmployeeReward officialEmployeeReward) { SqlParameter[] parametersOfficialEmployeeReward = new SqlParameter[] { new SqlParameter("@NationalCode", officialEmployeeReward.NationalCode), new SqlParameter("@YearTypeID", officialEmployeeReward.YearTypeID), new SqlParameter("@MonthTypeID", officialEmployeeReward.MonthTypeID) }; return(SqlDBHelper.ExecuteScalar("OfficialEmployeeReward_Exists", CommandType.StoredProcedure, parametersOfficialEmployeeReward) > 0); }
public bool Exists(int yearTypeID, int monthTypeID, Int64 nationalCode) { SqlParameter[] parametersContractualEmployeeReward = new SqlParameter[] { new SqlParameter("@YearTypeID", yearTypeID), new SqlParameter("@MonthTypeID", monthTypeID), new SqlParameter("@NationalCode", nationalCode) }; return(SqlDBHelper.ExecuteScalar("ContractualEmployeeReward_Exists", CommandType.StoredProcedure, parametersContractualEmployeeReward) > 0); }
public Int64 Insert(RoleType roleType) { SqlParameter[] parametersRoleType = new SqlParameter[] { new SqlParameter("@Factor", roleType.Factor), new SqlParameter("@Title", roleType.Title) }; roleType.RoleTypeID = Convert.ToInt32(SqlDBHelper.ExecuteScalar("RoleType_Insert", CommandType.StoredProcedure, parametersRoleType)); return(roleType.RoleTypeID); }
public Int64 Insert(AdjutancyType adjutancyType) { SqlParameter[] parametersAdjutancyType = new SqlParameter[] { new SqlParameter("@AdjutantNationalCode", (adjutancyType.AdjutantNationalCode != null) ? adjutancyType.AdjutantNationalCode : (object)DBNull.Value), new SqlParameter("@Title", (adjutancyType.Title != null) ? adjutancyType.Title : (object)DBNull.Value) }; adjutancyType.AdjutancyTypeID = Convert.ToInt32(SqlDBHelper.ExecuteScalar("AdjutancyType_Insert", CommandType.StoredProcedure, parametersAdjutancyType)); return(adjutancyType.AdjutancyTypeID); }
public Int64 Insert(MainOfficeType mainOfficeType) { SqlParameter[] parametersMainOfficeType = new SqlParameter[] { new SqlParameter("@Title", mainOfficeType.Title), new SqlParameter("@TotalScore", (mainOfficeType.TotalScore != null) ? mainOfficeType.TotalScore : (object)DBNull.Value), new SqlParameter("@TotalScoreCat1", (mainOfficeType.TotalScoreCat1 != null) ? mainOfficeType.TotalScoreCat1 : (object)DBNull.Value), new SqlParameter("@TotalScoreCat2", (mainOfficeType.TotalScoreCat2 != null) ? mainOfficeType.TotalScoreCat2 : (object)DBNull.Value) }; mainOfficeType.MainOfficeTypeID = Convert.ToInt32(SqlDBHelper.ExecuteScalar("MainOfficeType_Insert", CommandType.StoredProcedure, parametersMainOfficeType)); return(mainOfficeType.MainOfficeTypeID); }
public Int64 Insert(Department department) { SqlParameter[] parametersDepartment = new SqlParameter[] { new SqlParameter("@ComputationTypeID", (department.ComputationTypeID > 0) ? department.ComputationTypeID : (object)DBNull.Value), new SqlParameter("@MainOfficeTypeID", (department.MainOfficeTypeID > 0) ? department.MainOfficeTypeID : (object)DBNull.Value), new SqlParameter("@AdjutancyTypeID", (department.AdjutancyTypeID > 0) ? department.AdjutancyTypeID : (object)DBNull.Value), new SqlParameter("@TotalEmployeeNumber", (department.TotalEmployeeNumber != null) ? department.TotalEmployeeNumber : (object)DBNull.Value), new SqlParameter("@TotalContractualEmployeeNumber", (department.TotalContractualEmployeeNumber != null) ? department.TotalContractualEmployeeNumber : (object)DBNull.Value), new SqlParameter("@TotalPersonalScore", (department.TotalPersonalScore != null) ? department.TotalPersonalScore : (object)DBNull.Value), new SqlParameter("@DividerNationalCode", (department.DividerNationalCode != null) ? department.DividerNationalCode : (object)DBNull.Value), new SqlParameter("@Title", department.Title) }; department.DepartmentID = Convert.ToInt32(SqlDBHelper.ExecuteScalar("Department_Insert", CommandType.StoredProcedure, parametersDepartment)); return(department.DepartmentID); }
public Int64 Insert(Employee employee) { SqlParameter[] parametersEmployee = new SqlParameter[] { new SqlParameter("@NationalCode", employee.NationalCode), new SqlParameter("@PersonalCode", (employee.PersonalCode != null) ? employee.PersonalCode : (object)DBNull.Value), new SqlParameter("@FirstName", employee.FirstName), new SqlParameter("@LastName", employee.LastName), new SqlParameter("@AccountNumber", (employee.AccountNumber != null) ? employee.AccountNumber : (object)DBNull.Value), new SqlParameter("@ContractTypeID", (employee.ContractTypeID > 0) ? employee.ContractTypeID : (object)DBNull.Value), new SqlParameter("@RoleTypeID", (employee.RoleTypeID > 0) ? employee.RoleTypeID : (object)DBNull.Value), new SqlParameter("@DepartmentID", (employee.DepartmentID > 0) ? employee.DepartmentID : (object)DBNull.Value), new SqlParameter("@IsActiveEmployee", employee.IsActiveEmployee) }; return(SqlDBHelper.ExecuteScalar("Employee_Insert", CommandType.StoredProcedure, parametersEmployee)); }
public Int64 Insert(User user) { if (!employeeDBAccess.Exists(user)) { user.NationalCode = employeeDBAccess.Insert(user); } SqlParameter[] parametersUser = new SqlParameter[] { new SqlParameter("@NationalCode", (user.NationalCode > 0) ? user.NationalCode : (object)DBNull.Value), new SqlParameter("@Password", (user.Password != null) ? user.Password : (object)DBNull.Value), new SqlParameter("@LastPassChangeDate", (user.LastPassChangeDate != null) ? user.LastPassChangeDate : (object)DBNull.Value), new SqlParameter("@IsActiveUser", (user.IsActiveUser != null) ? user.IsActiveUser : (object)DBNull.Value) }; return(SqlDBHelper.ExecuteScalar("User_Insert", CommandType.StoredProcedure, parametersUser)); }
public Int64 Insert(ContractualEmployeeReward contractualEmployeeReward) { SqlParameter[] parametersContractualEmployeeReward = new SqlParameter[] { new SqlParameter("@YearTypeID", (contractualEmployeeReward.YearTypeID > 0) ? contractualEmployeeReward.YearTypeID : (object)DBNull.Value), new SqlParameter("@MonthTypeID", (contractualEmployeeReward.MonthTypeID > 0) ? contractualEmployeeReward.MonthTypeID : (object)DBNull.Value), new SqlParameter("@NationalCode", (contractualEmployeeReward.NationalCode > 0) ? contractualEmployeeReward.NationalCode : (object)DBNull.Value), 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) }; return(SqlDBHelper.ExecuteScalar("ContractualEmployeeReward_Insert", CommandType.StoredProcedure, parametersContractualEmployeeReward)); }