private void baddReader_Click(object sender, EventArgs e)
{
bool success = false;
if (tbName.Text.Trim().Equals(""))
{
tbName.BackColor = Color.Tomato;
return;
}
if (tbSurname.Text.Trim().Equals(""))
{
tbSurname.BackColor = Color.Tomato;
return;
}
if (tbPassport.Text.Trim().Equals(""))
{
tbPassport.BackColor = Color.Tomato;
return;
}
if (tbAddress.Text.Trim().Equals(""))
{
tbAddress.BackColor = Color.Tomato;
return;
}
if (tbPhoneNumber.Text.Trim().Equals(""))
{
tbPhoneNumber.BackColor = Color.Tomato;
return;
}
using (context = new LibContext(LibConnection.GetConnString()))
{
context.Connection.Open();
readers newReader = new readers();
fillReader(newReader);
try
{
context.readers_.InsertOnSubmit(newReader);
context.SubmitChanges();
success = true;
}
catch (System.Exception ex)
{
success = false;
throw new Exception($"Error: Could not add reader\n", ex);;
}
if (success)
{
Close();
}
}
}
private void btnDone_Click(object sender, EventArgs e)
{
using (context = new LibContext(LibConnection.GetConnString()))
{
var book1 = context.books.Where(b => b.bID == book.bID).First();
fillBook(book1);
var author1 = context.authors.Where(a => a.bID == book.bID);
if (viewAuthors.RowCount - 1 >= author1.Count())
{
int i = 0;
foreach (var a in author1)
{
fillAuthor(a, i, book.bID);
i++;
}
if (viewAuthors.RowCount > author1.Count())
{
for (int j = i; j < viewAuthors.RowCount - 1; j++)
{
Author a = new Author();
fillAuthor(a, j, book.bID);
context.authors.InsertOnSubmit(a);
}
}
}
else
{
int i = 0;
foreach (var a in author1)
{
if (i < viewAuthors.RowCount - 1)
{
fillAuthor(a, i, book.bID);
}
else
{
context.authors.DeleteOnSubmit(a);
}
i++;
}
}
context.SubmitChanges();
}
btnDone.Visible = false;
btnDelete.Visible = false;
btnEdit.Visible = true;
foreach (Control c in tabControl.Controls)
{
c.Enabled = false;
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
using (context = new LibContext(LibConnection.GetConnString()))
{
var bookDel = context.books.Where(b => b.bID == book.bID).First();
context.books.DeleteOnSubmit(bookDel);
var auths = context.authors.Where(a => a.bID == book.bID);
foreach (var a in auths)
{
context.authors.DeleteOnSubmit(a);
}
context.SubmitChanges();
}
this.Close();
}
private void btnAdd_Click(object sender, EventArgs e)
{
bool succsse = true;
if (tbCode.Text.Trim().Equals("") || tbName.Text.Trim().Equals(""))
{
if (tbCode.Text.Trim().Equals(""))
{
tbCode.BackColor = Color.Tomato;
}
if (tbName.Text.Trim().Equals(""))
{
tbName.BackColor = Color.Tomato;
}
return;
}
using (LibContext context = new LibContext(LibConnection.GetConnString()))
{
Category newCategory;
fillCategory(out newCategory);
try
{
context.categories.InsertOnSubmit(newCategory);
context.SubmitChanges();
}
catch (System.Exception ex)
{
succsse = false;
MessageBox.Show(this, "Error: Could not add category\n" +
"Original error: " + ex.Message, "Error",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
if (succsse)
{
tbName.Clear();
tbCode.Clear();
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
bool success = true;
if (tbName.Text.Trim().Equals(""))
{
tbName.BackColor = Color.Tomato;
return;
}
using (context = new LibContext(LibConnection.GetConnString()))
{
context.Connection.Open();
for (int j = 0; j < nadCount.Value; j++)
{
Book newBook = new Book();
fillBook(newBook);
try
{
context.Transaction = context.Connection.BeginTransaction();
try
{
context.books.InsertOnSubmit(newBook);
context.SubmitChanges();
}
catch (System.Exception ex)
{
throw new Exception($"Error: Could not add book\n", ex);;
}
if (viewAuthors.Rows[0].Cells[0].Value != null)
{
for (int i = 0; i < viewAuthors.RowCount - 1; i++)
{
Author newAuthor = new Author();
fillAuthor(newAuthor, i, newBook.bID);
try
{
context.authors.InsertOnSubmit(newAuthor);
context.SubmitChanges();
}
catch (System.Exception ex)
{
throw new Exception($"Error: Could not add author N{i}", ex);
}
}
}
context.Transaction.Commit();
}
catch (System.Exception ex)
{
context.Transaction.Rollback();
//context.Connection.Close();
success = false;
MessageBox.Show(this, ex.Message + "\n" + "Original Error: " +
ex.InnerException?.Message, "Error",
MessageBoxButtons.OK, MessageBoxIcon.Error);
break;
}
//context.Connection.Close();
}
}
if (success)
{
this.Close();
}
}
