public static bool message_InsertMessage(int id_usr, string msg_body, int msg_type, int[] dest_users)
{
long id_message = 0;
try
{
using (MessDataContext db = new MessDataContext())
{
MESSAGE msg = new MESSAGE();
msg.MSG_TYPE = msg_type;
msg.MSG_BODY = msg_body;
msg.C_DATE = DateTime.Now;
db.MESSAGEs.InsertOnSubmit(msg);
db.SubmitChanges();
id_message = db.MESSAGEs.Max(i => i.ID_MESSAGE);
foreach (var du in dest_users)
{
MESSTOUSR m2u = new MESSTOUSR();
m2u.MSG_STATE = (int)MsgState.New;
m2u.ID_MESSAGE = id_message;
m2u.ID_SENDER = id_usr;
m2u.ID_USR = du;
db.MESSTOUSRs.InsertOnSubmit(m2u);
}
db.SubmitChanges();
}
return true;
}
catch (Exception)
{
return false;
}
}
partial void UpdateMESSAGE(MESSAGE instance);
partial void DeleteMESSAGE(MESSAGE instance);
partial void InsertMESSAGE(MESSAGE instance);
