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