/// <summary> /// Cập nhập lại chức vụ /// </summary> /// <param name="title"></param> /// <returns></returns> public int UpdateJobTitle(dtoJobTitle title) { int count = 0; try { string sql = "UPDATE [dbo].[JobTitle] SET [JobTitleName] = @JobTitleName, [Major] = @Major, [PositionAllowance] = @PositionAllowance, [CoefficientsSalary] = @CoefficientsSalary WHERE [JobTitleID] = @JobTitleID"; SqlParameter parameterJobTitleID = new SqlParameter("@JobTitleID", SqlDbType.Int); parameterJobTitleID.Value = title.JobTitleID; SqlParameter parameterJobTitleName = new SqlParameter("@JobTitleName", SqlDbType.NVarChar); parameterJobTitleName.Value = title.JobTitleName; SqlParameter parameterMajor = new SqlParameter("@Major", SqlDbType.NVarChar); parameterMajor.Value = title.Major; SqlParameter parameterPositionAllowance = new SqlParameter("@PositionAllowance", SqlDbType.Money); parameterPositionAllowance.Value = title.PositionAllowance; SqlParameter parameterCoefficientsSalary = new SqlParameter("@CoefficientsSalary", SqlDbType.Float); parameterCoefficientsSalary.Value = title.CoefficientsSalary; count = InsertUpdateDeleteData(sql, new[] { parameterJobTitleName, parameterMajor, parameterPositionAllowance, parameterCoefficientsSalary }); } finally { CloseConnection(); } return(count); }
public List <dtoJobTitle> GetJobTitles() { dalJobTitle dalJobTitle = new dalJobTitle(); List <dtoJobTitle> listEmp = new List <dtoJobTitle>(); DataTable JobTitles = dalJobTitle.GetJobTitles(); for (int i = 0; i < JobTitles.Rows.Count; i++) { dtoJobTitle JobTitle = new dtoJobTitle(); DataRow row = JobTitles.Rows[i]; JobTitle.JobTitleID = Convert.ToInt32(row[0]); JobTitle.JobTitleName = row[1].ToString(); JobTitle.Major = row[2].ToString(); JobTitle.PositionAllowance = Convert.ToDecimal(row[3]); JobTitle.CoefficientsSalary = Convert.ToDouble(row[4]); listEmp.Add(JobTitle); } return(listEmp); }
/// <summary> /// Thêm chức vụ mới /// </summary> /// <param name="title"></param> /// <returns></returns> public int InsertJobTitle(dtoJobTitle title) { int count = 0; try { string sql = "INSERT [dbo].[JobTitle] ([JobTitleName], [Major], [PositionAllowance], [CoefficientsSalary]) VALUES ( @JobTitleName, @Major, @PositionAllowance, @CoefficientsSalary)"; SqlParameter parameterJobTitleName = new SqlParameter("@JobTitleName", SqlDbType.NVarChar); parameterJobTitleName.Value = title.JobTitleName; SqlParameter parameterMajor = new SqlParameter("@Major", SqlDbType.NVarChar); parameterMajor.Value = title.Major; SqlParameter parameterPositionAllowance = new SqlParameter("@PositionAllowance", SqlDbType.Money); parameterPositionAllowance.Value = title.PositionAllowance; SqlParameter parameterCoefficientsSalary = new SqlParameter("@CoefficientsSalary", SqlDbType.Float); parameterCoefficientsSalary.Value = title.CoefficientsSalary; count = InsertUpdateDeleteData(sql, new[] { parameterJobTitleName, parameterMajor, parameterPositionAllowance, parameterCoefficientsSalary }); } finally { CloseConnection(); } return(count); }