public HttpResponseMessage CreateClient([FromBody] RequestImport request) { HttpResponseMessage message; var isSuccess = false; var msg = "Client Name already exists"; var name = request.Name; //validate clientno var validationResult = validateRequest(request); if (!validationResult.isSuccess) { message = Request.CreateResponse(HttpStatusCode.OK, new{ message = validationResult.message, validationResult.isSuccess }); return(message); } var clientNo = Convert.ToInt32(request.clientNo); using (EverestPortalContext context = new EverestPortalContext()) { if (!context.Clients.Any(c => c.Name.Equals(name, StringComparison.InvariantCultureIgnoreCase))) { if (!string.IsNullOrEmpty(name)) { var newClient = new Client() { Name = name, IsMyClient = false }; newClient = context.Clients.Add(newClient); context.SaveChanges(); context.ClientMaps.Add(new ClientMap { ClientId = newClient.Id, IRPClientNo = Convert.ToInt16(clientNo) }); context.SaveChanges(); isSuccess = true; msg = "Client successfully created"; } else { msg = "Enter the valid name"; } } else { msg = "Client Name already exists"; } } var result = new { message = msg, isSuccess }; message = Request.CreateResponse(HttpStatusCode.OK, result); return(message); }
public string SaveMarketBasePacks() { HttpContent requestContent = Request.Content; var jsonContent = requestContent.ReadAsStringAsync().Result; var identity = (ClaimsIdentity)User.Identity; int uid = Convert.ToInt32(identity.Claims.FirstOrDefault(c => c.Type == "userid").Value.ToString()); if (jsonContent.Trim() != string.Empty) { var marketBase = JsonConvert.DeserializeObject <MarketBase>(jsonContent); using (var db = new EverestPortalContext()) { if (marketBase.Id == 0) { marketBase.ModifiedBy = uid; marketBase.LastModified = DateTime.Now; db.MarketBases.Add(marketBase); db.SaveChanges(); } else { MarketBase marketBaseUpdate = db.MarketBases.Where(m => m.Id == marketBase.Id).SingleOrDefault(); marketBaseUpdate.Name = marketBase.Name; marketBaseUpdate.Suffix = marketBase.Suffix; marketBaseUpdate.Description = marketBase.Description; marketBaseUpdate.DurationTo = marketBase.DurationTo; marketBaseUpdate.DurationFrom = marketBase.DurationFrom; db.SaveChanges(); int filterID = marketBase.Filters[0].Id; BaseFilter baseFilterUpdate = db.BaseFilters.Where(m => m.Id == filterID).SingleOrDefault(); baseFilterUpdate.Criteria = marketBase.Filters[0].Criteria; baseFilterUpdate.IsBaseFilterType = marketBase.Filters[0].IsBaseFilterType; baseFilterUpdate.IsEnabled = marketBase.Filters[0].IsEnabled; baseFilterUpdate.IsRestricted = marketBase.Filters[0].IsRestricted; baseFilterUpdate.MarketBaseId = marketBase.Id; baseFilterUpdate.Name = marketBase.Filters[0].Name; baseFilterUpdate.Values = marketBase.Filters[0].Values; marketBaseUpdate.LastModified = DateTime.Now; marketBaseUpdate.ModifiedBy = uid; db.SaveChanges(); } } } return("saved"); }
public HttpResponseMessage UpdateListing([FromBody] Listing postedData) { HttpResponseMessage response = null; try { Listing listingToUpdate; using (EverestPortalContext readContext = new EverestPortalContext()) { listingToUpdate = readContext.Listings.Where(x => x.listingId.Equals(postedData.listingId)).FirstOrDefault <Listing>(); } if (listingToUpdate != null) { listingToUpdate.listingTitle = postedData.listingTitle; listingToUpdate.listingDescription = postedData.listingDescription; listingToUpdate.listingPharmacyFileUrl = postedData.listingPharmacyFileUrl; listingToUpdate.listingHospitalFileUrl = postedData.listingHospitalFileUrl; } using (EverestPortalContext updateContext = new EverestPortalContext()) { updateContext.Entry(listingToUpdate).State = System.Data.Entity.EntityState.Modified; updateContext.SaveChanges(); } //response = Request.CreateResponse<CADPage>(HttpStatusCode.OK,Request.RequestUri.ToString()); response = Request.CreateResponse <Listing>(HttpStatusCode.OK, postedData); } catch (Exception ex) { } return(response); }
public HttpResponseMessage UpdateNewsAlert([FromBody] NewsAlert postedData) { HttpResponseMessage response = null; try { NewsAlert naToBeUpdated; using (EverestPortalContext readContext = new EverestPortalContext()) { naToBeUpdated = readContext.NewsAlerts.Where(x => x.newsAlertId.Equals(postedData.newsAlertId)).FirstOrDefault <NewsAlert>(); } if (naToBeUpdated != null) { naToBeUpdated.newsAlertTitle = postedData.newsAlertTitle; naToBeUpdated.newsAlertDescription = postedData.newsAlertDescription; } using (EverestPortalContext updateContext = new EverestPortalContext()) { updateContext.Entry(naToBeUpdated).State = System.Data.Entity.EntityState.Modified; updateContext.SaveChanges(); } //response = Request.CreateResponse<CADPage>(HttpStatusCode.OK,Request.RequestUri.ToString()); response = Request.CreateResponse <NewsAlert>(HttpStatusCode.OK, postedData); } catch (Exception ex) { } return(response); }
public HttpResponseMessage updateDeliverable([FromBody] DeliverableModel request) { HttpResponseMessage responseMessage; var message = "deliverable successfully updated"; var isSuccess = false; using (EverestPortalContext context = new EverestPortalContext()) { var updateDeliverable = context.deliverables.FirstOrDefault(d => d.DeliverableId == request.DeliverableId); updateDeliverable.ReportWriterId = request.ReportWriterId; updateDeliverable.StartDate = new DateTime(request.StartDate.Year, request.StartDate.Month, 1); //change into first day of the month updateDeliverable.EndDate = new DateTime(request.EndDate.Year, request.EndDate.Month, DateTime.DaysInMonth(request.EndDate.Year, request.EndDate.Month)); //change into last day of the month updateDeliverable.FrequencyTypeId = request.FrequencyTypeId; updateDeliverable.FrequencyId = request.FrequencyId; updateDeliverable.RestrictionId = request.RestrictionId; updateDeliverable.PeriodId = request.PeriodId; updateDeliverable.LastModified = DateTime.Now; updateDeliverable.ModifiedBy = 1; context.SaveChanges(); isSuccess = true; } var response = new { msg = message, isSuccess }; responseMessage = Request.CreateResponse(HttpStatusCode.OK, response); return(responseMessage); }
public HttpResponseMessage UpdateMonthlyNewProducts([FromBody] MonthlyNewProduct postedData) { HttpResponseMessage response = null; try { MonthlyNewProduct mdpToUpdate; using (EverestPortalContext readContext = new EverestPortalContext()) { mdpToUpdate = readContext.MonthlyNewProducts.Where(x => x.monthlyNewProductId.Equals(postedData.monthlyNewProductId)).FirstOrDefault <MonthlyNewProduct>(); } if (mdpToUpdate != null) { mdpToUpdate.monthlyNewProductTitle = postedData.monthlyNewProductTitle; mdpToUpdate.monthlyNewProductDescription = postedData.monthlyNewProductDescription; } using (EverestPortalContext updateContext = new EverestPortalContext()) { updateContext.Entry(mdpToUpdate).State = System.Data.Entity.EntityState.Modified; updateContext.SaveChanges(); } //response = Request.CreateResponse<CADPage>(HttpStatusCode.OK,Request.RequestUri.ToString()); response = Request.CreateResponse <MonthlyNewProduct>(HttpStatusCode.OK, postedData); } catch (Exception ex) { } return(response); }
/// <summary> /// adds the new users and clients to userClients /// </summary> /// <param name="users"></param> /// <param name="clients"></param> private static void Allocate(IEnumerable <int> users, IEnumerable <int> clients, int actionUser) { using (EverestPortalContext context = new EverestPortalContext()) { foreach (var userId in users) { foreach (var clientId in clients) { if (!context.userClient.Any(x => (x.UserID == userId && x.ClientID == clientId)))//Checks If already User Assigned to Client { context.userClient.Add(new UserClient { UserID = userId, ClientID = clientId }); } } ; } context.SaveChanges(); foreach (var userId in users) { var objClient = context.Users.SingleOrDefault(p => p.UserID == userId); IAuditLog log = AuditFactory.GetInstance(typeof(User).Name); log.SaveVersion <User>(objClient, actionUser); } } }
private static void AllocatePacks(IEnumerable <ReleaseClient> clients, IEnumerable <ReleasePack> packs) { using (EverestPortalContext context = new EverestPortalContext()) { foreach (var client in clients) { foreach (var pack in packs) { var updateClientException = context.ClientPackException.FirstOrDefault(x => (x.ClientId == client.clientId && x.PackExceptionId == pack.Id)); if (updateClientException != null) { updateClientException.ProductLevel = pack.ProductLevel; } else { context.ClientPackException.Add(new ClientPackException { ClientId = client.clientId, PackExceptionId = pack.Id, ProductLevel = pack.ProductLevel, ExpiryDate = new DateTime(DateTime.Now.Year, 12, 31)//last day of th year }); } } ; } context.SaveChanges(); } }
private static void updateCLientReleases(IEnumerable <ReleaseClient> clients) { using (EverestPortalContext context = new EverestPortalContext()) { foreach (var client in clients) { var updateClient = context.ClientRelease.SingleOrDefault(x => x.ClientId == client.clientId); if (updateClient != null) { updateClient.CapitalChemist = client.CapitalChemist; updateClient.OneKey = client.OneKey; updateClient.Census = client.Census; } else { context.ClientRelease.Add(new ClientRelease { ClientId = client.clientId, CapitalChemist = client.CapitalChemist, OneKey = client.OneKey, Census = client.Census }); } } context.SaveChanges(); } }
public string LockHistories(int UserId, int DefId, string DocType, string LockType, string Status) { List <LockHistory> lockHistory = new List <LockHistory>(); DateTime currentDatetime = DateTime.Now; lockHistory = _db.Database.SqlQuery <LockHistory>("Select *,'' as UserName from LockHistories Where DefId='" + DefId + "' and UserId='" + UserId + "' and DocType='" + DocType + "' and LockType='" + LockType + "' and Status='Active'").ToList(); //lockHistory.Add(new LockHistory { Id = 1, UserId= UserId, DefId= DefId,DocType= DocType, LockType= LockType,Status= "Active", LockTime= DateTime.Now}); if (lockHistory.Count() > 0) { _db.Database.ExecuteSqlCommand("Update LockHistories set LockTime='" + currentDatetime + "' Where DefId='" + DefId + "' and UserId='" + UserId + "' and DocType='" + DocType + "' and Status='Active'"); } else { _db.LockHistories.Add(new LockHistory { Id = 1, UserId = UserId, DefId = DefId, DocType = DocType, LockType = LockType, Status = "Active", LockTime = currentDatetime, ReleaseTime = null }); _db.SaveChanges(); } var json = JsonConvert.SerializeObject(lockHistory, Formatting.Indented, new JsonSerializerSettings { ReferenceLoopHandling = ReferenceLoopHandling.Ignore }); return(json); }
public HttpResponseMessage MapECPClientsWithIRP(string clientName) { HttpResponseMessage message; using (EverestPortalContext context = new EverestPortalContext()) { var clients = (from irpclient in context.IRPClients where irpclient.VersionTo == 32767 && irpclient.ClientName == clientName select new { clientId = irpclient.ClientID, clientName = irpclient.ClientName, clientNo = irpclient.ClientNo }).ToList(); foreach (var IRPClient in clients) { context.IRPClientMaps.Add(new IRPClientMap { IRPClientID = IRPClient.clientId, IRPClientNo = IRPClient.clientNo }); } context.SaveChanges(); message = Request.CreateResponse(HttpStatusCode.OK); return(message); } }
public HttpResponseMessage DeleteCADPage(int Id) { HttpResponseMessage response; CADPage cadPageToDelete; try { using (EverestPortalContext context = new EverestPortalContext()) { cadPageToDelete = context.CADPages.Where(x => x.cadPageId.Equals(Id)).FirstOrDefault <CADPage>(); if (cadPageToDelete != null) { context.CADPages.Remove(cadPageToDelete); context.SaveChanges(); } } response = Request.CreateResponse(HttpStatusCode.NoContent); } catch (Exception ex) { throw; } return(response); }
public HttpResponseMessage PutCADPage([FromBody] CADPage postedData) { HttpResponseMessage response = null; try { CADPage cadPageToUpdate; using (EverestPortalContext readContext = new EverestPortalContext()) { cadPageToUpdate = readContext.CADPages.Where(x => x.cadPageId.Equals(postedData.cadPageId)).FirstOrDefault <CADPage>(); } if (cadPageToUpdate != null) { cadPageToUpdate.cadPageTitle = postedData.cadPageTitle; cadPageToUpdate.cadPageDescription = postedData.cadPageDescription; cadPageToUpdate.cadPagePharmacyFileUrl = postedData.cadPagePharmacyFileUrl; cadPageToUpdate.cadPageHospitalFileUrl = postedData.cadPageHospitalFileUrl; } using (EverestPortalContext updateContext = new EverestPortalContext()) { updateContext.Entry(cadPageToUpdate).State = System.Data.Entity.EntityState.Modified; updateContext.SaveChanges(); } //response = Request.CreateResponse<CADPage>(HttpStatusCode.OK,Request.RequestUri.ToString()); response = Request.CreateResponse <CADPage>(HttpStatusCode.OK, postedData); } catch (Exception ex) { } return(response); }
public HttpResponseMessage AddCADPage([FromBody] CADPage postedData) { HttpResponseMessage response = null; try { CADPage newCADPageEntry = new CADPage(); newCADPageEntry.cadPageTitle = postedData.cadPageTitle; newCADPageEntry.cadPageDescription = postedData.cadPageDescription; newCADPageEntry.cadPagePharmacyFileUrl = postedData.cadPagePharmacyFileUrl; newCADPageEntry.cadPageHospitalFileUrl = postedData.cadPageHospitalFileUrl; using (EverestPortalContext context = new EverestPortalContext()) { context.CADPages.Add(newCADPageEntry); context.SaveChanges(); } response = Request.CreateResponse <CADPage>(HttpStatusCode.Created, newCADPageEntry); } catch (Exception ex) { } return(response); }
public string GenerateHashedResetToken(int userid) { string salt = System.Web.Security.Membership.GeneratePassword(6, 2); string token = ComputeHash(userid.ToString(), salt); int resetTokenExpiryAge = 1; if (ConfigurationManager.AppSettings["ResetTokenExpiryAge"] != null) { resetTokenExpiryAge = Convert.ToInt32(ConfigurationManager.AppSettings["ResetTokenExpiryAge"]); } using (EverestPortalContext context = new EverestPortalContext()) { var today = DateTime.Now; var resetTokens = context.ResetTokens.Where(r => r.UserID == userid && r.ExpiryDate >= today).Select(x => x).ToList(); if (resetTokens != null) { foreach (var item in resetTokens) { item.ExpiryDate = DateTime.Now; } } context.ResetTokens.Add( new ResetToken { UserID = userid, Token = token, ExpiryDate = DateTime.Now.AddDays(resetTokenExpiryAge) }); context.SaveChanges(); } return(token); }
public async Task <string> SaveMarketBase(int ClientId) { AuthController objAuth = new AuthController(); if (objAuth.CheckUserClients(ClientId) == 0) { return(""); } HttpContent requestContent = Request.Content; var jsonContent = requestContent.ReadAsStringAsync().Result; Guid Id = Guid.NewGuid(); if (jsonContent.Trim() != string.Empty) { var marketBaseDetails = JsonConvert.DeserializeObject <MarketbaseDetails>(jsonContent); List <DimensionBaseMap> Dimension = marketBaseDetails.Dimension; //to get dimension seperatly. List <PxR> PxRCollection = marketBaseDetails.PxR; //to get dimension seperatly. MarketBase marketBase = marketBaseDetails.MarketBase; marketBase.GuiId = Id.ToString(); marketBase.LastSaved = DateTime.Now; using (var db = new EverestPortalContext()) { db.MarketBases.Add(marketBase); db.SaveChanges(); //to update new marketbase Id await SaveDimensionBaseMap(marketBase.Id, Dimension); await SavePxRBaseMap(marketBase.Id, PxRCollection); } } var objClient = _db.MarketBases.Where(u => u.GuiId == Id.ToString()).ToList <MarketBase>(); ClientMarketBases clientMarketBases = new ClientMarketBases(); clientMarketBases.ClientId = ClientId; clientMarketBases.MarketBaseId = objClient.First().Id; using (var db = new EverestPortalContext()) { db.ClientMarketBases.Add(clientMarketBases); db.SaveChanges(); } //to create new version SubmitMarketbaseDetailsInformation(clientMarketBases.MarketBaseId); var json = JsonConvert.SerializeObject(objClient, Formatting.Indented, new JsonSerializerSettings { ReferenceLoopHandling = ReferenceLoopHandling.Ignore }); return(json); }
public HttpResponseMessage CreateSubscriptions([FromBody] SubscriptionModel request) { HttpResponseMessage responseMessage; var message = "subscription successfully created for the selected client"; var isSuccess = false; //replaces with PROFITS with Profit for subscription name convention if (request.Name.IndexOf("PROFITS", StringComparison.InvariantCultureIgnoreCase) > 0) { request.Name = request.Name.Replace("PROFITS", "Profit"); } using (EverestPortalContext context = new EverestPortalContext()) { //check subscription exists for the client if (context.subscription.Any(x => (x.ClientId == request.ClientId && x.Name.Equals(request.Name, StringComparison.InvariantCultureIgnoreCase)))) { message = "subscriptions already exists for the selected client"; isSuccess = false; } else { //adding the new subscriptions to the selected clients var aSubscription = new Subscription() { ClientId = request.ClientId, Name = request.Name, StartDate = new DateTime(request.StartDate.Year, request.StartDate.Month, 1), //change into first day of the month EndDate = new DateTime(request.EndDate.Year, request.EndDate.Month, DateTime.DaysInMonth(request.EndDate.Year, request.EndDate.Month)), //change into last day of the month ServiceTerritoryId = request.ServiceTerritoryId, Active = true, LastModified = DateTime.Now, ModifiedBy = 1, CountryId = request.CountryId, ServiceId = request.ServiceId, SourceId = request.SourceId, DataTypeId = request.DataTypeId }; context.subscription.Add(aSubscription); context.SaveChanges(); isSuccess = true; } } var response = new { msg = message, isSuccess }; responseMessage = Request.CreateResponse(HttpStatusCode.OK, response); return(responseMessage); }
public async Task <HttpResponseMessage> SaveMarketGroupDetails(int MarketDefId, int ClientId) { HttpContent requestContent = Request.Content; string jsonContent = requestContent.ReadAsStringAsync().Result; var marketDefinitionDetails = JsonConvert.DeserializeObject <MarketDefinitionDetails>(jsonContent); MarketDefinition marketDefinition = marketDefinitionDetails.MarketDefinition; var IsEdit = MarketDefId > 0 ? 1 : 0; List <MarketDefinitionPack> marketDefinitionPacks = marketDefinition.MarketDefinitionPacks;//store Packs List <MarketDefinitionBaseMap> marketDefinitionBaseMaps = marketDefinition.MarketDefinitionBaseMaps; marketDefinition.MarketDefinitionPacks = null; marketDefinition.MarketDefinitionBaseMaps = null; //to delete previous market base //_db.Database.ExecuteSqlCommand("Delete from MarketDefinitionbaseMaps Where marketdefinitionid=" + MarketDefId); SqlParameter paramMarketID = new SqlParameter("@MarketDefID", MarketDefId); await _db.Database.ExecuteSqlCommandAsync("exec DeleteMarketDefinitionBaseMap @MarketDefID", paramMarketID); var mkt = new MarketDefinition() { Id = MarketDefId, Name = marketDefinition.Name, ClientId = ClientId, Client = null, MarketDefinitionBaseMaps = null, MarketDefinitionPacks = null, LastSaved = DateTime.Now }; _db.MarketDefinitions.AddOrUpdate(mkt); _db.SaveChanges(); MarketDefId = mkt.Id; // to update market definitionId in base maps foreach (MarketDefinitionBaseMap rec in marketDefinitionBaseMaps) { rec.MarketDefinitionId = MarketDefId; } //to add marketbase again. _db.MarketDefinitionBaseMaps.AddRange(marketDefinitionBaseMaps); await _db.SaveChangesAsync(); await SaveMarketPacks(marketDefinitionPacks, MarketDefId); await SaveGroupData(MarketDefId, marketDefinitionDetails.GroupView, IsEdit); await SaveMarketGroupPack(MarketDefId, marketDefinitionDetails.MarketGroupPack, IsEdit); if (marketDefinitionDetails.MarketGroupFilter != null) { await SaveMarketGroupFilter(MarketDefId, marketDefinitionDetails.MarketGroupFilter, IsEdit); } //return market info var returnDetails = new MarketDefinition() { Id = MarketDefId, Name = mkt.Name, ClientId = mkt.ClientId }; return(Request.CreateResponse(HttpStatusCode.OK, returnDetails)); }
public HttpResponseMessage UpdatePopularLink([FromBody] PopularLink postedData) { HttpResponseMessage response = null; try { PopularLink popLinkToBeUpdated; string title = string.Empty; using (EverestPortalContext readContext = new EverestPortalContext()) { popLinkToBeUpdated = readContext.PopularLinks.Where(x => x.popularLinkId.Equals(postedData.popularLinkId)).FirstOrDefault <PopularLink>(); title = popLinkToBeUpdated.popularLinkTitle; } if (popLinkToBeUpdated != null) { popLinkToBeUpdated.popularLinkTitle = postedData.popularLinkTitle; popLinkToBeUpdated.popularLinkDescription = postedData.popularLinkDescription; popLinkToBeUpdated.popularLinkDisplayOrder = postedData.popularLinkDisplayOrder; } using (EverestPortalContext updateContext = new EverestPortalContext()) { updateContext.Entry(popLinkToBeUpdated).State = System.Data.Entity.EntityState.Modified; updateContext.SaveChanges(); } if (title != postedData.popularLinkTitle) { string filePath = string.Empty, newFilePath = string.Empty; if (ConfigurationManager.AppSettings["PopularLinks"] != null) { string popularLinksFolder = ConfigurationManager.AppSettings["PopularLinks"].ToString(); filePath = System.Web.Hosting.HostingEnvironment.ApplicationPhysicalPath.Replace("API", "Web") + popularLinksFolder; System.IO.DirectoryInfo dirInfo = new System.IO.DirectoryInfo(filePath); var file = dirInfo.GetFiles().Where(x => x.Name == title + x.Extension).FirstOrDefault(); if (filePath != null && System.IO.File.Exists(filePath + @"\" + title + file.Extension)) { System.IO.FileInfo fileInfo = new System.IO.FileInfo(filePath + @"\" + title + file.Extension); fileInfo.CopyTo(filePath + @"\" + postedData.popularLinkTitle + file.Extension); fileInfo.Delete(); } } } //response = Request.CreateResponse<CADPage>(HttpStatusCode.OK,Request.RequestUri.ToString()); response = Request.CreateResponse <PopularLink>(HttpStatusCode.OK, postedData); } catch (Exception ex) { } return(response); }
public void SaveVersion <T>(T cName, int UserId) { int Version = 0; User val = (User)(object)cName; var result = _db.User_History.Where(i => i.UserID == val.UserID).OrderByDescending(x => x.Version).FirstOrDefault(); Version = (result == null) ? 1 : result.Version + 1; User_History obj = new User_History(); val.CopyProperties(obj); obj.UserID = val.UserID; obj.Version = Version; obj.ModifiedDate = DateTime.Now; obj.ModifiedUserId = UserId; _db.User_History.Add(obj); _db.SaveChanges(); UserRole_History roleHistory = new UserRole_History(); var role = _db.userRole.Where(i => i.UserID == val.UserID).FirstOrDefault(); role.CopyProperties(roleHistory); roleHistory.UserVersion = Version; _db.UserRole_History.Add(roleHistory); _db.SaveChanges(); var client = _db.userClient.Where(i => i.UserID == val.UserID).ToList(); foreach (UserClient clnt in client) { UserClient_History clientHistory = new UserClient_History(); clnt.CopyProperties(clientHistory); clientHistory.UserVersion = Version; _db.UserClient_History.Add(clientHistory); _db.SaveChanges(); } }
public HttpResponseMessage ChangeUserPassword([FromBody] UserDetail userdeatil) { HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.ExpectationFailed); try { using (EverestPortalContext context = new EverestPortalContext()) { var user = context.Users.FirstOrDefault <Models.Security.User>(x => x.UserID == userdeatil.UserID); if (user != null) { AuthController authController = new AuthController(); var oldPasswordHashed = authController.GenerateHashedPassword(userdeatil.OldPassword); if (user.Password != oldPasswordHashed) { response = Request.CreateResponse(HttpStatusCode.OK, new { isSuccess = false, message = "The old password is incorrect." }); } else { var passwordHashed = authController.GenerateHashedPassword(userdeatil.Password); var passwordHistoryExist = context.PasswordHistories.Where(x => x.UserID.Equals(user.UserID)) .OrderByDescending(x => x.CreatedDate).Take(12).FirstOrDefault(x => x.Password == passwordHashed); if (passwordHistoryExist != null || user.Password == passwordHashed) { response = Request.CreateResponse(HttpStatusCode.OK, new { isSuccess = false, message = " You cannot reuse one of your last 13 passwords" }); } else { context.PasswordHistories.Add( new Models.Security.PasswordHistory { UserID = user.UserID, Password = passwordHashed, CreatedDate = DateTime.Now }); user.Password = passwordHashed; user.FailedPasswordAttempt = 0; user.IsPasswordVerified = true; user.PasswordCreatedDate = DateTime.Now; context.SaveChanges(); response = Request.CreateResponse(HttpStatusCode.OK, new { isSuccess = true, message = "" }); } } } } } catch (Exception ex) { } return(response); }
public HttpResponseMessage addMarketBase([FromBody] JObject request) { if (request != null) { int clientID = 0; if (request["clientid"] != null) { string clientid = Convert.ToString(request["clientid"]); int.TryParse(clientid, out clientID); } AuthController objAuth = new AuthController(); if (objAuth.CheckUserClients(clientID) == 0) { return(Request.CreateResponse(HttpStatusCode.NoContent)); } string subId = request["subscriptionid"].ToString(); var MktId = request["mktbaseid"].ToList(); int subscriptionId = 0; int.TryParse(subId, out subscriptionId); for (int i = 0; i < MktId.Count; i++) { int mktBaseid = 0; int.TryParse(MktId[i].ToString(), out mktBaseid); int recCnt = dbContext.subscriptionMarket.Count(p => p.SubscriptionId == subscriptionId && p.MarketBaseId == mktBaseid); if (recCnt <= 0) { dbContext.subscription.Where(x => x.SubscriptionId == subscriptionId).FirstOrDefault().LastModified = DateTime.Now; dbContext.subscriptionMarket.Add(new SubscriptionMarket { SubscriptionId = subscriptionId, MarketBaseId = mktBaseid }); } } dbContext.SaveChanges(); } return(Request.CreateResponse(HttpStatusCode.Created)); }
public Boolean UnlockDefinitions(ICollection <int> lockHistoriesID) { if (lockHistoriesID.Count > 0) { using (EverestPortalContext context = new EverestPortalContext()) { context.LockHistories.RemoveRange(context.LockHistories.Where(l => lockHistoriesID.Contains(l.Id))); context.SaveChanges(); return(true); } } return(false); }
public async Task <HttpResponseMessage> SaveExpiryDates([FromBody] RequestRelease request) { var client = request.Client; var packs = request.Packs; using (var context = new EverestPortalContext()) { foreach (var pack in packs) { if (pack.ProductLevel) { var eDate = Convert.ToDateTime(pack.ExpiryDate); //var packByPRoducts = await releaseProvider.GetPacksByProduct(new List<ReleasePack> { pack }); var response = await releaseProvider.GetPacksByProduct(new List <ReleasePack> { pack }, 1, 1000); var packByPRoducts = response?.Data; foreach (var aPack in packByPRoducts) { var updateClientException = context.ClientPackException.FirstOrDefault(x => x.ClientId == client.clientId && x.PackExceptionId == aPack.Id); if (updateClientException != null) { updateClientException.ExpiryDate = eDate; } else { context.ClientPackException.Add(new ClientPackException { ClientId = client.clientId, PackExceptionId = pack.Id, ProductLevel = pack.ProductLevel, ExpiryDate = eDate }); } } } else { UpdateExpiryDatePack(context, pack, client); } context.SaveChanges(); } ; } return(Request.CreateResponse(HttpStatusCode.OK)); }
private void DeleteMfrAllocation(IEnumerable <int> mfrs, IEnumerable <ReleaseClient> clients) { using (EverestPortalContext context = new EverestPortalContext()) { foreach (var client in clients) { foreach (var mfr in mfrs) { var mfrClientsToDelete = context.ClientMFR.Where(x => x.ClientId == client.clientId && x.MFRId == mfr); context.ClientMFR.RemoveRange(mfrClientsToDelete); context.SaveChanges(); } } } }
private void DeletePackAllocation(IEnumerable <ReleasePack> packs, IEnumerable <ReleaseClient> clients) { using (EverestPortalContext context = new EverestPortalContext()) { foreach (var client in clients) { foreach (var pack in packs) { var packClientsToDelete = context.ClientPackException.Where(x => x.ClientId == client.clientId && x.PackExceptionId == pack.Id).ToList(); context.ClientPackException.RemoveRange(packClientsToDelete); context.SaveChanges(); } } } }
public int CreateCustomFilter([FromBody] ReportFilter Filter) { if (Filter != null) { using (var db = new EverestPortalContext()) { if (db.ReportFilters.Where(r => r.FilterName.Equals(Filter.FilterName) && r.ModuleID == Filter.ModuleID).Count() > 0) { return(0); } db.ReportFilters.Add(Filter); db.SaveChanges(); } } return(Filter.FilterID); }
public HttpResponseMessage DeletePopularLink(int Id) { HttpResponseMessage response; PopularLink popLinkToBeDeleted; try { using (EverestPortalContext context = new EverestPortalContext()) { popLinkToBeDeleted = context.PopularLinks.Where(x => x.popularLinkId.Equals(Id)).FirstOrDefault <PopularLink>(); if (popLinkToBeDeleted != null) { context.PopularLinks.Remove(popLinkToBeDeleted); context.SaveChanges(); string filePath = string.Empty; if (ConfigurationManager.AppSettings["PopularLinks"] != null) { string popularLinksFolder = ConfigurationManager.AppSettings["PopularLinks"].ToString(); filePath = System.Web.Hosting.HostingEnvironment.ApplicationPhysicalPath.Replace("API", "Web") + popularLinksFolder; System.IO.DirectoryInfo dirInfo = new System.IO.DirectoryInfo(filePath); var file = dirInfo.GetFiles().Where(x => x.Name == popLinkToBeDeleted.popularLinkTitle + x.Extension).FirstOrDefault(); if (filePath != null && System.IO.File.Exists(filePath + @"\" + popLinkToBeDeleted.popularLinkTitle + file.Extension)) { System.IO.FileInfo fileInfo = new System.IO.FileInfo(filePath + @"\" + popLinkToBeDeleted.popularLinkTitle + file.Extension); fileInfo.Delete(); } } if (filePath != null && System.IO.File.Exists(filePath)) { System.IO.FileInfo fileInfo = new System.IO.FileInfo(filePath); fileInfo.Delete(); } } } response = Request.CreateResponse(HttpStatusCode.NoContent); } catch (Exception ex) { throw; } return(response); }
/// <summary> /// Deletes the user clients for the supllied users and clients /// </summary> /// <param name="users"></param> /// <param name="clients"></param> private static void DeleteAllocation(IEnumerable <int> users, IEnumerable <int> clients, int actionUser) { using (EverestPortalContext context = new EverestPortalContext()) { var userClientsToDelete = context.userClient.Where(x => users.Contains(x.UserID) && clients.Contains(x.ClientID)); context.userClient.RemoveRange(userClientsToDelete); context.SaveChanges(); } using (EverestPortalContext context = new EverestPortalContext()) { foreach (int userid in users) { var objClient = context.Users.SingleOrDefault(p => p.UserID == userid); IAuditLog log = AuditFactory.GetInstance(typeof(User).Name); log.SaveVersion <User>(objClient, actionUser); } } }
public bool DeleteCustomFilter([FromBody] ReportFilter Filter) { bool blnDeleted = false; if (Filter.FilterID > 0) { using (var db = new EverestPortalContext()) { ReportFilter ReportFilterSelected = db.ReportFilters.Where(m => m.FilterID == Filter.FilterID).SingleOrDefault(); if (ReportFilterSelected != null) { db.Entry(ReportFilterSelected).State = EntityState.Deleted; db.SaveChanges(); blnDeleted = true; } } } return(blnDeleted); }