public int Delete(StrataBoardModel objectModel) { int count = -1; // check the user exists on this strata, if exists then return... if (context.tblUserClients.Any(o => o.StratasBoardId == objectModel.StratasBoardId && o.RoleName.ToLower() != "a")) { count = -2; return(count); } // Delete the users on this strata if (context.tblUserClients.Any(x => x.StratasBoardId == objectModel.StratasBoardId)) { context.tblUserClients.RemoveRange(context.tblUserClients.Where(x => x.StratasBoardId == objectModel.StratasBoardId)); context.SaveChanges(); count = 0; } // Delete the subscription details on this strata if (context.tblStratasBoardSubscriptions.Any(x => x.StratasBoardId == objectModel.StratasBoardId)) { context.tblStratasBoardSubscriptions.RemoveRange(context.tblStratasBoardSubscriptions.Where(x => x.StratasBoardId == objectModel.StratasBoardId)); context.SaveChanges(); count = 0; } tblStratasBoard tblStratasBoardDb = new tblStratasBoard(); tblStratasBoardDb.StratasBoardId = objectModel.StratasBoardId; context.Entry(tblStratasBoardDb).State = EntityState.Deleted; count = context.SaveChanges(); if (count == 1) { count = 0; } else { count = -1; } return(count); }
public int ActDeact(StrataBoardModel objectModel) { tblStratasBoard tblStratasBoardDb = new tblStratasBoard(); tblStratasBoardDb.StratasBoardId = objectModel.StratasBoardId; tblStratasBoardDb.Status = objectModel.Status; context.tblStratasBoards.Attach(tblStratasBoardDb); context.Entry(tblStratasBoardDb).Property(x => x.Status).IsModified = true; int count = context.SaveChanges(); if (count == 1) { count = 0; } else { count = -1; } 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); }