public bool Update(BaseMonthlyInformation baseMonthlyInformation)
{
SqlParameter[] parametersBaseMonthlyInformation = new SqlParameter[]
{
new SqlParameter("@YearTypeID", baseMonthlyInformation.YearTypeID),
new SqlParameter("@MonthTypeID", baseMonthlyInformation.MonthTypeID),
new SqlParameter("@MainOfficeTypeID", baseMonthlyInformation.MainOfficeTypeID),
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.ExecuteNonQuery("BaseMonthlyInformation_Update", CommandType.StoredProcedure, parametersBaseMonthlyInformation));
}
public bool Delete(int mainOfficeTypeID)
{
SqlParameter[] parametersMainOfficeType = new SqlParameter[]
{
new SqlParameter("@MainOfficeTypeID", mainOfficeTypeID)
};
return(SqlDBHelper.ExecuteNonQuery("MainOfficeType_Delete", CommandType.StoredProcedure, parametersMainOfficeType));
}
public bool Delete(int departmentID)
{
SqlParameter[] parametersDepartment = new SqlParameter[]
{
new SqlParameter("@DepartmentID", departmentID)
};
return(SqlDBHelper.ExecuteNonQuery("Department_Delete", CommandType.StoredProcedure, parametersDepartment));
}
public bool Delete(int activityTypeID)
{
SqlParameter[] parametersActivityType = new SqlParameter[]
{
new SqlParameter("@ActivityTypeID", activityTypeID)
};
return(SqlDBHelper.ExecuteNonQuery("ActivityType_Delete", CommandType.StoredProcedure, parametersActivityType));
}
public bool Delete(int computationTypeID)
{
SqlParameter[] parametersComputationType = new SqlParameter[]
{
new SqlParameter("@ComputationTypeID", computationTypeID)
};
return(SqlDBHelper.ExecuteNonQuery("ComputationType_Delete", CommandType.StoredProcedure, parametersComputationType));
}
public bool Delete(int yearTypeID)
{
SqlParameter[] parametersYearType = new SqlParameter[]
{
new SqlParameter("@YearTypeID", yearTypeID)
};
return(SqlDBHelper.ExecuteNonQuery("YearType_Delete", CommandType.StoredProcedure, parametersYearType));
}
public bool Delete(Int64 nationalCode)
{
SqlParameter[] parametersUser = new SqlParameter[]
{
new SqlParameter("@NationalCode", nationalCode)
};
return(SqlDBHelper.ExecuteNonQuery("User_Delete", CommandType.StoredProcedure, parametersUser));
}
public bool Delete(int userTypeID, Int64 nationalCode)
{
SqlParameter[] parametersEmployeeUserType = new SqlParameter[]
{
new SqlParameter("@UserTypeID", userTypeID),
new SqlParameter("@NationalCode", nationalCode)
};
return(SqlDBHelper.ExecuteNonQuery("EmployeeUserType_Delete", CommandType.StoredProcedure, parametersEmployeeUserType));
}
public bool Update(EmployeeUserType employeeUserType)
{
SqlParameter[] parametersEmployeeUserType = new SqlParameter[]
{
new SqlParameter("@UserTypeID", employeeUserType.UserTypeID),
new SqlParameter("@NationalCode", employeeUserType.NationalCode)
};
return(SqlDBHelper.ExecuteNonQuery("EmployeeUserType_Update", CommandType.StoredProcedure, parametersEmployeeUserType));
}
public bool Update(UserType userType)
{
SqlParameter[] parametersUserType = new SqlParameter[]
{
new SqlParameter("@UserTypeID", userType.UserTypeID),
new SqlParameter("@Title", userType.Title)
};
return(SqlDBHelper.ExecuteNonQuery("UserType_Update", CommandType.StoredProcedure, parametersUserType));
}
public bool Update(MonthType monthType)
{
SqlParameter[] parametersMonthType = new SqlParameter[]
{
new SqlParameter("@MonthTypeID", monthType.MonthTypeID),
new SqlParameter("@Title", (monthType.Title != null) ? monthType.Title : (object)DBNull.Value)
};
return(SqlDBHelper.ExecuteNonQuery("MonthType_Update", CommandType.StoredProcedure, parametersMonthType));
}
public bool Update(YearType yearType)
{
SqlParameter[] parametersYearType = new SqlParameter[]
{
new SqlParameter("@YearTypeID", yearType.YearTypeID),
new SqlParameter("@Title", yearType.Title)
};
return(SqlDBHelper.ExecuteNonQuery("YearType_Update", CommandType.StoredProcedure, parametersYearType));
}
public bool Update(ActivityType activityType)
{
SqlParameter[] parametersActivityType = new SqlParameter[]
{
new SqlParameter("@ActivityTypeID", activityType.ActivityTypeID),
new SqlParameter("@Title", activityType.Title)
};
return(SqlDBHelper.ExecuteNonQuery("ActivityType_Update", CommandType.StoredProcedure, parametersActivityType));
}
public bool Update(ComputationType computationType)
{
SqlParameter[] parametersComputationType = new SqlParameter[]
{
new SqlParameter("@ComputationTypeID", computationType.ComputationTypeID),
new SqlParameter("@Title", computationType.Title)
};
return(SqlDBHelper.ExecuteNonQuery("ComputationType_Update", CommandType.StoredProcedure, parametersComputationType));
}
public bool Update(RoleType roleType)
{
SqlParameter[] parametersRoleType = new SqlParameter[]
{
new SqlParameter("@RoleTypeID", roleType.RoleTypeID),
new SqlParameter("@Factor", roleType.Factor),
new SqlParameter("@Title", roleType.Title)
};
return(SqlDBHelper.ExecuteNonQuery("RoleType_Update", CommandType.StoredProcedure, parametersRoleType));
}
public bool Delete(Int64 nationalCode, int yearTypeID, int monthTypeID)
{
SqlParameter[] parametersOfficialEmployeeReward = new SqlParameter[]
{
new SqlParameter("@NationalCode", nationalCode),
new SqlParameter("@YearTypeID", yearTypeID),
new SqlParameter("@MonthTypeID", monthTypeID)
};
return(SqlDBHelper.ExecuteNonQuery("OfficialEmployeeReward_Delete", CommandType.StoredProcedure, parametersOfficialEmployeeReward));
}
public bool Update(AdjutancyType adjutancyType)
{
SqlParameter[] parametersAdjutancyType = new SqlParameter[]
{
new SqlParameter("@AdjutancyTypeID", adjutancyType.AdjutancyTypeID),
new SqlParameter("@AdjutantNationalCode", (adjutancyType.AdjutantNationalCode != null) ? adjutancyType.AdjutantNationalCode : (object)DBNull.Value),
new SqlParameter("@Title", (adjutancyType.Title != null) ? adjutancyType.Title : (object)DBNull.Value)
};
return(SqlDBHelper.ExecuteNonQuery("AdjutancyType_Update", CommandType.StoredProcedure, parametersAdjutancyType));
}
public bool Delete(int yearTypeID, int monthTypeID, int mainOfficeTypeID)
{
SqlParameter[] parametersBaseMonthlyInformation = new SqlParameter[]
{
new SqlParameter("@YearTypeID", yearTypeID),
new SqlParameter("@MonthTypeID", monthTypeID),
new SqlParameter("@MainOfficeTypeID", mainOfficeTypeID)
};
return(SqlDBHelper.ExecuteNonQuery("BaseMonthlyInformation_Delete", CommandType.StoredProcedure, parametersBaseMonthlyInformation));
}
public bool Update(MainOfficeType mainOfficeType)
{
SqlParameter[] parametersMainOfficeType = new SqlParameter[]
{
new SqlParameter("@MainOfficeTypeID", mainOfficeType.MainOfficeTypeID),
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)
};
return(SqlDBHelper.ExecuteNonQuery("MainOfficeType_Update", CommandType.StoredProcedure, parametersMainOfficeType));
}
public bool Update(User user)
{
employeeDBAccess.Update(user);
SqlParameter[] parametersUser = new SqlParameter[]
{
new SqlParameter("@NationalCode", user.NationalCode),
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.ExecuteNonQuery("User_Update", CommandType.StoredProcedure, parametersUser));
}
public bool Update(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 != null && employee.ContractTypeID > 0) ? employee.ContractTypeID : (object)DBNull.Value),
new SqlParameter("@RoleTypeID", (employee.RoleTypeID != null && employee.RoleTypeID > 0) ? employee.RoleTypeID : (object)DBNull.Value),
new SqlParameter("@DepartmentID", (employee.DepartmentID != null && employee.DepartmentID > 0) ? employee.DepartmentID : (object)DBNull.Value),
new SqlParameter("@IsActiveEmployee", employee.IsActiveEmployee)
};
return(SqlDBHelper.ExecuteNonQuery("Employee_Update", CommandType.StoredProcedure, parametersEmployee));
}
public bool Update(Department department)
{
SqlParameter[] parametersDepartment = new SqlParameter[]
{
new SqlParameter("@DepartmentID", department.DepartmentID),
new SqlParameter("@ComputationTypeID", (department.ComputationTypeID != null && department.ComputationTypeID > 0) ? department.ComputationTypeID : (object)DBNull.Value),
new SqlParameter("@MainOfficeTypeID", department.MainOfficeTypeID),
new SqlParameter("@AdjutancyTypeID", (department.AdjutancyTypeID != null && 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)
};
return(SqlDBHelper.ExecuteNonQuery("Department_Update", CommandType.StoredProcedure, parametersDepartment));
}
public bool Update(ContractualEmployeeReward contractualEmployeeReward)
{
SqlParameter[] parametersContractualEmployeeReward = new SqlParameter[]
{
new SqlParameter("@YearTypeID", contractualEmployeeReward.YearTypeID),
new SqlParameter("@MonthTypeID", contractualEmployeeReward.MonthTypeID),
new SqlParameter("@NationalCode", contractualEmployeeReward.NationalCode),
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.ExecuteNonQuery("ContractualEmployeeReward_Update", CommandType.StoredProcedure, parametersContractualEmployeeReward));
}
public bool Update(OfficialEmployeeReward officialEmployeeReward)
{
SqlParameter[] parametersOfficialEmployeeReward = new SqlParameter[]
{
new SqlParameter("@NationalCode", officialEmployeeReward.NationalCode),
new SqlParameter("@YearTypeID", officialEmployeeReward.YearTypeID),
new SqlParameter("@MonthTypeID", officialEmployeeReward.MonthTypeID),
new SqlParameter("@BossFactor", officialEmployeeReward.BossFactor),
new SqlParameter("@Reward", officialEmployeeReward.Reward),
new SqlParameter("@BossFinalValue", officialEmployeeReward.BossFinalValue),
new SqlParameter("@AssistantFinalValue", officialEmployeeReward.AssistantFinalValue),
new SqlParameter("@ManagerFinalValue", officialEmployeeReward.ManagerFinalValue),
new SqlParameter("@ExtraReward1", officialEmployeeReward.ExtraReward1),
new SqlParameter("@ExtraReward2", officialEmployeeReward.ExtraReward2),
new SqlParameter("@ExtraReward3", officialEmployeeReward.ExtraReward3),
new SqlParameter("@RoleTypeID", (officialEmployeeReward.RoleTypeID != null) ? officialEmployeeReward.RoleTypeID : (object)DBNull.Value),
new SqlParameter("@Parameter1", officialEmployeeReward.Parameter1),
new SqlParameter("@Parameter2", officialEmployeeReward.Parameter2),
new SqlParameter("@Parameter3", officialEmployeeReward.Parameter3)
};
return(SqlDBHelper.ExecuteNonQuery("OfficialEmployeeReward_Update", CommandType.StoredProcedure, parametersOfficialEmployeeReward));
}
