public static ENTVWREQREQUESTS GetRequest(Guid ID)
{
con = SQL.GetConnection();
cmd = SQL.SetCommand("SELECT * FROM VW_REQ_Request WHERE ID=@ID", con);
cmd.Parameters.AddWithValue("@ID", ID);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
ENTVWREQREQUESTS rqst = null;
while (dr.Read())
{
rqst = new ENTVWREQREQUESTS(Guid.Parse(dr["ID"].ToString()), Guid.Parse(dr["PROJECTID"].ToString()), dr["NAME"].ToString(), Convert.ToByte(dr["TYPEREQUESTID"].ToString()), Guid.Parse(dr["USERID"].ToString()), Convert.ToDateTime(dr["REQUESTDATE"].ToString()), dr["DESCRIPTION"].ToString(), dr["PROJECTNAME"].ToString(), dr["TYPEREQUESTSTATUSNAME"].ToString(), Convert.ToBoolean(dr["ISOPEN"].ToString()), dr["USERFULLNAME"].ToString());
break;
}
con.Close();
return(rqst);
}
public static List <ENTVWREQREQUESTS> GetAllListRequest()
{
con = SQL.GetConnection();
cmd = SQL.SetCommand("SELECT * FROM VW_REQ_Request", con);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
ENTVWREQREQUESTS rqst = null;
List <ENTVWREQREQUESTS> rqstList = new List <ENTVWREQREQUESTS>();
while (dr.Read())
{
rqst = new ENTVWREQREQUESTS(Guid.Parse(dr["ID"].ToString()), Guid.Parse(dr["PROJECTID"].ToString()), dr["NAME"].ToString(), Convert.ToByte(dr["TYPEREQUESTID"].ToString()), Guid.Parse(dr["USERID"].ToString()), Convert.ToDateTime(dr["REQUESTDATE"].ToString()), dr["DESCRIPTION"].ToString(), dr["PROJECTNAME"].ToString(), dr["TYPEREQUESTSTATUSNAME"].ToString(), Convert.ToBoolean(dr["ISOPEN"].ToString()), dr["USERFULLNAME"].ToString());
rqstList.Add(rqst);
}
con.Close();
return(rqstList);
}
