public static List <MessagingRoomParticipants> GetByRoomID(Guid id) { using (var context = new UploadersContext()) { var query = (from i in context.MessagingRoomParticipantsDB where i.RoomID == id select i).ToList(); return(query); } }
public static CloudMessagingRoom GetByID(Guid ID) { using (var context = new UploadersContext()) { var query = (from i in context.CloudMessagingRoomDB where i.ID == ID select i).FirstOrDefault(); return(query); } }
public static MessagingConversation GetByID(Guid id) { using (var context = new UploadersContext()) { var query = (from i in context.MessagingConversationDB where i.ID == id select i).FirstOrDefault(); return(query); } }
public static List <MessagingRoomParticipants> GetByParticipantID(string id, Guid api) { using (var context = new UploadersContext()) { var query = (from i in context.MessagingRoomParticipantsDB where i.UserID.Equals(id) && i.API == api select i).ToList(); return(query); } }
public static NotificationManager GetByID_N(Guid id, Guid api) { using (var context = new UploadersContext()) { var query = (from i in context.NotificationManagerDB where i.ID == id && i.apiKey == api select i).FirstOrDefault(); return(query); } }
public static SecurityCode GetBy(Guid id) { using (var context = new UploadersContext()) { var query = (from i in context.SecurityCodeDB where i.ID == id select i).FirstOrDefault(); return(query); } }
public static List <NotificationManagerReceipent> GetByNotificationID_NR(Guid id) { using (var context = new UploadersContext()) { var query = (from i in context.NotificationManagerReceipentDB where i.NotificationInfo == id select i).ToList(); return(query); } }
public static List <CloudRoomParticipants> GetByUserID(Guid id) { using (var context = new UploadersContext()) { var query = (from i in context.CloudRoomParticipantsDB where i.UserID == id select i).ToList(); return(query); } }
public static List <NotificationManagerReceipent> GetByUIDAPI_NR(string id, Guid api) { using (var context = new UploadersContext()) { var query = (from i in context.NotificationManagerReceipentDB where i.ReceiverID == id && i.API == api select i).ToList(); return(query); } }
public static CloudRoomParticipants GetByUIDRoomID(Guid id, Guid rid) { using (var context = new UploadersContext()) { var query = (from i in context.CloudRoomParticipantsDB where i.UserID == id && i.RoomID == rid select i).FirstOrDefault(); return(query); } }
public static List <CloudMessagingConversation> GetByRoomConversation(Guid id, bool isSync) { using (var context = new UploadersContext()) { var query = (from i in context.CloudMessagingConversationDB where i.RoomConversation == id && i.isSync == isSync select i).ToList(); return(query); } }
public static List <MessagingRoomParticipants> GetByRoomIDExceptUID(Guid rid, string uid) { using (var context = new UploadersContext()){ var query = (from i in context.MessagingRoomParticipantsDB where i.RoomID == rid && i.UserID != uid select i).ToList(); return(query); } }
public static SecurityCode GetByOwnerID(string id, Guid api) { using (var context = new UploadersContext()) { var query = (from i in context.SecurityCodeDB where i.OwnerID.Equals(id) && i.API == api select i).FirstOrDefault(); return(query); } }
public static List <MessagingConversation> GetByRoomID(Guid id) { using (var context = new UploadersContext()) { var query = (from i in context.MessagingConversationDB where i.RoomID == id orderby i.CreatedAt descending select i).ToList(); return(query); } }
public static CompanyAPIKey GetByAPIKeyCompID(Guid id, Guid cid) { using (var context = new UploadersContext()) { var query = (from i in context.CompanyAPIKeyDB where i.APIKey == id && i.CompanyID == cid select i).FirstOrDefault(); return(query); } }
public static MessagingRoom GetByID(Guid id, Guid API) { using (var context = new UploadersContext()) { var query = (from i in context.MessagingRoomDB where i.ID == id && i.API == API select i).FirstOrDefault(); return(query); } }
public static List <CloudMessageReceipent> GetByUserID(Guid id) { using (var context = new UploadersContext()) { var query = (from i in context.CloudMessageReceipentDB where i.UserID == id select i).ToList(); return(query); } }
//signalR ID public static UserInformation GetBySID(Guid id) { using (var context = new UploadersContext()) { var query = (from i in context.UserInformationDB where i.SignalRID == id select i).FirstOrDefault(); return(query); } }
public static ImageLinkStorage GetByID(Guid id, Guid api) { using (var context = new UploadersContext()) { var query = (from i in context.ImageLinkStorageDB where i.ID == id && i.API == api select i).FirstOrDefault(); return(query); } }
public static List <ImageLinkStorage> GetByOidAPI(Guid oid, Guid api) { using (var context = new UploadersContext()) { var query = (from i in context.ImageLinkStorageDB where i.OwnerID == oid && i.API == api select i).ToList(); return(query); } }
public static bool Remove(Guid id) { try { using (var context = new UploadersContext()) { var query = (from i in context.CloudMessagingConversationDB where i.ID == id select i).FirstOrDefault(); context.CloudMessagingConversationDB.Remove(query); return(true); } } catch { return(false); } }
public static bool Insert(Guid id, string uid, Guid sid, bool isActive) { try { using (var context = new UploadersContext()) { var model = UserInformationVM.Set(id, uid, sid, isActive); context.UserInformationDB.Add(model); context.SaveChanges(); return(true); } } catch { return(false); } }
public static bool Remove(Guid id) { try { using (var context = new UploadersContext()) { var query = (from i in context.CloudRoomParticipantsDB where i.ID == id select i).FirstOrDefault(); context.CloudRoomParticipantsDB.Remove(query); context.SaveChanges(); return(true); } } catch { return(false); } }
public static bool Insert(Guid ID, Guid UserID, Guid RoomID) { try { using (var context = new UploadersContext()) { var model = CloudRoomParticipantsVM.Set(ID, UserID, RoomID); context.CloudRoomParticipantsDB.Add(model); context.SaveChanges(); return(true); } } catch { return(false); } }
public static bool Remove_N(Guid id, Guid api) { try { using (var context = new UploadersContext()) { var query = (from i in context.NotificationManagerDB where i.ID == id && i.apiKey == api select i).FirstOrDefault(); context.NotificationManagerDB.Remove(query); context.SaveChanges(); return(true); } } catch { return(false); } }
public static bool Insert(Guid id, string uid, Guid roomID, Guid api) { try { using (var context = new UploadersContext()) { var model = MessagingRoomParticipantsVM.set(id, uid, roomID, api); context.MessagingRoomParticipantsDB.Add(model); context.SaveChanges(); return(true); } } catch { return(false); } }
public static bool Insert(Guid id, Guid api, string code, string oid) { try { using (var context = new UploadersContext()) { var model = SecurityCodeVM.Set(id, api, code, oid); context.SecurityCodeDB.Add(model); context.SaveChanges(); return(true); } } catch { return(false); } }
public static bool Remove(Guid id, Guid api) { try { using (var context = new UploadersContext()) { var query = (from i in context.SecurityCodeDB where i.ID == id && i.API == api select i).FirstOrDefault(); context.SecurityCodeDB.Remove(query); context.SaveChanges(); return(true); } } catch { return(false); } }
public static bool Insert(Guid id, string RoomName, Guid APIKey, bool isSync) { try { using (var context = new UploadersContext()) { var model = CloudMessagingRoomVM.Set(id, RoomName, APIKey, isSync); context.CloudMessagingRoomDB.Add(model); context.SaveChanges(); return(true); } } catch { return(false); } }
public static bool Insert(Guid id, Guid uid, Guid cmcID, DateTime createdAt, Guid roomID) { try { using (var context = new UploadersContext()) { var model = CloudMessageReceipentVM.Set(id, uid, cmcID, createdAt, roomID); context.CloudMessageReceipentDB.Add(model); context.SaveChanges(); return(true); } } catch { return(false); } }