static Accaunt GetAccauntID(LibraryEntities1 context, int accauntID)
{
Accaunt accaunt = context.Accaunts.FirstOrDefault(
p => p.AccauntID == accauntID);
return(accaunt);
}
private void buttonLogin_Click(object sender, EventArgs e)
{
LibraryEntities1 context = new LibraryEntities1();
var accaunts = context.Accaunts;
bool flag = false;
foreach (var item in accaunts)
{
if (textBoxLogin.Text.Trim() == item.Login.Trim() && CalculateSHA1(textBoxPassword.Text).Trim() == item.PasswordSHA1.Trim())
{
flag = true;
Menu formMenu = new Menu(0);
formMenu.Show();
}
if (textBoxLogin.Text.Trim() == "administrator".Trim() && CalculateSHA1(textBoxPassword.Text).Trim() == item.PasswordSHA1.Trim())
{
flag = true;
Menu formMenu = new Menu(1);
formMenu.Show();
}
}
if (!flag)
{
MessageBox.Show("Грешка! Невалидна парола!");
InitializeMyControl();
Clear();
}
Clear();
}
static void DeleteAccaunt(int accauntID)
{
LibraryEntities1 context = new LibraryEntities1();
Accaunt accaunt = GetAccauntID(context, accauntID);
context.Accaunts .DeleteObject(accaunt);
context.SaveChanges();
}
private void FormNewBook_Load(object sender, EventArgs e)
{
LibraryEntities1 context = new LibraryEntities1();
dataGridViewAuthors.AutoGenerateColumns = false;
dataGridViewAuthors.DataSource = from a in context.Authors
orderby a.LName
select a;
foreach (DataGridViewRow row in dataGridViewAuthors.SelectedRows)
{
row.Selected = false;
}
//категории - зареждане на комбото
var categories = context.Categories;
comboBoxCategory.DataSource = categories;
comboBoxCategory.ValueMember = "CategoryID";
comboBoxCategory.DisplayMember = "CategoryName";
//зареждане на комбото с език
var languages = context.Languages;
comboBoxLanguage.DataSource = languages;
comboBoxLanguage.ValueMember = "LanguageID";
comboBoxLanguage.DisplayMember = "LanguageName";
}
private void buttonRefresh_Click(object sender, EventArgs e)
{
LibraryEntities1 context = new LibraryEntities1();
var clients = context.Clients;
dataGridViewClients.AutoGenerateColumns = false;
dataGridViewClients.DataSource = clients;
}
private void buttonSearch_Click(object sender, EventArgs e)
{
LibraryEntities1 context = new LibraryEntities1();
if (textBoxAuthor.Text != "")
{
string lastName = textBoxAuthor.Text;
bool flag = false;
foreach (DataGridViewRow row in dataGridViewAuthors.Rows)
{
row.Selected = false;
if (row.Cells[2].Value != null && row.Cells[2].Value.ToString() == lastName)
{
row.Selected = true;
flag = true;
break;
}
}
if (!flag)
{
MessageBox.Show("Този автор не съществува в базата!");
}
}
else
{
MessageBox.Show("Грешка! Не сте въвели данни за автара!");
}
}
static void ModifyBookRejection(int bookID, bool newRejection)
{
LibraryEntities1 context = new LibraryEntities1();
Book book = GetBookID(context, bookID);
book.Rejection = newRejection;
context.SaveChanges();
}
private void radioButtonAll_CheckedChanged(object sender, EventArgs e)
{
LibraryEntities1 context = new LibraryEntities1();
var clients = context.Clients;
dataGridViewClients.AutoGenerateColumns = false;
dataGridViewClients.DataSource = clients;
}
static Book GetBookByInvNumber(LibraryEntities1 context, string invNum)
{
Book book = context.Books.FirstOrDefault(
p => p.InvNum == invNum);
return(book);
}
private void CurrentClient_Load(object sender, EventArgs e)
{
LibraryEntities1 context = new LibraryEntities1();
Client clients = GetClientByID(context, id);
textBoxFName.Text = clients.FName;
textBoxSName.Text = clients.SName;
textBoxLName.Text = clients.LName;
textBoxEGN.Text = clients.EGN;
textBoxAdress.Text = clients.Adress;
textBoxPhone.Text = clients.Phone;
textBoxEmail.Text = clients.Email;
textBoxLeaving.Text = clients.Leaving.ToString();;
var books =
from cl in context.ClientsBooks
join book in context.Books on cl.BookID equals book.BookID
where (cl.ClientID == id) && (cl.Returned == false) && (cl.Reservation == false)
select book;
if (books != null)
{
dataGridViewLoaned.AutoGenerateColumns = false;
dataGridViewLoaned.DataSource = books;
}
}
private void buttonReturn_Click(object sender, EventArgs e)
{
LibraryEntities1 context = new LibraryEntities1();
List <int> books = new List <int>();
foreach (DataGridViewRow row in dataGridViewLoaned.SelectedRows)
{
if (row.Cells[0].Value != null)
{
books.Add(Convert.ToInt32(row.Cells[0].Value));
}
}
if (books.Count > 0)
{
var client = (from c in context.Clients
where c.ClientID == id
select c).SingleOrDefault();
foreach (ClientsBook cBook in client.ClientsBooks)
{
if (books.Contains(cBook.BookID))
{
cBook.Returned = true;
MessageBox.Show("Връщане - успешно!");
}
}
context.SaveChanges();
}
}
private void buttonSearchEGN_Click(object sender, EventArgs e)
{
string egn = textBox1EGN.Text;
LibraryEntities1 context = new LibraryEntities1();
if (egn != "")
{
Client client = context.Clients.FirstOrDefault(
p => p.EGN == egn);
textBoxClient.Text = client.ClientID.ToString();
textBoxFName.Text = client.FName.ToString();
textBoxSName.Text = client.SName.ToString();
textBoxLName.Text = client.LName.ToString();
textBoxEGN.Text = client.EGN.ToString();
textBoxAdress.Text = client.Adress.ToString();
textBoxPhone.Text = client.Phone.ToString();
textBoxEmail.Text = client.Email.ToString();
textBoxLeaving.Text = client.Leaving.ToString();
//int genderID= client.GenderID;
//comboBoxGender.SelectedValue=genderID
}
else
{
MessageBox.Show("Несте въвели ЕГН!");
}
}
private void buttonReLoan_Click(object sender, EventArgs e)
{
LibraryEntities1 context = new LibraryEntities1();
List<int> books = new List<int>();
foreach (DataGridViewRow row in dataGridViewLoaned.SelectedRows)
{
if (row.Cells[0].Value != null)
{
books.Add(Convert.ToInt32(row.Cells[0].Value));
}
}
if (books.Count > 0)
{
var client = (from c in context.Clients
where c.ClientID == id
select c).SingleOrDefault();
foreach (ClientsBook cBook in client.ClientsBooks)
{
if (books.Contains(cBook.BookID))
{
cBook.DateLoaned = DateTime.Now;
cBook.DateReturned = DateTime.Now.AddMonths(1);
MessageBox.Show("Презаписването е успешно!");
}
}
context.SaveChanges();
}
}
private void buttonSearchID_Click(object sender, EventArgs e)
{
LibraryEntities1 context = new LibraryEntities1();
if (textBoxClient.Text != "")
{
int clientID = Int32.Parse(textBoxClient.Text);
if (clientID != 0)
{
Client client = context.Clients.FirstOrDefault(
p => p.ClientID == clientID);
textBoxFName.Text = client.FName.ToString();
textBoxSName.Text = client.SName.ToString();
textBoxLName.Text = client.LName.ToString();
textBoxEGN.Text = client.EGN.ToString();
textBoxAdress.Text = client.Adress.ToString();
textBoxPhone.Text = client.Phone.ToString();
textBoxEmail.Text = client.Email.ToString();
textBoxLeaving.Text = client.Leaving.ToString();
}
}
else
{
MessageBox.Show("Несте въвели читателски номер!");
}
}
static Client GetClientByEGN(LibraryEntities1 context, string egn)
{
Client client = context.Clients.FirstOrDefault(
c => c.EGN == egn);
return(client);
}
static Client GetClientByID(LibraryEntities1 context, int clientID)
{
Client client = context.Clients.FirstOrDefault(
c => c.ClientID == clientID);
return(client);
}
static Book GetBookByID(LibraryEntities1 context, int bookID)
{
Book book = context.Books.FirstOrDefault(
p => p.BookID == bookID);
return(book);
}
private void buttonLogin_Click(object sender, EventArgs e)
{
LibraryEntities1 context = new LibraryEntities1();
var accaunts = context.Accaunts;
bool flag = false;
foreach (var item in accaunts)
{
if (textBoxLogin.Text.Trim() == item.Login.Trim() && CalculateSHA1(textBoxPassword.Text).Trim()== item.PasswordSHA1.Trim())
{
flag = true;
Menu formMenu = new Menu(0);
formMenu.Show();
}
if (textBoxLogin.Text.Trim() == "administrator".Trim () && CalculateSHA1(textBoxPassword.Text).Trim() == item.PasswordSHA1.Trim())
{
flag = true;
Menu formMenu = new Menu(1);
formMenu.Show();
}
}
if (!flag)
{
MessageBox.Show("Грешка! Невалидна парола!");
InitializeMyControl();
Clear();
}
Clear();
}
static void ModifyBookRejection(int bookID, bool newRejection)
{
LibraryEntities1 context = new LibraryEntities1();
Book book = GetBookID(context, bookID);
book.Rejection = newRejection;
context.SaveChanges();
}
static void DeleteAccaunt(int accauntID)
{
LibraryEntities1 context = new LibraryEntities1();
Accaunt accaunt = GetAccauntID(context, accauntID);
context.Accaunts.DeleteObject(accaunt);
context.SaveChanges();
}
private void tabPage2_Click(object sender, EventArgs e)
{
LibraryEntities1 context = new LibraryEntities1();
var accaunts = context.Accaunts;
dataGridViewAccaunt.AutoGenerateColumns = false;
dataGridViewAccaunt.DataSource = accaunts;
}
private void FormCategories_Load(object sender, EventArgs e)
{
LibraryEntities1 context = new LibraryEntities1();
var categories = context.Categories ;
dataGridViewCategories.AutoGenerateColumns = false;
dataGridViewCategories.DataSource = categories;
buttonAdd.Enabled = false;
}
private void radioButtonAll_CheckedChanged(object sender, EventArgs e)
{
LibraryEntities1 context = new LibraryEntities1();
var clients = context.Clients;
dataGridViewClients.AutoGenerateColumns = false;
dataGridViewClients.DataSource = clients;
}
private void buttonRefresh_Click(object sender, EventArgs e)
{
LibraryEntities1 context = new LibraryEntities1();
var clients = context.Clients;
dataGridViewClients.AutoGenerateColumns = false;
dataGridViewClients.DataSource = clients;
}
private void buttonNew_Click(object sender, EventArgs e)
{
NewClient cl = new NewClient();
cl.Show();
LibraryEntities1 context = new LibraryEntities1();
var clients = context.Clients;
dataGridViewClients.AutoGenerateColumns = false;
dataGridViewClients.DataSource = clients;
}
private void FormCategories_Load(object sender, EventArgs e)
{
LibraryEntities1 context = new LibraryEntities1();
var categories = context.Categories;
dataGridViewCategories.AutoGenerateColumns = false;
dataGridViewCategories.DataSource = categories;
buttonAdd.Enabled = false;
}
private void tabControl1_Selecting(object sender, TabControlCancelEventArgs e)
{
textBoxLogin.Focus();
LibraryEntities1 context = new LibraryEntities1();
var accaunts = context.Accaunts;
dataGridViewAccaunt.AutoGenerateColumns = false;
dataGridViewAccaunt.DataSource = accaunts;
}
private void printDocument1_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e)
{
string egn = textBoxEGN.Text;
LibraryEntities1 context = new LibraryEntities1();
Client cl = context.Clients.FirstOrDefault(
p => p.EGN == egn);
string s = "Училищна библиотека\nЧитателска карта\n\n" + "Име: " + cl.FName + " " + cl.LName + "\n" + "Читателски номер: " + cl.ClientID;
e.Graphics.DrawString(s, textBoxFName.Font, new SolidBrush(Color.Black), new Point(50, 50));
}
private void radioButtonLate_CheckedChanged(object sender, EventArgs e)
{
LibraryEntities1 context = new LibraryEntities1();
var cBooks = context.ClientsBooks.ToList().FindAll(c => c.DateLoaned.AddMonths(1) < DateTime.Now);
var clients = context.Clients.ToList();
var dataSource = clients.FindAll(c => cBooks.Exists(cb => cb.ClientID == c.ClientID));
dataGridViewClients.AutoGenerateColumns = false;
dataGridViewClients.DataSource = dataSource;
}
private void radioButtonLate_CheckedChanged(object sender, EventArgs e)
{
LibraryEntities1 context = new LibraryEntities1();
var cBooks = context.ClientsBooks.ToList().FindAll(c => c.DateLoaned.AddMonths(1) < DateTime.Now);
var clients = context.Clients.ToList();
var dataSource = clients.FindAll(c => cBooks.Exists(cb => cb.ClientID == c.ClientID));
dataGridViewClients.AutoGenerateColumns = false;
dataGridViewClients.DataSource = dataSource;
}
private void radioButtonRejected_CheckedChanged(object sender, EventArgs e)
{
LibraryEntities1 context = new LibraryEntities1();
var books =
from book in context.Books
where book.Rejection == true
select book;
dataGridViewBooks.AutoGenerateColumns = false;
dataGridViewBooks.DataSource = books;
}
private void buttonNew_Click(object sender, EventArgs e)
{
NewClient cl = new NewClient();
cl.Show();
LibraryEntities1 context = new LibraryEntities1();
var clients = context.Clients;
dataGridViewClients.AutoGenerateColumns = false;
dataGridViewClients.DataSource = clients;
}
private void radioButtonBooked_CheckedChanged(object sender, EventArgs e)
{
LibraryEntities1 context = new LibraryEntities1();
var books =
from clientbook in context.ClientsBooks
join book in context.Books on clientbook.BookID equals book.BookID
where (clientbook.Reservation == true) && (book.Rejection == false)
select book;
dataGridViewBooks.AutoGenerateColumns = false;
dataGridViewBooks.DataSource = books;
}
private void radioButtonRejected_CheckedChanged(object sender, EventArgs e)
{
LibraryEntities1 context = new LibraryEntities1();
var books =
from book in context.Books
where book.Rejection == true
select book;
dataGridViewBooks.AutoGenerateColumns = false;
dataGridViewBooks.DataSource = books;
}
private void radioButtonReserved_CheckedChanged(object sender, EventArgs e)
{
LibraryEntities1 context = new LibraryEntities1();
var clients =
from clientbook in context.ClientsBooks
join client in context.Clients on clientbook.ClientID equals client.ClientID
where clientbook.Reservation == true
select client;
dataGridViewClients.AutoGenerateColumns = false;
dataGridViewClients.DataSource = clients;
}
private void buttonAdd_Click(object sender, EventArgs e)
{
LibraryEntities1 context = new LibraryEntities1();
//създаваме нова книга чрез конструктора Books()
try
{
if (textBoxInvNum.Text != "" && textBoxTitle.Text != "")
{
Book newBook = new Book();
//на съответните полета присвояваме стойностите от текстовите кутии
newBook.InvNum = textBoxInvNum.Text;
newBook.ISBN = textBoxISBN.Text;
newBook.Title = textBoxTitle.Text;
newBook.Description = textBoxDescription.Text;
newBook.YearPub = Int32.Parse(textBoxYearPubl.Text);
newBook.Price = Decimal.Parse(textBoxPrice.Text);
newBook.Rejection = false;
newBook.CategoryID = Int32.Parse(comboBoxCategory.SelectedValue.ToString());
newBook.LanguageID = Int32.Parse(comboBoxLanguage.SelectedValue.ToString());
// обработка на селектираните редове от DataGridViewAuthors - това са авторите на новата книга
int authorID;//локална променлива
foreach (DataGridViewRow row in dataGridViewAuthors.SelectedRows)
{
authorID = Convert.ToInt32(row.Cells[0].Value);//вземаме стойността Value на ID на автора от текущо селектирания ред - row.Cells[0].Value
//добавяне на данните за автора към свойството Authors на книгата, която обработваме
//свойството не е просто свойство, а е списък (List) от автори
newBook.Authors.Add(context.Authors.ToList().Find(a => a.AuthorID == authorID));
}
//добавяне на новата книга в базата и записване на промените
context.Books.AddObject(newBook);
context.SaveChanges();
MessageBox.Show("Книгата е добавена!");
}
else
{
MessageBox.Show("Грешка! Не сте въвели данни.");
}
}
catch (FormatException)
{
MessageBox.Show("Вие не сте въвели данни! " + "Книгата не е добавена!");
}
if (MessageBox.Show("Ще въвеждате ли други книги?", "Добавяне на книга",
MessageBoxButtons.YesNo) == DialogResult.No)
{
this.Close();
}
else
{
Clear();
}
}
private void radioButtonBooked_CheckedChanged(object sender, EventArgs e)
{
LibraryEntities1 context = new LibraryEntities1();
var books =
from clientbook in context.ClientsBooks
join book in context.Books on clientbook.BookID equals book.BookID
where (clientbook.Reservation == true) && (book.Rejection == false)
select book;
dataGridViewBooks.AutoGenerateColumns = false;
dataGridViewBooks.DataSource = books;
}
private void buttonAdd_Click(object sender, EventArgs e)
{
LibraryEntities1 context = new LibraryEntities1();
//създаваме нова книга чрез конструктора Books()
try
{
if (textBoxInvNum.Text != "" && textBoxTitle.Text != "")
{
Book newBook = new Book();
//на съответните полета присвояваме стойностите от текстовите кутии
newBook.InvNum = textBoxInvNum.Text;
newBook.ISBN = textBoxISBN.Text;
newBook.Title = textBoxTitle.Text;
newBook.Description = textBoxDescription.Text;
newBook.YearPub = Int32.Parse(textBoxYearPubl.Text);
newBook.Price = Decimal.Parse(textBoxPrice.Text);
newBook.Rejection = false;
newBook.CategoryID = Int32.Parse(comboBoxCategory.SelectedValue.ToString());
newBook.LanguageID = Int32.Parse(comboBoxLanguage.SelectedValue.ToString());
// обработка на селектираните редове от DataGridViewAuthors - това са авторите на новата книга
int authorID;//локална променлива
foreach (DataGridViewRow row in dataGridViewAuthors.SelectedRows)
{
authorID = Convert.ToInt32(row.Cells[0].Value);//вземаме стойността Value на ID на автора от текущо селектирания ред - row.Cells[0].Value
//добавяне на данните за автора към свойството Authors на книгата, която обработваме
//свойството не е просто свойство, а е списък (List) от автори
newBook.Authors.Add(context.Authors.ToList().Find(a => a.AuthorID == authorID));
}
//добавяне на новата книга в базата и записване на промените
context.Books.AddObject(newBook);
context.SaveChanges();
MessageBox.Show("Книгата е добавена!");
}
else
{
MessageBox.Show("Грешка! Не сте въвели данни.");
}
}
catch (FormatException)
{
MessageBox.Show("Вие не сте въвели данни! " + "Книгата не е добавена!");
}
if (MessageBox.Show("Ще въвеждате ли други книги?", "Добавяне на книга",
MessageBoxButtons.YesNo) == DialogResult.No)
{
this.Close();
}
else
{
Clear();
}
}
private void radioButtonNotReturned_CheckedChanged(object sender, EventArgs e)
{
LibraryEntities1 context = new LibraryEntities1();
var clients =
(from client in context.Clients
join clientbook in context.ClientsBooks on client.ClientID equals clientbook.ClientID
join book in context.Books on clientbook.BookID equals book.BookID
where clientbook.Returned == false
select client).Distinct();
dataGridViewClients.AutoGenerateColumns = false;
dataGridViewClients.DataSource = clients;
}
private void buttonRefresh_Click(object sender, EventArgs e)
{
LibraryEntities1 context = new LibraryEntities1();
dataGridViewAuthors.AutoGenerateColumns = false;
dataGridViewAuthors.DataSource = from a in context.Authors
orderby a.LName
select a;
foreach (DataGridViewRow row in dataGridViewAuthors.SelectedRows)
{
row.Selected = false;
}
}
private void buttonRefresh_Click(object sender, EventArgs e)
{
LibraryEntities1 context = new LibraryEntities1();
var books =
from cl in context.ClientsBooks
join book in context.Books on cl.BookID equals book.BookID
where (cl.ClientID == id) && (cl.Returned == false) && (cl.Reservation == false)
select book;
if (books!=null )
{
dataGridViewLoaned.AutoGenerateColumns = false;
dataGridViewLoaned.DataSource = books;
}
}
private void FormEditClient_Load(object sender, EventArgs e)
{
LibraryEntities1 context = new LibraryEntities1();
var status = context.Statys;
comboBoxStatus.DataSource = status;
comboBoxStatus.ValueMember = "StatusID";
comboBoxStatus.DisplayMember = "Status";
var gender = context.Genders;
comboBoxGender.DataSource = gender;
comboBoxGender.ValueMember = "GenderID";
comboBoxGender.DisplayMember = "Gender1";
}
private void buttonRefresh_Click(object sender, EventArgs e)
{
LibraryEntities1 context = new LibraryEntities1();
var books =
from cl in context.ClientsBooks
join book in context.Books on cl.BookID equals book.BookID
where (cl.ClientID == id) && (cl.Returned == false) && (cl.Reservation == false)
select book;
if (books != null)
{
dataGridViewLoaned.AutoGenerateColumns = false;
dataGridViewLoaned.DataSource = books;
}
}
private void buttonAdd_Click(object sender, EventArgs e)
{
LibraryEntities1 context = new LibraryEntities1();
Accaunt newAccaunt = new Accaunt()
{
Login = textBoxLogin.Text.Trim(),
PasswordSHA1 =CalculateSHA1(textBoxLogin.Text).Trim(),
FirstName = textBoxFName.Text.Trim(),
LastName = textBoxLName.Text.Trim()
};
context.Accaunts.AddObject(newAccaunt);
context.SaveChanges();
MessageBox.Show("Добавянето е успешно.");
Clear();
}
private void buttonAdd_Click(object sender, EventArgs e)
{
LibraryEntities1 context = new LibraryEntities1();
if (textBoxLName.Text!="")
{
Author newAuthor = new Author()
{
FName = textBoxFName.Text,
LName = textBoxLName.Text
};
context.Authors.AddObject(newAuthor);
context.SaveChanges();
MessageBox.Show("Авторът е добавен.");
}
else MessageBox.Show("Грешка! Няма въведени данни.");
}
private void buttonRejection_Click(object sender, EventArgs e)
{
LibraryEntities1 context = new LibraryEntities1();
bool вooksRejection = false;
foreach (DataGridViewRow item in dataGridViewBooks.Rows)
{
if (item.Cells[3].Value != null)
{
int bookID = Convert.ToInt32(item.Cells[3].Value);
ModifyBookRejection(bookID, true);
вooksRejection = true;
}
}
if (вooksRejection)
{
MessageBox.Show("Отчисляването е успешно!");
}
else MessageBox.Show("Грешка! Няма въведени данни!");
}
private void dataGridViewBooks_RowLeave(object sender, DataGridViewCellEventArgs e)
{
LibraryEntities1 context = new LibraryEntities1();
//взема инв.№, въведен в клетката
if (dataGridViewBooks.CurrentRow.Cells[0].Value != null)
{
string bookInvNumber = dataGridViewBooks.CurrentRow.Cells[0].Value.ToString();
//намираме книга по този инв.№
Book book = GetBookByInvNumber(context, bookInvNumber);
if (book != null)
{
dataGridViewBooks.CurrentRow.Cells[1].Value = book.Title.ToString();
dataGridViewBooks.CurrentRow.Cells[2].Value = book.Rejection;
dataGridViewBooks.CurrentRow.Cells[3].Value = book.BookID;
}
else
{
MessageBox.Show("Грешен инвентарен номер! Книгата не е намерена.");
}
}
}
private void buttonAdd_Click(object sender, EventArgs e)
{
int i = dataGridViewLanguages.CurrentRow.Index;
int LanguageID = (int)dataGridViewLanguages.Rows[i].Cells[0].Value;
string lang = dataGridViewLanguages.Rows[i].Cells[1].Value.ToString();
LibraryEntities1 context = new LibraryEntities1();
if(LanguageID!=0)
{
Language newLanguage = new Language()
{
LanguageName = lang
};
context.Languages.AddObject(newLanguage);
context.SaveChanges();
MessageBox.Show("Добавен е език!");
buttonAdd.Enabled = false;
}
else
{
MessageBox.Show("Грешка! Не сте въвели език.");
this.Close();
}
}
private void buttonAdd_Click(object sender, EventArgs e)
{
int i = dataGridViewCategories.CurrentRow.Index;
int categoryID = (int)dataGridViewCategories.Rows[i].Cells[0].Value;
string category = dataGridViewCategories.Rows[i].Cells[1].Value.ToString();
LibraryEntities1 context = new LibraryEntities1();
if (categoryID != 0)
{
Category newCategory = new Category()
{
CategoryName = category
};
context.Categories.AddObject(newCategory);
context.SaveChanges();
MessageBox.Show("Категорията е добавена!");
buttonAdd.Enabled = false;
}
else
{
MessageBox.Show("Грешка! Не сте въвели категория.");
this.Close();
}
}
private void buttonNew_Click(object sender, EventArgs e)
{
LibraryEntities1 context = new LibraryEntities1();
var client = (from c in context.Clients
where c.ClientID == clientId
select c).SingleOrDefault();
bool hasBooks = false;
foreach (DataGridViewRow item in dataGridViewLoaned.Rows)
{
if (item.Cells[4].Value != null)
{
int bookID = Convert.ToInt32(item.Cells[4].Value);
DateTime dateL = Convert.ToDateTime(item.Cells[2].Value);
DateTime dateR = Convert.ToDateTime(item.Cells[3].Value);
ClientsBook cBook = new ClientsBook();
cBook.BookID = bookID;
cBook.ClientID = client.ClientID;
cBook.DateLoaned = dateL;
cBook.DateReturned = dateR;
client.ClientsBooks.Add(cBook);
hasBooks = true;
}
}
if (hasBooks)
{
context.SaveChanges();
MessageBox.Show("Книгите са записани - заети!");
}
else MessageBox.Show("Грешка! Няма въведени данни!");
}
private void radioButtonNotReturned_CheckedChanged(object sender, EventArgs e)
{
LibraryEntities1 context = new LibraryEntities1();
var clients =
(from client in context.Clients
join clientbook in context.ClientsBooks on client.ClientID equals clientbook.ClientID
join book in context.Books on clientbook.BookID equals book.BookID
where clientbook.Returned == false
select client).Distinct();
dataGridViewClients.AutoGenerateColumns = false;
dataGridViewClients.DataSource = clients;
}
private void radioButtonReserved_CheckedChanged(object sender, EventArgs e)
{
LibraryEntities1 context = new LibraryEntities1();
var clients =
from clientbook in context.ClientsBooks
join client in context.Clients on clientbook.ClientID equals client.ClientID
where clientbook.Reservation == true
select client;
dataGridViewClients.AutoGenerateColumns = false;
dataGridViewClients.DataSource = clients;
}
private void buttonFind_Click(object sender, EventArgs e)
{
LibraryEntities1 context = new LibraryEntities1();
if (radioButtonID.Checked)
{
if (textBoxFind.Text != "")
{
int find = int.Parse(textBoxFind.Text);
Client cl = context.Clients.FirstOrDefault(
p => p.ClientID == find);
if (cl != null)
{
FormReturn fR = new FormReturn(cl.ClientID);
fR.Show();
this.Close();
}
else MessageBox.Show("Няма читател с този читателски номер!");
}
else MessageBox.Show("Грешка!Няма въведени данни.");
}
else
{
if (textBoxFind.Text == "")
{
MessageBox.Show("Грешка!Няма въведени данни.");
}
else
{
string egn = textBoxFind.Text;
decimal idValue;
int[] digits = null;
bool flag = true;
if (!string.IsNullOrEmpty(egn))
{
if (decimal.TryParse(egn, out idValue))
{
digits = (from d in egn.ToCharArray()
select Convert.ToInt32(d.ToString())).ToArray();
if (digits.Length != 10 || !ValidateEGN(egn, digits))
flag = false;
}
else
flag = false;
}
if (!flag)
{
MessageBox.Show("Грешно ЕГН!!!");
textBoxFind.Clear();
textBoxFind.Focus();
}
else
{
Client cl = context.Clients.FirstOrDefault(
p => p.EGN == egn);
FormReturn fR = new FormReturn(cl.ClientID);
fR.Show();
this.Close();
}
}
}
}
private void buttonRefresh_Click(object sender, EventArgs e)
{
LibraryEntities1 context = new LibraryEntities1();
dataGridViewAuthors.AutoGenerateColumns = false;
dataGridViewAuthors.DataSource = from a in context.Authors
orderby a.LName
select a;
foreach (DataGridViewRow row in dataGridViewAuthors.SelectedRows)
{
row.Selected = false;
}
}
private void tabControl1_Selecting(object sender, TabControlCancelEventArgs e)
{
textBoxLogin.Focus();
LibraryEntities1 context = new LibraryEntities1();
var accaunts = context.Accaunts;
dataGridViewAccaunt.AutoGenerateColumns = false;
dataGridViewAccaunt.DataSource = accaunts;
}
static Accaunt GetAccauntID(LibraryEntities1 context, int accauntID)
{
Accaunt accaunt = context.Accaunts.FirstOrDefault(
p => p.AccauntID == accauntID);
return accaunt;
}
private void buttonSearch_Click(object sender, EventArgs e)
{
LibraryEntities1 context = new LibraryEntities1();
if (textBoxAuthor.Text != "")
{
string lastName = textBoxAuthor.Text;
bool flag = false;
foreach (DataGridViewRow row in dataGridViewAuthors.Rows)
{
row.Selected = false;
if (row.Cells[2].Value != null && row.Cells[2].Value.ToString() == lastName)
{
row.Selected = true;
flag = true;
break;
}
}
if (!flag)
{
MessageBox.Show("Този автор не съществува в базата!");
}
}
else MessageBox.Show("Грешка! Не сте въвели данни за автара!");
}
private void tabPage2_Click(object sender, EventArgs e)
{
LibraryEntities1 context = new LibraryEntities1();
var accaunts = context.Accaunts;
dataGridViewAccaunt.AutoGenerateColumns = false;
dataGridViewAccaunt.DataSource = accaunts;
}
private void FormNewBook_Load(object sender, EventArgs e)
{
LibraryEntities1 context = new LibraryEntities1();
dataGridViewAuthors.AutoGenerateColumns = false;
dataGridViewAuthors.DataSource = from a in context.Authors
orderby a.LName
select a;
foreach (DataGridViewRow row in dataGridViewAuthors.SelectedRows)
{
row.Selected = false;
}
//категории - зареждане на комбото
var categories = context.Categories;
comboBoxCategory.DataSource = categories;
comboBoxCategory.ValueMember = "CategoryID";
comboBoxCategory.DisplayMember = "CategoryName";
//зареждане на комбото с език
var languages = context.Languages;
comboBoxLanguage.DataSource = languages;
comboBoxLanguage.ValueMember = "LanguageID";
comboBoxLanguage.DisplayMember = "LanguageName";
}
static Book GetBookByID(LibraryEntities1 context, int bookID)
{
Book book = context.Books.FirstOrDefault(
p => p.BookID == bookID);
return book;
}
