public static void InsertTable(ENTREQREQUESTS rqst)
        {
            try
            {
                con = SQL.GetConnection();
                if (con.State == ConnectionState.Closed)
                {
                    con.Open();
                }
                cmd = SQL.SetCommand("INSERT INTO REQ_REQUEST (ID,PROJECTID,NAME,TYPEREQUESTID,USERID,REQUESTDATE,DESCRIPTION) VALUES (@ID,@PROJECTID,@NAME,@TYPEREQUESTID,@USERID,@REQUESTDATE,@DESCRIPTION)", con);
                cmd.Parameters.AddWithValue("@ID", rqst.ID);
                cmd.Parameters.AddWithValue("@PROJECTID", rqst.PROJECTID);
                cmd.Parameters.AddWithValue("@NAME", rqst.NAME);
                cmd.Parameters.AddWithValue("@TYPEREQUESTID", rqst.TYPEREQUESTID);
                cmd.Parameters.AddWithValue("@USERID", rqst.USERID);
                cmd.Parameters.AddWithValue("@REQUESTDATE", rqst.REQUESTDATE);
                cmd.Parameters.AddWithValue("@DESCRIPTION", rqst.DESCRIPTION);

                cmd.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
            }
            finally
            {
                if (con.State == ConnectionState.Open)
                {
                    con.Close();
                }
            }
        }
 public static void UpdateStatus(ENTREQREQUESTS rqst)
 {
     con = SQL.GetConnection();
     cmd = SQL.SetCommand("UPDATE REQ_REQUEST SET TYPEREQUESTID=@TYPEREQUESTID WHERE ID = @ID", con);
     cmd.Parameters.AddWithValue("@ID", rqst.ID);
     cmd.Parameters.AddWithValue("@TYPEREQUESTID", rqst.TYPEREQUESTID);
     con.Open();
     cmd.ExecuteNonQuery();
     con.Close();
 }
        public static ENTREQREQUESTS GetValueStatus(Guid ID)
        {
            con = SQL.GetConnection();
            cmd = SQL.SetCommand("SELECT * FROM REQ_Request WHERE ID=@ID", con);
            cmd.Parameters.AddWithValue("@ID", ID);

            con.Open();
            SqlDataReader  dr   = cmd.ExecuteReader();
            ENTREQREQUESTS rqst = null;

            while (dr.Read())
            {
                rqst = new ENTREQREQUESTS(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());
                break;
            }
            con.Close();
            return(rqst);
        }
        public static List <ENTREQREQUESTS> GetAllListFirmRequestsID(Guid USERID)
        {
            con = SQL.GetConnection();
            cmd = SQL.SetCommand("SELECT * FROM REQ_REQUEST WHERE USERID=@USERID", con);
            cmd.Parameters.AddWithValue("@USERID", USERID);
            con.Open();
            SqlDataReader         dr       = cmd.ExecuteReader();
            ENTREQREQUESTS        ptsk     = null;
            List <ENTREQREQUESTS> ptsklist = new List <ENTREQREQUESTS>();

            while (dr.Read())
            {
                ptsk = new ENTREQREQUESTS(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());
                ptsklist.Add(ptsk);
            }
            con.Close();

            return(ptsklist);
        }