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 Insert(Guid id, string message, Guid API, string title)
{
try {
using (var context = new UploadersContext()) {
var model = NotificationManagerVM.Set(id, message, API, title);
context.NotificationManagerDB.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 InsertNR(Guid id, Guid NotificationID, string receiverID, Guid api)
{
try {
using (var context = new UploadersContext()) {
var model = NotificationManagerReceipentVM.set(id, NotificationID, receiverID, api);
context.NotificationManagerReceipentDB.Add(model);
context.SaveChanges();
return(true);
}
} catch { return(false); }
}
//update the message into synced
public static bool Sync(Guid id, bool isSync)
{
try {
using (var context = new UploadersContext()) {
var query = (from i in context.CloudMessagingRoomDB where i.ID == id select i).FirstOrDefault();
query.isSync = isSync;
context.SaveChanges();
return(true);
}
} catch { return(false); }
}
public static bool Insert(Guid id, Guid rc, Guid mt, string Text, bool isSync, Guid senderID)
{
try {
using (var context = new UploadersContext()) {
var model = CloudMessagingConversationVM.Set(id, rc, mt, Text, isSync, senderID);
context.CloudMessagingConversationDB.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 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 cid, Guid apiKEY, DateTime dStart, DateTime dEnd)
{
try {
using (var context = new UploadersContext()) {
var model = CompanyAPIKeyVM.Set(id, cid, apiKEY, dStart, dEnd);
context.CompanyAPIKeyDB.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); }
}
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 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, 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 Insert(Guid id, string name, Guid api, DateTime createdAt)
{
try {
using (var context = new UploadersContext()) {
var model = MessagingRoomVM.set(id, name, api, createdAt);
context.MessagingRoomDB.Add(model);
context.SaveChanges();
return(true);
}
} catch { return(false); }
}
public static bool Update(Guid id, Guid sid, bool isActive)
{
try {
using (var context = new UploadersContext()) {
var query = (from i in context.UserInformationDB where i.ID == id select i).FirstOrDefault();
query.SignalRID = sid;
query.isActive = isActive;
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.MessagingRoomParticipantsDB where i.ID == id select i).FirstOrDefault();
//invoke signalR hub that someone is leaving the room
MessagingAppHub.LeaveRoom(query.RoomID.ToString(), query.UserID, query.API.ToString());
context.MessagingRoomParticipantsDB.Remove(query);
context.SaveChanges();
return(true);
}
} catch { return(false); }
}
public static bool Insert(Guid id, string text, Guid messageType, string senderID, Guid roomID, DateTime createdAt)
{
try
{
using (var context = new UploadersContext())
{
var model = MessagingConversationVM.set(id, text, messageType, senderID, roomID, createdAt);
context.MessagingConversationDB.Add(model);
context.SaveChanges();
return(true);
}
}
catch { return(false); }
}
public static bool Insert(Guid id, Guid api, Guid oid, string source)
{
try
{
var data = ImageLinkStorageVM.Set(id, api, oid, source);
using (var context = new UploadersContext())
{
context.ImageLinkStorageDB.Add(data);
context.SaveChanges();
return(true);
}
}
catch { return(false); }
}
public static bool Remove(Guid id, Guid api, Guid oid)
{
try
{
using (var context = new UploadersContext())
{
var query = (from i in context.ImageLinkStorageDB where i.ID == id && i.API == api && i.OwnerID == oid select i).FirstOrDefault();
context.ImageLinkStorageDB.Remove(query);
context.SaveChanges();
return(true);
}
}
catch { return(false); }
}
public static bool UpdateSyncStatus(Guid id, int mode, bool isSync)
{
try {
using (var context = new UploadersContext()) {
//receiver update
var query = (from i in context.CloudMessagingRoomDB where i.ID == id select i).FirstOrDefault();
if (mode == 1)
{
query.isSync = isSync;
}
else
{
//sender update
query.isSync = isSync;
}
context.SaveChanges();
return(true);
}
} catch { return(false); }
}
