public async Task <bool> RemoveMyBooksBackToStore(int userId, int bookId) { try { using (var context = new HDBContext()) { //remove book from mylist var userBook = await context.UserBook.Where(b => b.UserId == userId && b.BookId == bookId).FirstOrDefaultAsync(); if (userBook != null) { context.UserBook.Remove(userBook); //add book back to store var bookStore = await context.BookStore.Where(b => b.BookId == bookId).FirstOrDefaultAsync(); if (bookStore != null) { bookStore.StockCount++; context.BookStore.Update(bookStore); } } return(await context.SaveChangesAsync() > 0); } } catch (Exception ex) { throw ex; } }
public async Task <bool> EditBook(Book book) { try { using (var context = new HDBContext()) { var bookData = await context.Book.FirstOrDefaultAsync(b => b.BookId == book.BookId && b.IsActive == true); if (bookData != null) { bookData.Title = book.Title; bookData.Author = book.Author; bookData.Isbn = book.Isbn; bookData.Publication = book.Publication; bookData.Yearofpub = book.Yearofpub; bookData.UpdatedDate = DateTime.UtcNow; } return(await context.SaveChangesAsync() > 0); } } catch (Exception ex) { throw ex; } }
private void RefreshView_OnRefreshing(object sender, EventArgs e) { Patients.Clear(); using (var _context = new HDBContext()) { _context.Patients.ToList().ForEach(p => Patients.Add(p)); } var entries = new List <ChartEntry>(); for (int i = -1; i < 2; i++) { var day = DateTime.Now.AddDays(i); entries.Add(new ChartEntry(Patients.Count(p => p.AddDateTime.Date == day.Date)) { Label = day.ToShortDateString(), TextColor = SKColor.Parse("#fff"), Color = SKColor.Parse("#eee"), ValueLabel = Patients.Count(p => p.AddDateTime.Date == day.Date).ToString() }); } mainChart.Chart = new LineChart() { Entries = entries, LineMode = LineMode.Straight, PointMode = PointMode.Square, BackgroundColor = SKColor.Parse("#3399FF"), LabelColor = SKColor.Parse("#fff"), Margin = 0 }; mainChartB.Chart = new RadialGaugeChart() { Entries = new List <ChartEntry> { new ChartEntry(Patients.Count(p => p.IsSick)) { Color = SKColor.Parse("#2ecc71"), TextColor = SKColor.Parse("#eee"), ValueLabel = Patients.Count(p => p.IsSick).ToString(), Label = "NotSick" }, new ChartEntry(Patients.Count(p => p.IsSick == false)) { Color = SKColor.Parse("#e74c3c"), TextColor = SKColor.Parse("#eee"), ValueLabel = Patients.Count(p => p.IsSick == false).ToString(), Label = "Sick" }, }, BackgroundColor = SKColor.Parse("#3399FF"), LabelColor = SKColor.Parse("#fff"), Margin = 0 }; mainCollection.ItemsSource = Patients; refreshView.IsRefreshing = false; }
public async Task <List <UserBook> > GetUserBooks(int userId) { try { using (var context = new HDBContext()) { return(await context.UserBook .Where(b => b.UserId == userId) .ToListAsync()); } } catch (Exception ex) { throw ex; } }
public async Task <bool> BorrowBooks(List <UserBook> userBooks, List <BookStore> bookStores) { try { using (var context = new HDBContext()) { context.BookStore.UpdateRange(bookStores); context.UserBook.AddRange(userBooks); return(await context.SaveChangesAsync() > 0); } } catch (Exception ex) { throw ex; } }
public async Task <List <BookStore> > GetStockBooks(List <int> bookIds) { try { using (var context = new HDBContext()) { return(await context.BookStore .Where(b => bookIds.Contains(b.BookId) && b.StockCount > 0) .ToListAsync()); } } catch (Exception ex) { throw ex; } }
public async Task <bool> AddBook(Book book, BookStore bookStore) { try { using (var context = new HDBContext()) { await context.Book.AddAsync(book); await context.BookStore.AddAsync(bookStore); return(await context.SaveChangesAsync() > 0); } } catch (Exception ex) { throw ex; } }
public async Task <List <Book> > GetBooks(string searchText) { try { using (var context = new HDBContext()) { return(await context.Book .Include(b => b.BookStore) .Where(b => b.BookStore.StockCount > 0 && b.IsActive == true && (String.IsNullOrEmpty(searchText) || (b.Title + b.Author).ToLower().Contains(searchText.ToLower())) ) .ToListAsync()); } } catch (Exception ex) { throw ex; } }
public async Task <List <User> > GetUsers(string searchText) { try { using (var context = new HDBContext()) { return(await context.User .Include(u => u.UserRole) .Where(u => u.Isactive == true && (String.IsNullOrEmpty(searchText) || (u.FirstName + u.LasName).ToLower().Contains(searchText.ToLower())) ) .ToListAsync()); } } catch (Exception ex) { throw ex; } }
public async Task <bool> DeleteBook(int id) { try { using (var context = new HDBContext()) { var bookData = await context.Book.FirstOrDefaultAsync(b => b.BookId == id && b.IsActive == true); if (bookData != null) { bookData.IsActive = false; bookData.UpdatedDate = DateTime.UtcNow; } return(await context.SaveChangesAsync() > 0); } } catch (Exception ex) { throw ex; } }
private void AddButton_OnClicked(object sender, EventArgs e) { try { var paitent = new Patient { Name = nameEntry.Text, Age = int.Parse(ageEntry.Text), Cholestoral = (int)colSlider.Value, BloodPressure = (int)bloodSlider.Value, AddDateTime = DateTime.Now }; switch (cpPicker.SelectedItem as string) { case "Non Anginal Pain": paitent.ChestPain = ChestPain.NonAnginalPain; break; case "Atypical Angina": paitent.ChestPain = ChestPain.AtypicalAngina; break; case "Typical Angina": paitent.ChestPain = ChestPain.TypicalAngina; break; case "Asymptomatic": paitent.ChestPain = ChestPain.asymptomatic; break; } switch (sexPicker.SelectedItem as string) { case "زن": paitent.Sex = Sex.Female; break; case "مرد": paitent.Sex = Sex.Male; break; } paitent.IsSick = DecisionTree.GetTree().Evaluate(paitent); using (var _context = new HDBContext()) { _context.Patients.Add(paitent); _context.SaveChanges(); } Rg.Plugins.Popup.Services.PopupNavigation.Instance.PopAllAsync(true); Rg.Plugins.Popup.Services.PopupNavigation.Instance.PushAsync(new PopupPage { Content = new PatientDialog(paitent), CloseWhenBackgroundIsClicked = true }, true); } catch (Exception exception) { Console.WriteLine(exception); throw; } }
public MainPage() { try { Patients = new ObservableCollection <Patient>(); using (var _context = new HDBContext()) { _context.Patients.ToList().ForEach(p => Patients.Add(p)); } var entries = new List <ChartEntry>(); for (int i = -1; i < 2; i++) { var day = DateTime.Now.AddDays(i); entries.Add(new ChartEntry(Patients.Count(p => p.AddDateTime.Date == day.Date)) { Label = day.ToShortDateString(), TextColor = SKColor.Parse("#fff"), Color = SKColor.Parse("#eee"), ValueLabel = Patients.Count(p => p.AddDateTime.Date == day.Date).ToString() }); } InitializeComponent(); mainChart.Chart = new LineChart() { Entries = entries, LineMode = LineMode.Straight, PointMode = PointMode.Square, BackgroundColor = SKColor.Parse("#3399FF"), LabelColor = SKColor.Parse("#fff"), Margin = 0 }; mainChartB.Chart = new RadialGaugeChart() { Entries = new List <ChartEntry> { new ChartEntry(Patients.Count(p => p.IsSick)) { Color = SKColor.Parse("#2ecc71"), TextColor = SKColor.Parse("#eee"), ValueLabel = Patients.Count(p => p.IsSick).ToString(), Label = "NotSick" }, new ChartEntry(Patients.Count(p => p.IsSick == false)) { Color = SKColor.Parse("#e74c3c"), TextColor = SKColor.Parse("#eee"), ValueLabel = Patients.Count(p => p.IsSick == false).ToString(), Label = "Sick" }, }, BackgroundColor = SKColor.Parse("#3399FF"), LabelColor = SKColor.Parse("#fff"), Margin = 0 }; mainCollection.ItemsSource = Patients; } catch (Exception e) { Console.WriteLine(e); throw; } }