예제 #1
0
        public void Delete(LeaveTypeLevelEntity t)
        {
            SqlConnection conn = null;
            SqlCommand cmd = null;

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

                cmd.Parameters.AddWithValue("@Id", t.Id);

                cmd.ExecuteNonQuery();
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                conn.Close();
                cmd.Dispose();
                conn.Dispose();
            }
        }
예제 #2
0
        public void Insert(LeaveTypeLevelEntity t)
        {
            SqlConnection conn = null;
            SqlCommand cmd = null;

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

                cmd.Parameters.AddWithValue("@LeaveTypeId", t.LeaveTypeId);
                cmd.Parameters.AddWithValue("@NoOfDays", t.NoOfDays);
                cmd.Parameters.AddWithValue("@PaymentPercentage", t.PaymentPercentage);
                cmd.Parameters.AddWithValue("@LeaveNameType", t.LeaveNameType);

                cmd.ExecuteNonQuery();
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                conn.Close();
                cmd.Dispose();
                conn.Dispose();
            }
        }
예제 #3
0
        protected void AddPaymentTypeButton_Click(object sender, EventArgs e)
        {
            LeaveTypeLevelEntity entity = new LeaveTypeLevelEntity();
            LeaveTypeLevelMapper mapper = new LeaveTypeLevelMapper();

            entity.LeaveTypeId = Convert.ToInt32(Request.QueryString["LeaveTypeId"]);
            entity.NoOfDays = Convert.ToInt32(NoDaysTextBox.Text);
            entity.PaymentPercentage = Convert.ToInt32(PaymentPercentageTextBox.Text);
            entity.LeaveNameType = (LeaveNameType)Enum.Parse(typeof(LeaveNameType), TypeDropDownList.SelectedValue.ToString());

            mapper.Insert(entity);

            LeaveTypeGridView.DataBind();
        }
예제 #4
0
        public List<LeaveTypeLevelEntity> List(int LeaveTypeId)
        {
            SqlConnection conn = null;
            SqlCommand cmd = null;

            try
            {
                conn = DALHelper.CreateSqlDbConnection();
                cmd = new SqlCommand("usp_ListLeaveTypeLevelByLeaveTypeId", conn);
                cmd.CommandType = System.Data.CommandType.StoredProcedure;
                cmd.Parameters.AddWithValue("@LeaveTypeId", LeaveTypeId);

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

                while (rdr.Read())
                {
                    LeaveTypeLevelEntity entity = new LeaveTypeLevelEntity();
                    entity.Id = Convert.ToInt32(rdr["Id"]);
                    entity.LeaveTypeId = Convert.ToInt32(rdr["LeaveTypeId"]);
                    entity.NoOfDays = Convert.ToInt32(rdr["NoOfDays"]);
                    entity.PaymentPercentage = Convert.ToDouble(rdr["PaymentPercentage"]);
                    entity.LeaveNameType = (LeaveNameType)Convert.ToInt32(rdr["LeaveNameType"]);

                    list.Add(entity);
                }

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