public PTORequest GetPTORequestByID(int id, int userid) { string query = "SELECT Id, userid, start_date, end_date, hours, typeid, comments " + " FROM PTORequests " + " WHERE id=@id AND userid=@userid"; SqlConnection con = new SqlConnection(conn); DataSet ds = new DataSet(); DataTable dt = new DataTable(); try { SqlDataAdapter dataAdapter = new SqlDataAdapter(query, con); dataAdapter.SelectCommand.Parameters.Add(new SqlParameter("@id", id)); dataAdapter.SelectCommand.Parameters.Add(new SqlParameter("@userid", userid)); con.Open(); dataAdapter.Fill(dt); PTORequest request = new PTORequest { Id = Int32.Parse(dt.Rows[0]["id"].ToString()), TypeId = Int32.Parse(dt.Rows[0]["typeid"].ToString()), StartDate = DateTime.Parse(dt.Rows[0]["start_date"].ToString()), EndDate = DateTime.Parse(dt.Rows[0]["end_date"].ToString()), Comments = dt.Rows[0]["comments"].ToString(), Hours = Int32.Parse(dt.Rows[0]["hours"].ToString()) }; return(request); } catch (Exception ex) { HandleError(ex, query); return(null); } finally { if (con.State == System.Data.ConnectionState.Open) { con.Close(); } } }
public PTORequest GetPTORequestDetailsByID(int id) { string query = "SELECT PTORequests.id, Users.userid, Users.name, PTORequests.start_date, PTORequests.end_date, PTORequests.hours, PTORequests.comments, PTORequests.typeid, " + " PTORequests.date_requested, PTORequests.date_approved, TimeOffType.description, TimeOffType.credit " + " FROM PTORequests INNER JOIN " + " TimeOffType ON PTORequests.typeid = TimeOffType.typeid INNER JOIN " + " Users ON PTORequests.userid = Users.userid " + " WHERE PTORequests.id=@id "; SqlConnection con = new SqlConnection(conn); DataSet ds = new DataSet(); DataTable dt = new DataTable(); try { SqlDataAdapter dataAdapter = new SqlDataAdapter(query, con); dataAdapter.SelectCommand.Parameters.Add(new SqlParameter("@id", id)); con.Open(); dataAdapter.Fill(dt); DateTime startDate; DateTime.TryParse(dt.Rows[0]["start_date"].ToString(), out startDate); DateTime endDate; DateTime.TryParse(dt.Rows[0]["end_date"].ToString(), out endDate); DateTime dateRequested; DateTime.TryParse(dt.Rows[0]["date_requested"].ToString(), out dateRequested); DateTime dateApproved; DateTime.TryParse(dt.Rows[0]["date_approved"].ToString(), out dateApproved); PTORequest request = new PTORequest { Id = Int32.Parse(dt.Rows[0]["id"].ToString()), Name = dt.Rows[0]["name"].ToString(), TypeId = Int32.Parse(dt.Rows[0]["typeid"].ToString()), Description = dt.Rows[0]["description"].ToString(), StartDate = startDate, EndDate = endDate, Comments = dt.Rows[0]["comments"].ToString(), Hours = Int32.Parse(dt.Rows[0]["hours"].ToString()), Credit = bool.Parse(dt.Rows[0]["credit"].ToString()), DateRequested = dateRequested, DateApproved = dateApproved }; return(request); } catch (Exception ex) { HandleError(ex, query); return(null); } finally { if (con.State == System.Data.ConnectionState.Open) { con.Close(); } } }