public static void InsertMessage(ENTREQREQUESTDETAIL rqstdtl)
{
try
{
con = SQL.GetConnection();
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd = SQL.SetCommand("INSERT INTO REQ_REQUESTDETAIL (ID,REQUESTID,USERID,MESSAGE,DATE) VALUES (@ID,@REQUESTID,@USERID,@MESSAGE,@DATE)", con);
cmd.Parameters.AddWithValue("@ID", rqstdtl.ID);
cmd.Parameters.AddWithValue("@REQUESTID", rqstdtl.REQUESTID);
cmd.Parameters.AddWithValue("@USERID", rqstdtl.USERID);
cmd.Parameters.AddWithValue("@MESSAGE", rqstdtl.MESSAGE);
cmd.Parameters.AddWithValue("@DATE", rqstdtl.DATE);
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
public static List <ENTREQREQUESTDETAIL> GetAllListRequestDetailsID(Guid REQUESTID)
{
con = SQL.GetConnection();
cmd = SQL.SetCommand("SELECT * FROM REQ_REQUESTDETAIL WHERE REQUESTID=@REQUESTID", con);
cmd.Parameters.AddWithValue("@REQUESTID", REQUESTID);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
ENTREQREQUESTDETAIL ptsk = null;
List <ENTREQREQUESTDETAIL> ptsklist = new List <ENTREQREQUESTDETAIL>();
while (dr.Read())
{
ptsk = new ENTREQREQUESTDETAIL(Guid.Parse(dr["ID"].ToString()), Guid.Parse(dr["REQUESTID"].ToString()), Guid.Parse(dr["USERID"].ToString()), dr["MESSAGE"].ToString(), Convert.ToDateTime(dr["DATE"].ToString()));
ptsklist.Add(ptsk);
}
con.Close();
return(ptsklist);
}