private void btnSave_Click(object sender, EventArgs e)
{
if (txtTitle.Text.Length < 1 && ((txtEmail.Text.Length < 5) || (mtxtMN.Text.Length < 8)))
{
MessageBox.Show("Requires at least a valid name and contact");
}
else
{
SA45TEAM01ALibraryEntities context = new SA45TEAM01ALibraryEntities();
User newUser = new User();
using (TransactionScope ts = new TransactionScope())
{
newUser.Name = txtTitle.Text;
newUser.Email = txtEmail.Text;
newUser.Phone_no = int.Parse(mtxtMN.Text);
newUser.Category = cmbMemType.Text;
context.Users.Add(newUser);
context.SaveChanges();
ts.Complete();
}
Messages A = new Messages();
A.SaveMessage();
txtTitle.Clear();
txtEmail.Clear();
mtxtMN.Clear();
}
}
private void Save_Click(object sender, EventArgs e)
{
newAuthor = txtAuthor.Text;
newTitle = txtAuthor.Text;
newYP = Convert.ToInt32(cmbYear.SelectedText);
newGenre = txtGenre.Text;
newLG = txtLanguage.Text;
newISBN = txbISBN.Text;
int a = int.Parse(mtxtBID.Text);
SA45TEAM01ALibraryEntities d = new SA45TEAM01ALibraryEntities();
booklist b = d.booklists.Where(x => x.Book_ID == a).First();
if ((b.Author != newAuthor) || (b.Title != newTitle) || (b.Year_of_Publication != newYP) || (b.Category != newGenre) || (b.Language != newLG) || (b.ISBN != newISBN))
{
b.Author = newAuthor;
b.Title = newTitle;
b.Year_of_Publication = newYP;
b.Category = newGenre;
b.Language = newLG;
b.ISBN = newISBN;
d.SaveChanges();
Messages A = new Messages();
A.SaveMessage();
}
else
{
MessageBox.Show("Please make edits in order to Save or click Cancel to Return to Books Menu");
}
}
private void btnDel_Click(object sender, EventArgs e)
{
string qq2 = mtextUID.Text.TrimStart(new Char[] { '0' });
DialogResult result = MessageBox.Show("Confirm Delete?", "Warning!", MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
SA45TEAM01ALibraryEntities context = new SA45TEAM01ALibraryEntities();
User a = context.Users.Where(x => x.User_ID.ToString() == qq2).FirstOrDefault();
using (TransactionScope ts = new TransactionScope())
{
a.Status = "Inactive";
context.SaveChanges();
ts.Complete();
}
btnSearch.Visible = true;
mtextUID.Text = String.Empty;
mtextUID.BackColor = System.Drawing.SystemColors.Window;
mtextUID.ReadOnly = false;
lblName.Visible = false;
lblEmail.Visible = false;
lblPN.Visible = false;
txtName.Visible = false;
txtEmail.Visible = false;
mtextPN.Visible = false;
btnDel.Visible = false;
btnClear.Visible = false;
toolStripStatusLabel1.Text = "Input User_ID and click Search";
Messages A = new Messages();
A.SaveMessage();
}
}
private void newDataPlease()
{
SA45TEAM01ALibraryEntities c = new SA45TEAM01ALibraryEntities();
var q = from x in c.booklists select new { x.ISBN, x.Title, x.Book_ID, x.Language, x.Category, x.Author, x.Year_of_Publication };
dataGridView1.DataSource = q.ToList();
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (getSInputs() > 0)
{
using (TransactionScope ts = new TransactionScope())
{
SA45TEAM01ALibraryEntities c = new SA45TEAM01ALibraryEntities();
booklist a = new booklist();
a.ISBN = txtTitle.Text.ToString();
a.Title = txtTitle.Text.ToString();
a.Language = txtLanguage.Text.ToString();
a.Category = txtGenre.Text.ToString();
a.Author = txtAuthor.Text.ToString();
a.Year_of_Publication = Convert.ToInt32(cmbYear.SelectedText);//Convert.ToInt32(cmbYear.Text);
c.booklists.Add(a);
c.SaveChanges();
ts.Complete();
}
Messages A = new Messages();
A.SaveMessage();
}
else
{
MessageBox.Show("Please Add in Relevant info before Adding new Books");
}
}
private void btnRefresh_click()
{
SA45TEAM01ALibraryEntities context = new SA45TEAM01ALibraryEntities();
var q = context.Users.Where(x => x.Status != "Inactive").Select(x => new { x.User_ID, x.Name, x.Email, x.Phone_no, x.Book_due, x.Category, x.Status });
dataGridView1.DataSource = q.ToList();
}
private void ViewMembers_Load(object sender, EventArgs e)
{
SA45TEAM01ALibraryEntities context = new SA45TEAM01ALibraryEntities();
var q = context.Users.Where(x => x.Status != "Inactive").Select(x => new { x.User_ID, x.Name, x.Email, x.Phone_no, x.Book_due, x.Category, x.Status });
dataGridView1.DataSource = q.ToList();
}
private void btnSubmit_Click(object sender, EventArgs e)
{
int rV = 0;
foreach (DataGridViewRow dg in dataGridView1.Rows)
{
if (Convert.ToBoolean(dg.Cells[0].Value) == true)
{
rV++;
}
}
if (rV > 0 && (txtName.Text.Length > 0))
{
DialogResult result = new DialogResult();
result = MessageBox.Show("Proceed with borrowing?", "Borrowing books", MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
SA45TEAM01ALibraryEntities context = new SA45TEAM01ALibraryEntities();
using (TransactionScope ts = new TransactionScope())
{
foreach (DataGridViewRow dgRow in dataGridView1.Rows)
{
if (dgRow.Cells[0].Value != null)
{
int selected1 = Convert.ToInt32(dgRow.Cells[3].Value.ToString());
int newIssueID = context.Issue_Details.Select(x => x.Issue_ID).Max() + 1;
Issue_Details id = new Issue_Details();
id.Issue_ID = newIssueID;
id.Issue_Date = DateTime.Today.ToString();
id.Due_Date = DateTime.Today.AddDays(20).ToString();
id.Book_ID = selected1;
id.User_ID = Convert.ToInt32(txtID.Text.ToString());
id.Rental_Status = "OUT";
id.Return_Date = null;
context.Issue_Details.Add(id);
string uid = txtID.Text;
User m = context.Users.Where(x => x.User_ID.ToString() == uid).First();
m.Book_due++;
context.SaveChanges();
}
}
ts.Complete();
}
FormBorrow();
}
}
else if (rV > 0)
{
MessageBox.Show("Please input a valid user id");
}
else
{
MessageBox.Show("Please select checkboxes for books to borrow");
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
string qq2 = mtextUID.Text.TrimStart(new Char[] { '0' });
if (qq2.Length < 1)
{
MessageBox.Show("Please input a valid ID");
}
else
{
SA45TEAM01ALibraryEntities context = new SA45TEAM01ALibraryEntities();
string q = "";
try
{
q = context.Users.Where(x => x.User_ID.ToString() == qq2).Where(x => x.Status != "Inactive").Select(x => x.Name).First();
}
catch (Exception)
{
MessageBox.Show("Invalid ID. Please try again.");
mtextUID.Text = String.Empty;
}
if (q.Length < 1)
{
}
else
{
btnSearch.Visible = false;
mtextUID.BackColor = System.Drawing.SystemColors.ScrollBar;
mtextUID.ReadOnly = true;
lblName.Visible = true;
lblEmail.Visible = true;
lblPN.Visible = true;
lblCat.Visible = true;
txtName.Visible = true;
txtEmail.Visible = true;
mtextPN.Visible = true;
cboxCat.Visible = true;
btnSave.Visible = true;
btnClear.Visible = true;
toolStripStatusLabel1.Text = "Click Save to Confirm, Cancel to Close Screen";
txtName.Text = q;
string q1 = context.Users.Where(x => x.User_ID.ToString() == qq2).Select(x => x.Email).First();
txtEmail.Text = q1;
int?q2 = context.Users.Where(x => x.User_ID.ToString() == qq2).Select(x => x.Phone_no).First();
mtextPN.Text = q2.ToString();
string q3 = context.Users.Where(x => x.User_ID.ToString() == qq2).Select(x => x.Category).First();
cboxCat.Text = q3;
}
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
//SA45TEAM01ALibraryEntities d = new SA45TEAM01ALibraryEntities();
//int a = int.Parse(Book_ID);
//booklist b = d.booklists.Where(x => x.Book_ID == a).First();
//b.Disposed = "Yes";
//d.SaveChanges();
//MessageBox.Show("Deleted Successfully");
int rV = 0;
foreach (DataGridViewRow dg in dataGridView1.Rows)
{
if (Convert.ToBoolean(dg.Cells[0].Value) == true)
{
rV++;
}
}
if (rV > 0)
{
DialogResult dr = MessageBox.Show("Confirm Deletion for these row(s)?", "Warning!", MessageBoxButtons.YesNo);
if (dr == DialogResult.Yes)
{
SA45TEAM01ALibraryEntities context = new SA45TEAM01ALibraryEntities();
foreach (DataGridViewRow dg in dataGridView1.Rows)
{
if (Convert.ToBoolean(dg.Cells[0].Value) == true)
{
int x2 = Convert.ToInt32(dg.Cells[3].Value);
var q = context.booklists.Where(x => x.Book_ID == x2).FirstOrDefault();
booklist A = q;
using (TransactionScope ts = new TransactionScope())
{
q.Disposed = "Yes";
context.SaveChanges();
ts.Complete();
}
}
}
Messages newM = new Messages();
newM.SaveMessage();
newDataPlease();
}
}
else
{
MessageBox.Show("Please select checkbox(es) to delete first");
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
int rV = 0;
foreach (DataGridViewRow dg in dataGridView1.Rows)
{
if (Convert.ToBoolean(dg.Cells[0].Value) == true)
{
rV++;
}
}
if (rV > 0)
{
DialogResult dr = MessageBox.Show("Confirm Deletion for these row(s)?", "Warning!", MessageBoxButtons.YesNo);
if (dr == DialogResult.Yes)
{
SA45TEAM01ALibraryEntities context = new SA45TEAM01ALibraryEntities();
foreach (DataGridViewRow dg in dataGridView1.Rows)
{
if (Convert.ToBoolean(dg.Cells[0].Value) == true)
{
int x2 = Convert.ToInt32(dg.Cells[1].Value);
var q = context.Users.Where(x => x.User_ID == x2).FirstOrDefault();
User A = q;
using (TransactionScope ts = new TransactionScope())
{
q.Status = "Inactive";
context.SaveChanges();
ts.Complete();
}
}
}
Messages newM = new Messages();
newM.SaveMessage();
btnRefresh_click();
}
}
else
{
this.Hide();
var newDMForm = new DeleteMember();
newDMForm.Closed += (s, args) => this.Close();
newDMForm.Show();
}
}
private void Search_Click(object sender, EventArgs e)
{
SA45TEAM01ALibraryEntities d = new SA45TEAM01ALibraryEntities();
try
{
int a = int.Parse(mtxtBID.Text);
var qty = from x in d.booklists where x.Book_ID == a select x;
string isbn = qty.Single().ISBN;
string title = qty.Single().Title;
int bookid = qty.Single().Book_ID;
string lang = qty.Single().Language;
string categ = qty.Single().Category;
string author = qty.Single().Author;
int? yop = qty.Single().Year_of_Publication;
txtTitle.Text = title;
txtAuthor.Text = author;
cmbYear.Text = yop.ToString();
txtGenre.Text = categ;
txtLanguage.Text = lang;
txbISBN.Text = isbn;
panelTB.Visible = true;
panelBTN.Visible = true;
}
catch (Exception)
{
MessageBox.Show("Invalid ID entered");
}
if (txtTitle.Text.Length > 0)
{
mtxtBID.Enabled = false;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
string qq2 = mtextUID.Text.TrimStart(new Char[] { '0' });
if (txtName.Text.Length < 1)
{
MessageBox.Show("Please Enter a valid name");
}
else
{
SA45TEAM01ALibraryEntities context = new SA45TEAM01ALibraryEntities();
User a = context.Users.Where(x => x.User_ID.ToString() == qq2).FirstOrDefault();
newName = txtName.Text;
newEmail = txtEmail.Text;
newCat = cboxCat.Text;
newPN = Convert.ToInt32(mtextPN.Text);
string q = context.Users.Where(x => x.User_ID.ToString() == qq2).Select(x => x.Name).First();
string q1 = context.Users.Where(x => x.User_ID.ToString() == qq2).Select(x => x.Email).First();
int? q2 = context.Users.Where(x => x.User_ID.ToString() == qq2).Select(x => x.Phone_no).First();
string q3 = context.Users.Where(x => x.User_ID.ToString() == qq2).Select(x => x.Category).First();
using (TransactionScope ts = new TransactionScope())
{
if (newName != q)
{
a.Name = newName;
}
if (newPN != q2)
{
a.Phone_no = newPN;
}
if (newEmail != q1)
{
a.Email = newEmail;
}
if (newCat != q3)
{
a.Category = newCat;
}
context.SaveChanges();
ts.Complete();
}
btnSearch.Visible = true;
mtextUID.Text = String.Empty;
mtextUID.BackColor = System.Drawing.SystemColors.Window;
mtextUID.ReadOnly = false;
lblName.Visible = false;
lblEmail.Visible = false;
lblPN.Visible = false;
lblCat.Visible = false;
txtName.Visible = false;
txtEmail.Visible = false;
mtextPN.Visible = false;
cboxCat.Visible = false;
btnSave.Visible = false;
btnClear.Visible = false;
toolStripStatusLabel1.Text = "Input User_ID and click Search";
Messages A = new Messages();
A.SaveMessage();
}
}
