public bool ValidateCheckDeletion(Check check) { MyLogger.Instance().Log("Validate Check's deletion -- CALLED", "Service", "INFO"); try { lock (x) { using (ProjectDBContext dBContext = new ProjectDBContext()) { Check toDelete = dBContext.Checks.ToList().Find(c => c.Id == check.Id); if (dBContext.Checks.ToList().Exists(x => x.Id == check.Id)) { MyLogger.Instance().Log("Validate Check's deletion -- SUCCESS", "Service", "INFO"); return(true); } else { MyLogger.Instance().Log("Validate Check's deletion -- FAIL", "Service", "ERROR"); return(false); } } } } catch { MyLogger.Instance().Log("Validate Check's deletion -- ERROR", "Service", "FATAL"); return(false); } }
//Single Category public Category GetCategory(int ID) { using (var context = new ProjectDBContext()) { return(context.Categories.Find(ID)); } }
//All Categories public List <Category> GetCategories() { using (var context = new ProjectDBContext()) { return(context.Categories.ToList()); } }
//Single Product public Product GetProduct(int ID) { using (var context = new ProjectDBContext()) { return(context.Products.Find(ID)); } }
public List <User> GetAllUsers() { using (ProjectDBContext _db = new ProjectDBContext()) { return(_db.Users.ToList()); } }
public EntryWindow(ProjectDBContext db, Entry entry = null) { this.entry = entry; if (this.entry == null) { this.entry = new Entry() { Date = DateTime.Now } } ; this.db = db; InitializeComponent(); db.CarWash.Load(); carWash_cb.ItemsSource = db.CarWash.Local.ToObservableCollection(); db.ClientPhone.Load(); phone_cb.ItemsSource = db.ClientPhone.Local.ToObservableCollection(); db.Car.Load(); car_cb.ItemsSource = db.Car.Local.ToObservableCollection(); db.Service.Load(); services_lb.ItemsSource = db.Service.Local.ToObservableCollection(); foreach (EntryService item in this.entry.EntryService) { services_lb.SelectedItems.Add(item.Service); } ChangeTime(this.entry.Date); OnPropertyChanged(nameof(Time)); }
public QuizController(IQuizRepo quizrepo, ProjectDBContext context, UserManager <Person> UserMgr, IQuestionsRepo questionsRepo) { this.quizrepo = quizrepo; this.context = context; _userManager = UserMgr; this.questionsRepo = questionsRepo; }
public ClientReportWindow(ProjectDBContext db) { this.db = db; db.Client.Load(); InitializeComponent(); clients_cb.ItemsSource = this.db.Client.Local.ToArray(); }
public QuestionsController(IQuestionsRepo questionsRepo, ProjectDBContext context, IQuizRepo quizrepo, IHistoryRepo historyRepo) { this.questionsRepo = questionsRepo; this.context = context; this.quizrepo = quizrepo; this.historyRepo = historyRepo; }
public bool ValidateCheckChange(Check check) { MyLogger.Instance().Log("Validate Check -- CALLED", "Service", "INFO"); try { lock (x) { using (ProjectDBContext dBContext = new ProjectDBContext()) { Check toValidate = dBContext.Checks.ToList().Find(x => x.Id == check.Id); if (DateTime.Compare(check.Datetime, dBContext.Checks.ToList().Find(x => x.Id == check.Id).Datetime) != 0) { MyLogger.Instance().Log("Validate Check -- FAILED", "Service", "INFO"); return(false); } else { MyLogger.Instance().Log("Validate Check -- SUCCESS", "Service", "INFO"); return(true); } } } } catch { MyLogger.Instance().Log("Validate Check -- ERROR", "Service", "FATAL"); return(false); } }
private void Seed() { using (var context = new ProjectDBContext(options)) { context.Database.EnsureDeleted(); context.Database.EnsureCreated(); context.Pattern.AddRange( new Pattern { Id = 2, PatternData = "10110111" }, new Pattern { Id = 3, PatternData = "00010001" } ); context.SaveChanges(); } }
/// <summary> /// /// </summary> /// <returns></returns> public List <Model.Task> GetAllTasks() { using (ProjectDBContext _db = new ProjectDBContext()) { return(_db.Tasks.ToList()); } }
public AnswersController(IQuestionsRepo questionsRepo, ProjectDBContext context, IQuizRepo quizrepo, IAnswersRepo answerRepo) { this.questionsRepo = questionsRepo; this.context = context; this.quizrepo = quizrepo; this.answerRepo = answerRepo; }
public List <Project> GetAllProjects() { using (ProjectDBContext _db = new ProjectDBContext()) { return(_db.Projects.ToList()); } }
/// <summary> /// /// </summary> /// <param name="newTask"></param> public void AddTask(Model.Task newTask) { using (ProjectDBContext _db = new ProjectDBContext()) { _db.Tasks.Add(newTask); _db.SaveChanges(); } }
public bool AddUser(User newUser) { using (ProjectDBContext _db = new ProjectDBContext()) { _db.Users.Add(newUser); _db.SaveChanges(); return(true); } }
public bool AddProject(Project newProject) { using (ProjectDBContext _db = new ProjectDBContext()) { _db.Projects.Add(newProject); _db.SaveChanges(); return(true); } }
//All Products public List <Product> GetProducts() { //var context = new ProjectDBContext(); //return context.Products.ToList(); using (var context = new ProjectDBContext()) { return(context.Products.Include(x => x.Category).ToList()); } }
public ProductWindow(ProjectDBContext db, Product product = null) { this.product = product; if (this.product == null) { this.product = new Product(); } this.db = db; InitializeComponent(); }
public IActionResult Get(string id) { var client = new ProjectDBContext().Client.FirstOrDefault(n => n.Id == Convert.ToInt16(id)); if (client == null) { return(new NotFoundObjectResult(client)); } return(Ok(client)); }
public async Task GetUsersSampleSetsByIDAsync_ShouldReturnUserSampleSets() { int id = 1; ProjectDBContext projectDBContext = new ProjectDBContext(options); ProjectRepoDB projectRepoDB = new ProjectRepoDB(projectDBContext); var result = await projectRepoDB.GetUsersSampleSetsByIDAsync(id); Assert.Equal(1, result.Id); }
/// <summary> /// /// </summary> /// <param name="id"></param> /// <returns></returns> public Model.Task GetTaskByID(string id) { using (ProjectDBContext _db = new ProjectDBContext()) { List <Model.Task> allTasks = (from task1 in _db.Tasks select task1).ToList(); Model.Task task = allTasks.Where(a => a.Task_ID == id).FirstOrDefault(); return(task); } }
public async Task GetUsersSampleSetsByUserIDAsync_ShouldReturnUserSampleSets() { int id = 2; ProjectDBContext projectDBContext = new ProjectDBContext(options); ProjectRepoDB projectRepoDB = new ProjectRepoDB(projectDBContext); var result = await projectRepoDB.GetUsersSampleSetsByUserIDAsync(id); Assert.Single(result); }
/// <summary> /// / /// </summary> /// <param name="id"></param> /// <returns></returns> public List <Model.Task> GetAllTasksByProjectID(string id) { using (ProjectDBContext _db = new ProjectDBContext()) { List <Model.Task> allTasks = (from task1 in _db.Tasks select task1).ToList(); return(allTasks.Where(a => a.Project_ID == id).ToList()); } }
public ServiceWindow(ProjectDBContext db, Service service = null) { this.service = service; if (this.service == null) { this.service = new Service(); } this.db = db; InitializeComponent(); }
public IActionResult Get(int id) { var Project = new ProjectDBContext().Project.FirstOrDefault(n => n.Id == id); if (Project == null) { return(new NotFoundObjectResult(Project)); } return(Ok(Project)); }
public void UpdateCategory(Category category) { using (var context = new ProjectDBContext()) { //Update category context.Entry(category).State = System.Data.Entity.EntityState.Modified; //Save Changes context.SaveChanges(); } }
public CarWashWindow(ProjectDBContext db, CarWash cw = null) { this.cw = cw; if (this.cw == null) { this.cw = new CarWash(); } this.db = db; InitializeComponent(); }
public void UpdateProduct(Product product) { using (var context = new ProjectDBContext()) { //Update Product context.Entry(product).State = System.Data.Entity.EntityState.Modified; //Save Changes context.SaveChanges(); } }
public void SaveCategory(Category category) { using (var context = new ProjectDBContext()) { //Add category context.Categories.Add(category); //Save Changes context.SaveChanges(); } }