static DataTable SaveMessage2DBAndSelect(int id_user_from, int id_user_to, string message, string gift_list, int id_offer)
{
DB_Helper db = new DB_Helper();
string s = "";
if (MyUtils.IsFemale)
{
s = "select female_sent_msg from offers where id_offer=" + id_offer;
int female_sent_msg = db.ExecuteScalarIntCache(s, 0, 5);
if (female_sent_msg == 0)
{
db.Execute("update offers set female_sent_msg=1 where isnull(female_sent_msg,0)=0 and id_offer=" + id_offer + "; ");
DB_Helper.InvalidateCache("SQL_" + s);
}
}
return(db.GetDataSet("insert into messages (id_user_from,id_user_to,text,gift_list,id_offer) OUTPUT inserted.* values (" + id_user_from + "," + id_user_to + "," + MyUtils.safe(message) + "," + MyUtils.safe(gift_list) + "," + id_offer + ");").Tables[0]);
}
