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));
}
