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();
}
}
}
