public ActionResult AddSubscription(long?Id) { RenewSubscriptionModel subscriptionModel = new RenewSubscriptionModel(); subscriptionModel.StratasBoardId = Id.Value; return(View(subscriptionModel)); }
public int RenewSubscription(RenewSubscriptionModel objectModel) { int count = -1; int totalStrataUser = CommonData.GetStratasBoardTotalUser(objectModel.StratasBoardId); var subscriptionDetails = context.tblSubscriptions.Where(x => x.SubscriptionId == objectModel.SubscriptionId).FirstOrDefault(); if (totalStrataUser > subscriptionDetails.AllowedUser) { // Strata User are more than subscription package allowed user. count = -1; return(count); } try { // Table subscription update for previous added subscription context.tblStratasBoardSubscriptions .Where(x => x.StratasBoardId == objectModel.StratasBoardId) .ToList() .ForEach(a => a.Status = 0); count = context.SaveChanges(); if (count >= 0) { // Table StratasBoard Subscription tblStratasBoardSubscription tblStratasBoardSubscriptionDb = new tblStratasBoardSubscription(); tblStratasBoardSubscriptionDb.StratasBoardId = objectModel.StratasBoardId; tblStratasBoardSubscriptionDb.SubscriptionId = objectModel.SubscriptionId; tblStratasBoardSubscriptionDb.Validity = subscriptionDetails.Validity; tblStratasBoardSubscriptionDb.IsSmsForAlert = subscriptionDetails.IsSmsForAlert; tblStratasBoardSubscriptionDb.IsSmsForReminder = subscriptionDetails.IsSmsForReminder; tblStratasBoardSubscriptionDb.AllowedUser = subscriptionDetails.AllowedUser; tblStratasBoardSubscriptionDb.ExpiryDate = AppLogic.CalculateSubscriptionExpiryDate(DateTime.UtcNow, subscriptionDetails.Validity); tblStratasBoardSubscriptionDb.CreatedBy = AdminSessionData.AdminUserId; tblStratasBoardSubscriptionDb.CreatedOn = DateTime.UtcNow; tblStratasBoardSubscriptionDb.Status = 1; context.tblStratasBoardSubscriptions.Add(tblStratasBoardSubscriptionDb); context.SaveChanges(); if (tblStratasBoardSubscriptionDb.StratasBoardSubscriptionId > 0) { count = tblStratasBoardSubscriptionDb.StratasBoardSubscriptionId; } else { count = -2; // any error is there } } } catch (Exception ex) { new AppError().LogMe(ex); count = -2; // any error is there } return(count); }
public ActionResult AddSubscription(RenewSubscriptionModel renewSubscriptionModel) { if (ModelState.IsValid) { StrataBoardHelper strataBoardHelper = new StrataBoardHelper(); int stratasBoardSubscriptionId = strataBoardHelper.RenewSubscription(renewSubscriptionModel); if (stratasBoardSubscriptionId > 0) { TempData["CommonMessage"] = AppLogic.setMessage(0, "Record updated successfully."); return(RedirectToAction("listsubscription/" + renewSubscriptionModel.StratasBoardId)); } else if (stratasBoardSubscriptionId == -1) { TempData["CommonMessage"] = AppLogic.setMessage(2, "StratasBoard Users are more than subscription package allowed user. select another subscription."); return(View(renewSubscriptionModel)); } else { TempData["CommonMessage"] = AppLogic.setMessage(2, "Error, Please try again."); return(View(renewSubscriptionModel)); } } return(View(renewSubscriptionModel)); }