/// <summary> /// /// </summary> /// <param name="id_usr"></param> /// <param name="usr_status"></param> /// <returns></returns> public static bool user_SetStatus(int id_usr, UsrStatus usr_status) { try { using (MessDataContext db = new MessDataContext()) { USER usr = db.USERs.Where(i => i.ID_USR == id_usr).FirstOrDefault(); if (usr != null) { usr.USR_STATUS = (int)usr_status; db.SubmitChanges(); } } } catch (Exception) { return false; } return true; }
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; } }
/// <summary> /// Metoda vklada do DB noveho uzivatele s vychozim nastavenim /// </summary> /// <param name="nick">uzivatelske jmeno</param> /// <param name="password">heslo</param> /// <returns>identifikator prave pridaneho uzivatele</returns> public static int user_insertNewUser(string nick, string password) { int usr_id = 0; try { using (MessDataContext db = new MessDataContext()) { USER usr = new USER(); usr.C_USER = 0; usr.C_DATE = DateTime.Now; usr.USR_NICK = nick; usr.USR_PASSWORD = password; usr.USR_STATE = (int)UsrState.aktivni; usr.USR_STATUS = (int)UsrStatus.offline; db.USERs.InsertOnSubmit(usr); db.SubmitChanges(); usr_id = db.USERs.Max(i => i.ID_USR); } } catch (Exception) { usr_id = 0; } return usr_id; }
public static List<DlMessage> message_GetNewMessages(int id_usr) { try { using (MessDataContext db = new MessDataContext()) { var messages = from i in db.MESSTOUSRs where i.ID_USR == id_usr && i.MSG_STATE == (int)MsgState.New join m in db.MESSAGEs on i.ID_MESSAGE equals m.ID_MESSAGE select new { i.MSG_STATE, i.ID_SENDER, m.MSG_TYPE, m.MSG_BODY, m.C_DATE, m.ID_MESSAGE }; List<DlMessage> msg = new List<DlMessage>(); foreach (var mess in messages) { msg.Add(new DlMessage(mess.MSG_STATE, mess.ID_SENDER, mess.MSG_TYPE, mess.MSG_BODY, mess.C_DATE, mess.ID_MESSAGE)); } var messtousrs = from i in db.MESSTOUSRs where i.ID_USR == id_usr && i.MSG_STATE == (int)MsgState.New join m in db.MESSAGEs on i.ID_MESSAGE equals m.ID_MESSAGE select i; foreach (var item in messtousrs) { item.MSG_STATE = (int)MsgState.Old; } db.SubmitChanges(); return msg; } } catch (Exception) { return null; } }