public static Boolean CreateNotification(NotificationMaster Notify) { Boolean flag = false; if (!(IsExistingNotification(Notify))) { using (TransactionScope scope = new TransactionScope()) { using (var context = new SycousCon()) { try { context.NotificationMasters.AddObject(Notify); context.SaveChanges(); scope.Complete(); context.AcceptAllChanges(); flag = true; } catch (Exception ex) { context.Dispose(); throw; } }// }// using }//if return flag; }
public static NotificationMaster EditNotification(Int32 NotifyID) { NotificationMaster Notify = new NotificationMaster(); using (var context = new SycousCon()) { try { Notify = context.NotificationMasters.SingleOrDefault(s => s.NotificationID == NotifyID); } catch (Exception ex) { context.Dispose(); throw; } } return Notify; }
public bool CreateRecord(Object notify) { Boolean flag = false; Notifycation Notify = (Notifycation)notify; try { NotificationMaster _Notify = new NotificationMaster(); if (Notify.ClientID != null) { _Notify.ClientID = Notify.ClientID; } if (Notify.SiteID != null) { _Notify.SiteID = Notify.SiteID; } if (Notify.NotificationName != null) { _Notify.NotificationName = Notify.NotificationName.Trim(); } if (Notify.TypeID != null) { _Notify.Type = Convert.ToInt32(Notify.TypeID); } //if (Notify.Days != null) //{ // _Notify.NoOfDays = Convert.ToInt32(Notify.Days); // if (_Notify.NoOfDays < 30) // { // if (Notify.NotificationDay != null) // { // _Notify.NotificationDay = Notify.NotificationDay; // } // } // else // { // if (Notify.NotificationDate != null) // { // _Notify.NotificationDate =BAL.Common.DateGB( Notify.NotificationDay.ToString()); // } // } //}// if (Notify.NotificationDay != null) { _Notify.NotificationDay = Notify.NotificationDay; } if (Notify.DayOfMonth != null) { _Notify.DayOfMonth = Notify.DayOfMonth.Trim(); } if (!String.IsNullOrEmpty(Notify.SelectNotificationMode)) { _Notify.NotificationMode = Convert.ToInt32(Notify.SelectNotificationMode); } _Notify.CreateBy = Notify.CreateBy; _Notify.CreateDate = DateTime.Now; if (_Notify.NotificationName != null) { flag = DAL.DALNotification.CreateNotification(_Notify); } } catch (Exception ex) { throw; } return flag; }
public static bool IsExistingNotification(NotificationMaster notify) { using (var context = new SycousCon()) { try { NotificationMaster objNotify = context.NotificationMasters.SingleOrDefault(p => p.NotificationName.ToUpper() == notify.NotificationName.ToUpper() && p.Type == notify.Type && p.ClientID == notify.ClientID && p.SiteID == notify.SiteID && p.DeleteStatus==0); if (objNotify != null) { return true; } else { return false; } } catch (Exception ex) { context.Dispose(); throw; } } }
public static Boolean UpdateNotification(NotificationMaster Notify) { using (TransactionScope scope = new TransactionScope()) { Boolean bol = false; using (var context = new SycousCon()) { try { var Update = context.NotificationMasters.Where(c => c.NotificationID == Notify.NotificationID); foreach (NotificationMaster p in Update) { if (Notify.NotificationName != null) { p.NotificationName = Notify.NotificationName; } if (Notify.Type != null) { p.Type = Notify.Type; } if (Notify.NoOfDays != null) { p.NoOfDays = Notify.NoOfDays; } if (Notify.ClientID != null) { p.ClientID = Notify.ClientID; } if (Notify.SiteID != null) { p.SiteID = Notify.SiteID; } if (Notify.NotificationMode != null) { p.NotificationMode = Notify.NotificationMode; } if (Notify.NotificationDay != null) { p.NotificationDay = Notify.NotificationDay; } else { p.NotificationDay = null; } if (Notify.DayOfMonth != null) { p.DayOfMonth = Notify.DayOfMonth; } else { p.DayOfMonth = null; } p.Modifydate = Notify.Modifydate; p.ModifyBy = Notify.ModifyBy; }// context.SaveChanges(); context.AcceptAllChanges(); scope.Complete(); context.Dispose(); bol = true; } catch (Exception ex) { context.Dispose(); throw; } }// using return bol; } //trans }
/// <summary> /// Deprecated Method for adding a new object to the NotificationMasters EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToNotificationMasters(NotificationMaster notificationMaster) { base.AddObject("NotificationMasters", notificationMaster); }
/// <summary> /// Create a new NotificationMaster object. /// </summary> /// <param name="notificationID">Initial value of the NotificationID property.</param> /// <param name="deleteStatus">Initial value of the DeleteStatus property.</param> public static NotificationMaster CreateNotificationMaster(global::System.Int32 notificationID, global::System.Int32 deleteStatus) { NotificationMaster notificationMaster = new NotificationMaster(); notificationMaster.NotificationID = notificationID; notificationMaster.DeleteStatus = deleteStatus; return notificationMaster; }