public int CreateNotification(NotificationModel nm) { int result = DaoUtilities.NO_CHANGES; NOTIFICATION n = db.NOTIFICATION.Create(); n.NOTIF_ID = nm.NotificationId; n.NOTIF_NAME = nm.Title; n.NOTIF_MESSAGE = nm.Message; n.NOTIF_DATE = nm.NotifDate; n.NOTIF_USERID = nm.UserId; db.NOTIFICATION.Add(n); try { int saveResult = db.SaveChanges(); if (saveResult == 1) result = DaoUtilities.SAVE_SUCCESSFUL; } catch (DbUpdateConcurrencyException e) { Console.WriteLine(e.GetBaseException().ToString()); result = DaoUtilities.UPDATE_CONCURRENCY_EXCEPTION; } catch (DbUpdateException e) { Console.WriteLine(e.GetBaseException().ToString()); result = DaoUtilities.UPDATE_EXCEPTION; } catch (DbEntityValidationException e) { Console.WriteLine(e.GetBaseException().ToString()); result = DaoUtilities.ENTITY_VALIDATION_EXCEPTION; } catch (NotSupportedException e) { Console.WriteLine(e.GetBaseException().ToString()); result = DaoUtilities.UNSUPPORTED_EXCEPTION; } catch (ObjectDisposedException e) { Console.WriteLine(e.GetBaseException().ToString()); result = DaoUtilities.DISPOSED_EXCEPTION; } catch (InvalidOperationException e) { Console.WriteLine(e.GetBaseException().ToString()); result = DaoUtilities.INVALID_OPERATION_EXCEPTION; } return result; }
public int DeleteNotification(NotificationModel nm) { int result = DaoUtilities.NO_CHANGES; NOTIFICATION n = db.NOTIFICATION.Find(nm.NotificationId); if (n != null) { db.NOTIFICATION.Remove(n); try { int saveResult = db.SaveChanges(); if (saveResult == 1) result = DaoUtilities.SAVE_SUCCESSFUL; } catch (DbUpdateConcurrencyException e) { Console.WriteLine(e.GetBaseException().ToString()); result = DaoUtilities.UPDATE_CONCURRENCY_EXCEPTION; } catch (DbUpdateException e) { Console.WriteLine(e.GetBaseException().ToString()); result = DaoUtilities.UPDATE_EXCEPTION; } catch (DbEntityValidationException e) { Console.WriteLine(e.GetBaseException().ToString()); result = DaoUtilities.ENTITY_VALIDATION_EXCEPTION; } catch (NotSupportedException e) { Console.WriteLine(e.GetBaseException().ToString()); result = DaoUtilities.UNSUPPORTED_EXCEPTION; } catch (ObjectDisposedException e) { Console.WriteLine(e.GetBaseException().ToString()); result = DaoUtilities.DISPOSED_EXCEPTION; } catch (InvalidOperationException e) { Console.WriteLine(e.GetBaseException().ToString()); result = DaoUtilities.INVALID_OPERATION_EXCEPTION; } } return result; }
/// <summary> /// Convert a notification from the database to a NotificatiobModel /// </summary> /// <param name="n"></param> /// <returns></returns> public NotificationModel ConvertNotificationToNotificatiobModel(NOTIFICATION n) { NotificationModel nm = new NotificationModel(); if (n != null) { nm.NotificationId = n.NOTIF_ID; nm.Title = n.NOTIF_NAME; nm.Message = n.NOTIF_MESSAGE; nm.NotifDate = n.NOTIF_DATE; nm.UserId = n.NOTIF_USERID; } else nm = null; return nm; }