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