protected void btnUpdate_Click(object sender, EventArgs e)
{
PayScaleGradeItemEntity grade = new PayScaleGradeItemEntity();
grade.GradeId = GradeLabel.Text;
grade.GradeEntry = Convert.ToDouble(GradeEntryTextBox.Text);
grade.GradeKCB = Convert.ToDouble(GradeKCBTextBox.Text);
new PayScaleMapper().UpdateGrade(grade, Convert.ToInt32(Request.QueryString["ContractTemplateId"].ToString()), Session["jobCode"].ToString());
Response.Redirect("PayScale.aspx?ContractTemplateId=" + Request.QueryString["ContractTemplateId"]);
}
public List<PayScaleGradeItemEntity> ListGradesFromPayScale(int contractTemplateId, string jobCode)
{
SqlConnection conn = null;
SqlCommand cmd = null;
try
{
conn = DALHelper.CreateSqlDbConnection();
cmd = new SqlCommand("usp_ListGradesByContractTemplateIdAndJobCodeFromPayScale", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ContractTemplateId", contractTemplateId);
cmd.Parameters.AddWithValue("@JobCode", jobCode);
SqlDataReader rdr = cmd.ExecuteReader();
List<PayScaleGradeItemEntity> list = new List<PayScaleGradeItemEntity>();
while (rdr.Read())
{
PayScaleGradeItemEntity view = new PayScaleGradeItemEntity();
view.GradeId = Convert.ToString(rdr["GradeId"]);
view.GradeEntry = Convert.ToDouble(rdr["GradeEntry"]);
view.GradeKCB = Convert.ToDouble(rdr["GradeKCB"]);
list.Add(view);
}
return list;
}
catch (Exception)
{
throw;
}
finally
{
conn.Close();
cmd.Dispose();
conn.Dispose();
}
}
public void UpdateGrade(PayScaleGradeItemEntity t, int contractTemplateId, string jobCode)
{
SqlConnection conn = null;
SqlCommand cmd = null;
try
{
conn = DALHelper.CreateSqlDbConnection();
cmd = new SqlCommand("usp_UpdatePayScaleGradeItem", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ContractTemplateId", contractTemplateId);
cmd.Parameters.AddWithValue("@JobCode", jobCode);
cmd.Parameters.AddWithValue("@GradeId", t.GradeId);
cmd.Parameters.AddWithValue("@GradeEntry", t.GradeEntry);
cmd.Parameters.AddWithValue("@GradeKCB", t.GradeKCB);
cmd.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
finally
{
conn.Close();
cmd.Dispose();
conn.Dispose();
}
}