public ActionResult Create(PocoClasses.Entries.Team newTeam, int entryId) { Mapper.Initialize(cfg => cfg.CreateMap <PocoClasses.Entries.Team, Team>()); Team team = Mapper.Map <Team>(newTeam); team.EntryId = entryId; if (ModelState.IsValid) { using (var context = new TeamContext()) { var service = new TeamService(context); service.Add(team); } using (var context = new RaceEntryContext()) { var service = new RaceEntryService(context); service.Add(team.Id, newTeam.EventId); } Entry entry; using (var context = new EntryContext()) { var service = new EntryService(new RosContext <Entry>()); entry = service.GetById(entryId); } return(RedirectToAction("Index", entry)); } return(View(team)); }
public static Allergen GetAllergenByID(int allergenID) { using (EntryContext context = new EntryContext()) { return(context.Allergens.Where(x => x.ID == allergenID).SingleOrDefault()); } }
public bool DealMessage302(string orderNoFake, string guid, string status, string returnTime, string returnInfo, string destPath) { bool success = true; try { EntryReceive entry = new EntryReceive(); entry.ItemGuid = new Guid(guid); entry.Status = Convert.ToInt32(status); entry.ReturnTime = returnTime; entry.ReturnInfo = returnInfo; entry.FilePath = destPath; using (var db = new EntryContext()) { var query = from m in db.MessageTracks.Include("Entry302s") where m.OrderNoFake == orderNoFake select m; var msTrack = query.FirstOrDefault(); msTrack.Entry302s.Add(entry); msTrack.LastUpdateTicks = DateTime.Now.Ticks; if (msTrack.Schedule < 302) { msTrack.Schedule = 302; } db.SaveChanges(); } } catch (Exception ex) { Logs.Error(string.Format("DealMessage302 OrderNoFake: {0} , Exception: {1}", orderNoFake, ex.ToString())); success = false; } return(success); }
public bool DeleteMessageByFilter(MessageFilter filter) { bool success = true; try { using (var db = new EntryContext()) { var query = from m in db.MessageTracks .Include("Entry301s") .Include("Entry302s") .Include("Entry501s") .Include("Entry502s") .Include("Entry503s") .Include("Entry504s") .Include("Entry601s") .Include("Entry602s") where (string.IsNullOrEmpty(filter.OrderNo) ? true : m.OrderNo.IndexOf(filter.OrderNo) >= 0) && (string.IsNullOrEmpty(filter.LogisticsNo) ? true : m.LogisticsNo.IndexOf(filter.LogisticsNo) >= 0) && (filter.Status.Equals("All") ? true : filter.Status.Equals("True") ? m.IsFinished : !m.IsFinished) && (filter.Start.Ticks == 0 ? true : m.LastUpdateTicks >= filter.Start.Ticks) && (filter.End.Ticks == 0 ? true : m.LastUpdateTicks <= filter.End.Ticks) select m; db.MessageTracks.RemoveRange(query); db.SaveChanges(); } } catch (Exception ex) { Logs.Error("DeleteMessageByFilter Exception: " + ex.ToString()); success = false; } return(success); }
public MessageTrack GetMessageTrackByGuid(MessageFilter Filter) { MessageTrack result = null; try { using (var db = new EntryContext()) { var query = from m in db.MessageTracks .Include("Entry301s") .Include("Entry302s") .Include("Entry501s") .Include("Entry502s") .Include("Entry503s") .Include("Entry504s") .Include("Entry601s") .Include("Entry602s") where m.ItemGuid == Filter.Guid select m; result = query.FirstOrDefault(); } } catch (Exception ex) { Logs.Error("GetMessageTrackByGuid Exception: " + ex.ToString()); } return(result); }
public bool DeleteMessageByGuid(MessageFilter filter) { bool success = true; try { using (var db = new EntryContext()) { var query = from m in db.MessageTracks .Include("Entry301s") .Include("Entry302s") .Include("Entry501s") .Include("Entry502s") .Include("Entry503s") .Include("Entry504s") .Include("Entry601s") .Include("Entry602s") where m.ItemGuid == filter.Guid select m; db.Entry(query.FirstOrDefault()).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); } } catch (Exception ex) { Logs.Error("DeleteMessageByGuid Exception: " + ex.ToString()); success = false; } return(success); }
// Changes property IsArchived on given entry and it's child entries if there are any. public static ActionResult <string> ChangeArchivedEntryByID(int id) { Entry entryToBeChanged = GetEntryByID(id); List <Allergen_Entry> childEntries = new List <Allergen_Entry>(); if (entryToBeChanged == null) { throw new Exception("Entry wasn't found."); } using (EntryContext context = new EntryContext()) { entryToBeChanged = context.Entries.Where(x => x.ID == id).SingleOrDefault(); entryToBeChanged.IsArchived = !entryToBeChanged.IsArchived; childEntries = context.Allergen_Entries.Where(x => x.EntryID == id).ToList(); if (childEntries.Count > 0) { foreach (Allergen_Entry childEntry in childEntries) { childEntry.IsArchived = !childEntry.IsArchived; } } context.SaveChanges(); } return("Success!"); }
public bool DealMessage501(bool isReceived, bool isCreated, string guid, string orderNoFake, string logisticNo, string destPath) { bool success = true; try { EntryCreate entry = new EntryCreate(); entry.ItemGuid = new Guid(guid); entry.IsReceived = isReceived; entry.IsCreated = isCreated; entry.ReceiveTime = entry.CreateTime = DateTime.Now.ToString("yyyyMMddHHmmss"); entry.FilePath = destPath; using (var db = new EntryContext()) { var query = from m in db.MessageTracks.Include("Entry501s") where m.OrderNoFake == orderNoFake select m; var msTrack = query.FirstOrDefault(); msTrack.Entry501s.Add(entry); msTrack.LastUpdateTicks = DateTime.Now.Ticks; msTrack.Schedule = 501; db.SaveChanges(); } } catch (Exception ex) { Logs.Error(string.Format("DealMessage501 OrderNoFake: {0} , Exception: {1}", orderNoFake, ex.ToString())); success = false; } return(success); }
// Sanitizes input, creates new user profile public static ActionResult <string> RegisterUser(string id, string username, string password, bool isDiabetic) { if (id.Length < 36) { throw new Exception("Invalid ID."); } else if (GetUserByID(id) != null) { throw new Exception("ID already exists in the database."); } else if (GetUserByName(username) != null) { throw new Exception("Username already exists in the database."); } else if (!TestString(username)) { throw new Exception("Username contains forbidden characters."); } else if (!TestString(password)) { throw new Exception("Password contains forbidden characters."); } using (EntryContext context = new EntryContext()) { password = GetHash(username + password); User newUser = new User(id, username, password, isDiabetic); context.Users.Add(newUser); context.SaveChanges(); } return("Success!"); }
public static Entry GetEntryByID(int id) { using (EntryContext context = new EntryContext()) { return(context.Entries.Where(x => x.ID == id).SingleOrDefault()); } }
public static ActionResult <List <Allergen> > GetAllergens() { using (EntryContext context = new EntryContext()) { return(context.Allergens.OrderBy(x => x.Name).ToList()); } }
public bool DealMessage504(string logisticsNo, string guid, string status, string logisticsStatus, string returnTime, string returnInfo, string destPath) { bool success = true; try { EntryReceive entry = new EntryReceive(); entry.ItemGuid = new Guid(guid); entry.Status = Convert.ToInt32(status); entry.ReturnTime = returnTime; entry.ReturnInfo = returnInfo; entry.FilePath = destPath; entry.Commnet1 = logisticsStatus; using (var db = new EntryContext()) { var query = from m in db.MessageTracks.Include("Entry504s") where m.LogisticsNo == logisticsNo select m; var msTrack = query.FirstOrDefault(); msTrack.Entry504s.Add(entry); msTrack.LastUpdateTicks = DateTime.Now.Ticks; msTrack.Schedule = 504; db.SaveChanges(); } } catch (Exception ex) { Logs.Error(string.Format("DealMessage504 LogisticsNo: {0} Exception: {1}", logisticsNo, ex.ToString())); success = false; } return(success); }
public List <MessageTrack> GetMessageTracksByFilter(MessageFilter filter) { List <MessageTrack> result = null; try { Logs.Debug("GetMessageTracksByFilter Start! Filter:" + JsonConvert.SerializeObject(filter)); using (var db = new EntryContext()) { var query = from m in db.MessageTracks .Include("Entry301s") .Include("Entry302s") .Include("Entry501s") .Include("Entry502s") .Include("Entry503s") .Include("Entry504s") .Include("Entry601s") .Include("Entry602s") where (string.IsNullOrEmpty(filter.OrderNo) ? true : m.OrderNo.IndexOf(filter.OrderNo) >= 0) && (string.IsNullOrEmpty(filter.LogisticsNo) ? true : m.LogisticsNo.IndexOf(filter.LogisticsNo) >= 0) && (filter.Status.Equals("All") ? true : filter.Status.Equals("True") ? m.IsFinished : !m.IsFinished) && (filter.Start.Ticks == 0 ? true : m.LastUpdateTicks >= filter.Start.Ticks) && (filter.End.Ticks == 0 ? true : m.LastUpdateTicks <= filter.End.Ticks) orderby m.LastUpdateTicks descending select m; result = query.ToList(); } Logs.Debug("GetMessageTracksByFilter End! Result Count:" + result.Count); } catch (Exception ex) { Logs.Error("GetAllMessageTracks Exception: " + ex.ToString()); } return(result); }
public static ActionResult <List <Status> > GetStatuses() { using (EntryContext context = new EntryContext()) { return(context.Statuses.OrderBy(x => x.Name).ToList()); } }
public List <MessageTrack> GetAllMessageTracks() { var start = DateTime.Now.AddDays(-10); List <MessageTrack> result = null; try { using (var db = new EntryContext()) { var query = from m in db.MessageTracks .Include("Entry301s") .Include("Entry302s") .Include("Entry501s") .Include("Entry502s") .Include("Entry503s") .Include("Entry504s") .Include("Entry601s") .Include("Entry602s") where !m.IsFinished && m.LastUpdateTicks >= start.Ticks orderby m.LastUpdateTicks descending select m; result = query.ToList(); } } catch (Exception ex) { Logs.Error("GetAllMessageTracks Exception: " + ex.ToString()); } return(result); }
static void Main() { var context = new EntryContext(); context.Database.EnsureCreated(); var controller = new Controller(context); controller.Run(); }
public static Status GetStatusByID(int id) { Status status; using (EntryContext context = new EntryContext()) { status = context.Statuses.Where(x => x.ID == id).SingleOrDefault(); } return(status); }
public static User GetUserByName(string username) { User user; using (EntryContext context = new EntryContext()) { user = context.Users.Where(x => x.Username == username).SingleOrDefault(); } return(user); }
public static User GetUserByID(string id) { User user; using (EntryContext context = new EntryContext()) { user = context.Users.Where(x => x.ID == id).SingleOrDefault(); } return(user); }
public static Category GetCategoryByID(int id) { Category category; using (EntryContext context = new EntryContext()) { category = context.Categories.Where(x => x.ID == id).SingleOrDefault(); } return(category); }
public EntryService(IOptions <Settings> options, IMapper mapper, ICommentService commentService, IUserService userService) { if (options is null) { throw new ArgumentNullException(nameof(options)); } context = new EntryContext(options); this.mapper = mapper ?? throw new ArgumentNullException(nameof(mapper)); this.commentService = commentService ?? throw new ArgumentNullException(nameof(commentService)); this.userService = userService ?? throw new ArgumentNullException(nameof(userService)); }
public static ActionResult <List <Category> > GetCategories(bool diabetic = false) { using (EntryContext context = new EntryContext()) { if (diabetic) { return(context.Categories.ToList()); } else { return(context.Categories.Where(x => x.IsDiabetic == false).ToList()); } } }
public override bool Sync(IEnumerable <Guid> remove, IEnumerable <Entry> add) { var ancestorDb = new AncestorContext(); var entryDb = new EntryContext(); try { entryDb.Database.BeginTransaction(); var now = DateTime.UtcNow; if (add != null) { foreach (var entry in add) { entryDb.Write(entry.Key, entry.Id, entry.Map, now); ancestorDb.Write(entry.Id, entry.Key, now); foreach (var ancestor in entry.Ancestors) { ancestorDb.Write(ancestor, entry.Key, now); } } } if (remove != null) { foreach (var guid in remove) { ancestorDb.Delete(guid, now); entryDb.Delete(guid, now); } } entryDb.Database.CompleteTransaction(); return(true); } catch (Exception ex) { LogHelper.Error <SqlIndexer>($"Error trying to sync content with indexer", ex); } try { entryDb.Database.AbortTransaction(); } catch (Exception) { // Just swallow the error, as the previous catch above would have logged it } return(false); }
public override void Up() { try { // Create tables _schemaHelper.CreateTable <Dto.Entry.Entry100>(); _schemaHelper.CreateTable <Dto.Ancestor.Ancestor100>(); // Scrape all existing content and place into the index var ancestorDb = new AncestorContext(); var entryDb = new EntryContext(); var now = DateTime.UtcNow; var contents = new Stack <Umbraco.Core.Models.IContent>(); var contentService = ApplicationContext.Current.Services.ContentService; foreach (var content in contentService.GetChildren(Umbraco.Core.Constants.System.Root)) { if (content.Published) { contents.Push(content); } } while (contents.Count != 0) { var content = contents.Pop(); foreach (var child in contentService.GetChildren(content.Id)) { if (child.Published) { contents.Push(child); } } foreach (var entry in new ContentService().Entries(new Umbraco.Core.Models.IContent[] { content })) { entryDb.Write(entry.Key, entry.Id, entry.Map, now); ancestorDb.Write(entry.Id, entry.Key, now); foreach (var ancestor in entry.Ancestors) { ancestorDb.Write(ancestor, entry.Key, now); } } System.Threading.Thread.Sleep(50); } } catch (Exception ex) { LogHelper.Error <SqlIndexer>($"Error trying to create content with indexer", ex); } }
public bool DealMessage301(string orderNo, string orderNoFake, string logisticsNo, bool isReceived, bool isCreated, string guid, string destPath, string logisticCode) { bool success = true; try { EntryCreate entry = new EntryCreate(); entry.ItemGuid = new Guid(guid); entry.IsReceived = isReceived; entry.IsCreated = isCreated; entry.CreateTime = entry.ReceiveTime = DateTime.Now.ToString("yyyyMMddHHmmss"); entry.FilePath = destPath; MessageTrack msTrack = new MessageTrack(); msTrack.ItemGuid = Guid.NewGuid(); msTrack.OrderNo = orderNo; msTrack.OrderNoFake = orderNoFake; msTrack.LogisticsNo = logisticsNo; msTrack.Schedule = 301; msTrack.LastUpdateTicks = DateTime.Now.Ticks; msTrack.Commnet1 = logisticCode; msTrack.Entry301s = new List <EntryCreate>(); msTrack.Entry302s = new List <EntryReceive>(); msTrack.Entry501s = new List <EntryCreate>(); msTrack.Entry502s = new List <EntryReceive>(); msTrack.Entry503s = new List <EntryCreate>(); msTrack.Entry504s = new List <EntryReceive>(); msTrack.Entry601s = new List <EntryCreate>(); msTrack.Entry602s = new List <EntryReceive>(); msTrack.Entry301s.Add(entry); using (var db = new EntryContext()) { db.MessageTracks.Add(msTrack); db.SaveChanges(); } } catch (Exception ex) { Logs.Error(string.Format("DealMessage301 OrderNo: {0} , Exception: {1}", orderNo, ex.ToString())); success = false; } return(success); }
public void CreatesSampleData() { return; EntryContext context = new EntryContext(); Random random = new Random(); for (int i = 0; i < 300; i++) { Entry entry = new Entry() { Value = (100 * random.NextDouble()) * (random.NextDouble() > 0.5 ? -1 : 1), CreatedDateTime = DateTime.Now.AddHours(-i * 12) }; context.Entries.Add(entry); } context.SaveChanges(); }
public string GetLogisticCodeByLogisticsNo(string logisticsNo) { string result = null; try { using (var db = new EntryContext()) { var query = from m in db.MessageTracks where m.LogisticsNo.Equals(logisticsNo) select m.Commnet1; result = query.FirstOrDefault().ToString(); } } catch (Exception ex) { Logs.Error(string.Format("GetLogisticCodeByLogisticsNo OrderNoFake: {0} , Exception: {1}", logisticsNo, ex.ToString())); } return(result); }
public EntryContext entry() { EntryContext _localctx = new EntryContext(Context, State); EnterRule(_localctx, 2, RULE_entry); int _la; try { EnterOuterAlt(_localctx, 1); { State = 15; ErrorHandler.Sync(this); _la = TokenStream.LA(1); if (_la == DASH) { { State = 14; Match(DASH); } } State = 17; _localctx.k = key(); State = 18; Match(EQUALS); State = 19; _localctx.v = value(); } } catch (RecognitionException re) { _localctx.exception = re; ErrorHandler.ReportError(this, re); ErrorHandler.Recover(this, re); } finally { ExitRule(); } return(_localctx); }
public ActionResult Join(JoinEntry joinEntry) { try { int entryId; using (var context = new EntryContext()) { var entryLogicService = new EntryService(); entryId = entryLogicService.GetByEntryNumber(int.Parse(joinEntry.EntryNumber)).Id; } using (var context = new RegisteredUserContext()) { var regUserService = new RegisteredUserService(context); regUserService.JoinEntry(int.Parse(User.Identity.Name), entryId); } } catch (Exception e) { Console.WriteLine(e); throw new Exception("EF broke... Ask robin"); } return(View()); }
// Checkes if combination of username and password exist in database using hashed password, validates user public static List <string> ValidateUser(string username, string password) { List <string> validateReturn = new List <string>(); if (GetUserByName(username) == null) { throw new Exception("Wrong username or password."); } else if (!TestString(username)) { throw new Exception("Username contains forbidden characters."); } else if (!TestString(password)) { throw new Exception("Password contains forbidden characters."); } User user; password = GetHash(username + password); using (EntryContext context = new EntryContext()) { user = context.Users.Where(x => x.Username == username && x.Password == password).SingleOrDefault(); } if (user == null) { throw new Exception("Wrong username or password."); } else { validateReturn.Add("Success!"); validateReturn.Add(user.ID); validateReturn.Add(user.IsDiabetic.ToString().ToLower()); return(validateReturn); } }