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); }
}
