예제 #1
0
        public LeaveRespond CheckLeaveStatus(int leaveRequestId, RequestsProcessedByEnum en)
        {
            SqlConnection conn = null;
            SqlCommand    cmd  = null;

            try
            {
                conn            = DALHelper.CreateSqlDbConnection();
                cmd             = new SqlCommand("usp_CheckLeaveStatus", conn);
                cmd.CommandType = System.Data.CommandType.StoredProcedure;
                cmd.Parameters.AddWithValue("@LeaveRequestId", leaveRequestId);
                cmd.Parameters.AddWithValue("@RequestProcessedBy", en);

                SqlDataReader rdr     = cmd.ExecuteReader();
                LeaveRespond  respond = new LeaveRespond();
                if (rdr.Read())
                {
                    respond.Id             = Convert.ToInt32(rdr["Id"]);
                    respond.LeaveRequestId = leaveRequestId;
                }
                return(respond);
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                conn.Close();
                cmd.Dispose();
                conn.Dispose();
            }
        }
예제 #2
0
        public LeaveRespond CheckLeaveStatus(int leaveRequestId, RequestsProcessedByEnum en)
        {
            SqlConnection conn = null;
            SqlCommand cmd = null;

            try
            {
                conn = DALHelper.CreateSqlDbConnection();
                cmd = new SqlCommand("usp_CheckLeaveStatus", conn);
                cmd.CommandType = System.Data.CommandType.StoredProcedure;
                cmd.Parameters.AddWithValue("@LeaveRequestId", leaveRequestId);
                cmd.Parameters.AddWithValue("@RequestProcessedBy", en);

                SqlDataReader rdr = cmd.ExecuteReader();
                LeaveRespond respond = new LeaveRespond();
                if(rdr.Read())
                {
                    respond.Id = Convert.ToInt32(rdr["Id"]);
                    respond.LeaveRequestId = leaveRequestId;
                }
                    return respond;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                conn.Close();
                cmd.Dispose();
                conn.Dispose();
            }
        }