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 long update(StrataBoardModel objectModel)
{
long count = -2;
long stratasBoardId = 0;
long userClientId = 0;
if (objectModel.StratasBoardId > 0)
{
using (var transaction = context.Database.BeginTransaction())
{
try
{
// Table StratasBoard
tblStratasBoard tblStratasBoardDb = new tblStratasBoard();
tblStratasBoardDb.StratasBoardId = objectModel.StratasBoardId;
tblStratasBoardDb.StratasBoardName = objectModel.StratasBoardName;
tblStratasBoardDb.BuildingName = objectModel.BuildingName;
tblStratasBoardDb.PortalLink = objectModel.PortalLink.Trim();
tblStratasBoardDb.Status = objectModel.Status;
tblStratasBoardDb.ModifiedBy = AdminSessionData.AdminUserId;
tblStratasBoardDb.ModifiedOn = DateTime.UtcNow;
tblStratasBoardDb.ModifiedFromIP = HttpContext.Current.Request.UserHostAddress;
if (objectModel.PortalLink == objectModel.RequestPortalLink)
{
tblStratasBoardDb.RequestCounter = 1;
}
context.tblStratasBoards.Attach(tblStratasBoardDb);
context.Entry(tblStratasBoardDb).Property(x => x.StratasBoardName).IsModified = true;
context.Entry(tblStratasBoardDb).Property(x => x.BuildingName).IsModified = true;
context.Entry(tblStratasBoardDb).Property(x => x.PortalLink).IsModified = true;
context.Entry(tblStratasBoardDb).Property(x => x.Status).IsModified = true;
context.Entry(tblStratasBoardDb).Property(x => x.ModifiedBy).IsModified = true;
context.Entry(tblStratasBoardDb).Property(x => x.ModifiedOn).IsModified = true;
context.Entry(tblStratasBoardDb).Property(x => x.ModifiedFromIP).IsModified = true;
context.Entry(tblStratasBoardDb).Property(x => x.RequestCounter).IsModified = true;
// Table UserClient
count = context.SaveChanges();
if (count >= 0)
{
tblUserClient tblUserClientDb = new tblUserClient();
tblUserClientDb.UserClientId = objectModel.UserClientId;
tblUserClientDb.FirstName = objectModel.FirstName;
tblUserClientDb.LastName = objectModel.LastName;
tblUserClientDb.EmailId = objectModel.EmailId;
tblUserClientDb.ContactNumber = objectModel.ContactNumber;
tblUserClientDb.ModifiedBy = AdminSessionData.AdminUserId;
tblUserClientDb.ModifiedOn = DateTime.UtcNow;
tblUserClientDb.ModifiedFromIP = HttpContext.Current.Request.UserHostAddress;
context.tblUserClients.Attach(tblUserClientDb);
context.Entry(tblUserClientDb).Property(x => x.FirstName).IsModified = true;
context.Entry(tblUserClientDb).Property(x => x.LastName).IsModified = true;
//context.Entry(tblUserClientDb).Property(x => x.EmailId).IsModified = true;
context.Entry(tblUserClientDb).Property(x => x.ContactNumber).IsModified = true;
context.Entry(tblUserClientDb).Property(x => x.ModifiedBy).IsModified = true;
context.Entry(tblUserClientDb).Property(x => x.ModifiedOn).IsModified = true;
context.Entry(tblUserClientDb).Property(x => x.ModifiedFromIP).IsModified = true;
count = context.SaveChanges();
if (count >= 0)
{
transaction.Commit();
count = objectModel.StratasBoardId;
}
else
{
transaction.Rollback();
count = -2; // any error is there
}
}
else
{
transaction.Rollback();
count = -2; // any error is there
}
}
catch (Exception ex)
{
new AppError().LogMe(ex);
transaction.Rollback();
count = -2; // any error is there
}
}
}
else
{
using (var transaction = context.Database.BeginTransaction())
{
var subscriptionDetails = context.tblSubscriptions.Where(x => x.SubscriptionId == objectModel.SubscriptionId).FirstOrDefault();
try
{
// Table StratasBoard
tblStratasBoard tblStratasBoardDb = new tblStratasBoard();
tblStratasBoardDb.StratasBoardName = objectModel.StratasBoardName;
tblStratasBoardDb.BuildingName = objectModel.BuildingName;
tblStratasBoardDb.PortalLink = objectModel.PortalLink;
tblStratasBoardDb.CreatedBy = AdminSessionData.AdminUserId;
tblStratasBoardDb.CreatedOn = DateTime.UtcNow;
tblStratasBoardDb.CreatedFromIP = HttpContext.Current.Request.UserHostAddress;
tblStratasBoardDb.Status = objectModel.Status;
context.tblStratasBoards.Add(tblStratasBoardDb);
context.SaveChanges();
stratasBoardId = tblStratasBoardDb.StratasBoardId;
if (stratasBoardId > 0)
{
// Table UserClient
tblUserClient tblUserClientDb = new tblUserClient();
tblUserClientDb.FirstName = objectModel.FirstName;
tblUserClientDb.LastName = objectModel.LastName;
tblUserClientDb.EmailId = objectModel.EmailId;
tblUserClientDb.Password = AppLogic.EncryptPassword();
tblUserClientDb.ContactNumber = objectModel.ContactNumber;
tblUserClientDb.StratasBoardId = stratasBoardId;
tblUserClientDb.RoleName = "A"; // StratasBoard Admin
tblUserClientDb.IsEmailNotification = true;
tblUserClientDb.IsSMSNotification = true;
tblUserClientDb.IsProfileComplete = false;
tblUserClientDb.Status = 1; // It will be active in both the cases
tblUserClientDb.CreatedBy = AdminSessionData.AdminUserId;
tblUserClientDb.CreatedOn = DateTime.UtcNow;
tblUserClientDb.LastLogin = DateTime.UtcNow;
tblUserClientDb.CurrentLogin = DateTime.UtcNow;
tblUserClientDb.CreatedFromIP = HttpContext.Current.Request.UserHostAddress;
context.tblUserClients.Add(tblUserClientDb);
context.SaveChanges();
userClientId = tblUserClientDb.UserClientId;
if (userClientId > 0)
{
// Table StratasBoard Subscription
tblStratasBoardSubscription tblStratasBoardSubscriptionDb = new tblStratasBoardSubscription();
tblStratasBoardSubscriptionDb.StratasBoardId = 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();
int stratasBoardSubscriptionId = tblStratasBoardSubscriptionDb.StratasBoardSubscriptionId;
if (stratasBoardSubscriptionId > 0)
{
transaction.Commit();
count = stratasBoardId;
}
else
{
transaction.Rollback();
count = -2; // any error is there
}
}
else
{
transaction.Rollback();
count = -2; // any error is there
}
}
else
{
transaction.Rollback();
count = -2; // any error is there
}
}
catch (Exception ex)
{
new AppError().LogMe(ex);
transaction.Rollback();
count = -2; // any error is there
}
}
}
return(count);
}
