public int Delete(SubscriptionModel subscriptionModel) { int count = -2; // check the subscription associated with strata, if exists then return... if (context.tblStratasBoardSubscriptions.Any(o => o.SubscriptionId == subscriptionModel.SubscriptionId)) { return(count); } tblSubscription tblSubscriptionDb = new tblSubscription(); tblSubscriptionDb.SubscriptionId = subscriptionModel.SubscriptionId; context.Entry(tblSubscriptionDb).State = EntityState.Deleted; count = context.SaveChanges(); if (count == 1) { count = 0; } else { count = -1; } return(count); }
public int update(SubscriptionModel subscriptionModel) { tblSubscription tblSubscriptionDb = new tblSubscription(); tblSubscriptionDb.SubscriptionId = subscriptionModel.SubscriptionId; tblSubscriptionDb.SubscriptionName = subscriptionModel.SubscriptionName; tblSubscriptionDb.Validity = subscriptionModel.Validity; tblSubscriptionDb.AllowedUser = subscriptionModel.AllowedUser; tblSubscriptionDb.IsSmsForAlert = subscriptionModel.IsSmsForAlert; tblSubscriptionDb.IsSmsForReminder = subscriptionModel.IsSmsForReminder; tblSubscriptionDb.Status = subscriptionModel.Status; if (subscriptionModel.SubscriptionId > 0) { tblSubscriptionDb.ModifiedBy = AdminSessionData.AdminUserId; tblSubscriptionDb.ModifiedOn = DateTime.Now; tblSubscriptionDb.ModifiedFromIP = HttpContext.Current.Request.UserHostAddress; context.tblSubscriptions.Attach(tblSubscriptionDb); context.Entry(tblSubscriptionDb).Property(x => x.SubscriptionName).IsModified = true; context.Entry(tblSubscriptionDb).Property(x => x.Validity).IsModified = true; context.Entry(tblSubscriptionDb).Property(x => x.AllowedUser).IsModified = true; context.Entry(tblSubscriptionDb).Property(x => x.IsSmsForAlert).IsModified = true; context.Entry(tblSubscriptionDb).Property(x => x.IsSmsForReminder).IsModified = true; context.Entry(tblSubscriptionDb).Property(x => x.Status).IsModified = true; context.Entry(tblSubscriptionDb).Property(x => x.ModifiedBy).IsModified = true; context.Entry(tblSubscriptionDb).Property(x => x.ModifiedOn).IsModified = true; context.Entry(tblSubscriptionDb).Property(x => x.ModifiedFromIP).IsModified = true; } else { tblSubscriptionDb.CreatedBy = AdminSessionData.AdminUserId; tblSubscriptionDb.CreatedOn = DateTime.Now; tblSubscriptionDb.CreatedFromIP = HttpContext.Current.Request.UserHostAddress; context.tblSubscriptions.Add(tblSubscriptionDb); } int count = context.SaveChanges(); if (count == 1) { count = 0; } else { count = -1; } return(count); }
public int ActDeact(SubscriptionModel subscriptionModel) { tblSubscription tblSubscriptionDb = new tblSubscription(); tblSubscriptionDb.SubscriptionId = subscriptionModel.SubscriptionId; tblSubscriptionDb.Status = subscriptionModel.Status; context.tblSubscriptions.Attach(tblSubscriptionDb); context.Entry(tblSubscriptionDb).Property(x => x.Status).IsModified = true; int count = context.SaveChanges(); if (count == 1) { count = 0; } else { count = -1; } return(count); }