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;
}
}
