Ejemplo n.º 1
0
        public void UpdateStep(PayScaleStepItemEntity t, int contractTemplateId, string jobCode, string gradeId)
        {
            SqlConnection conn = null;
            SqlCommand    cmd  = null;

            try
            {
                conn            = DALHelper.CreateSqlDbConnection();
                cmd             = new SqlCommand("usp_UpdatePayScaleStepItem", conn);
                cmd.CommandType = System.Data.CommandType.StoredProcedure;

                cmd.Parameters.AddWithValue("@ContractTemplateId", contractTemplateId);
                cmd.Parameters.AddWithValue("@JobCode", jobCode);
                cmd.Parameters.AddWithValue("@GradeId", gradeId);
                cmd.Parameters.AddWithValue("@StepId", t.StepId);
                cmd.Parameters.AddWithValue("@StepEntry", t.StepEntry);

                cmd.ExecuteNonQuery();
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                conn.Close();
                cmd.Dispose();
                conn.Dispose();
            }
        }
Ejemplo n.º 2
0
        protected void btnUpdate2_Click(object sender, EventArgs e)
        {
            PayScaleStepItemEntity step = new PayScaleStepItemEntity();

            step.StepId    = StepLabel.Text;
            step.StepEntry = Convert.ToDouble(StepEntryTextBox.Text);

            new PayScaleMapper().UpdateStep(step, Convert.ToInt32(Request.QueryString["ContractTemplateId"].ToString()), Session["jobCode"].ToString(), Session["gradeId"].ToString());
            Response.Redirect("PayScale.aspx?ContractTemplateId=" + Request.QueryString["ContractTemplateId"]);
        }
Ejemplo n.º 3
0
        public List <PayScaleStepItemEntity> ListStepsFromPayScale(int contractTemplateId, string jobCode, string gradeId)
        {
            SqlConnection conn = null;
            SqlCommand    cmd  = null;

            try
            {
                conn            = DALHelper.CreateSqlDbConnection();
                cmd             = new SqlCommand("usp_ListStepsByContractTemplateIdAndJobCodeAndGradeFromPayScale", conn);
                cmd.CommandType = System.Data.CommandType.StoredProcedure;

                cmd.Parameters.AddWithValue("@ContractTemplateId", contractTemplateId);
                cmd.Parameters.AddWithValue("@JobCode", jobCode);
                cmd.Parameters.AddWithValue("@GradeId", gradeId);

                SqlDataReader rdr = cmd.ExecuteReader();
                List <PayScaleStepItemEntity> list = new List <PayScaleStepItemEntity>();

                while (rdr.Read())
                {
                    PayScaleStepItemEntity view = new PayScaleStepItemEntity();
                    view.StepId    = Convert.ToString(rdr["StepId"]);
                    view.StepEntry = Convert.ToDouble(rdr["StepEntry"]);

                    list.Add(view);
                }

                return(list);
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                conn.Close();
                cmd.Dispose();
                conn.Dispose();
            }
        }