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