private void btnIssueBook_Click(object sender, RoutedEventArgs e)
{
int id = int.Parse(txtIssueStdId.Text);
try {
if (context.BOOKS.Any(o => o.ss_id == txtIssueBookId.Text) && context.STUDENTS.Any(o => o.std_id == id))
{
var issue = new BOOK_ISSUES
{
book_id = txtIssueBookId.Text,
issue_date = DateTime.Today.ToString("dd-MM-yyyy"),
std_id = int.Parse(txtIssueStdId.Text)
};
context.BOOK_ISSUES.Add(issue);
context.SaveChanges();
}
}
catch (Exception ex)
{
lblIssueMsg.Content = "Your Book is issued";
}
}
private void btnReturnBook_Click(object sender, RoutedEventArgs e)
{
int id = int.Parse(txtRtnIssueId.Text);
try
{
if (context.BOOK_ISSUES.Any(o => o.book_issue_id == id))
{
var issue = new BOOK_RETURN
{
issue_id = int.Parse(txtRtnIssueId.Text),
issue_date = DateTime.Today.ToString("dd-MM-yyyy"),
};
context.BOOK_RETURN.Add(issue);
context.SaveChanges();
try
{
var record = new BOOK_ISSUES {
book_issue_id = id
};
context.BOOK_ISSUES.Attach(record);
context.BOOK_ISSUES.Remove(record);
context.SaveChanges();
}
catch (Exception ex)
{
throw new Exception(ex.InnerException.Message);
}
}
}
catch (Exception ex)
{
lblRtnMsg.Content = "Please fill the field correctly";
}
}