private void btnIssuance_Click(object sender, EventArgs e)
{
int libCard, book;
DateTime begin, end;
string status = "Выдано";
begin = dtpB.Value;
end = dtpE.Value;
if (begin > end)
{
MessageBox.Show("Дата выбрана неверно!", "", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
libCard = Convert.ToInt32(cbReader.SelectedValue);
book = Convert.ToInt32(cbBook.SelectedValue);
string qCount = "select Count from booksInfo where id_booksInfo=" + book;
int c = Queries.ExecuteReader(qCount, 0);
if (c > 0)
{
string qIss = "insert into issuanceBooks values (" + libCard + ", " + book + ", '" +
begin + "', '" + end + "', '" + status + "')";
string qInst = "update booksInfo set Count = Count-1 where id_booksInfo=" + book;
Queries.ExecuteNonQuery(qIss);
Queries.ExecuteNonQuery(qInst);
Filler.LoadDgv(dgvIssuance);
MessageBox.Show("Операция произведена успешно", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Книги нет в наличии или она удалена из библиофонда!", "", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
public MainForm()
{
InitializeComponent();
Filler.FillReaders(cbReader);
Filler.FillBooks(cbBook);
Filler.LoadDgv(dgvIssuance);
DataGridViewButtonColumn dgvbc = new DataGridViewButtonColumn();
dgvbc.Name = "dgvbc";
dgvbc.HeaderText = "Изменить";
dgvbc.Text = "Выбрать";
dgvbc.UseColumnTextForButtonValue = true;
dgvbc.DefaultCellStyle.SelectionBackColor = Properties.Settings.Default.ButtonBlue;
dgvbc.DefaultCellStyle.BackColor = Properties.Settings.Default.ButtonGreen;
dgvIssuance.Columns.Add(dgvbc);
}
private void button1_Click(object sender, EventArgs e)
{
Filler.LoadDgv(dgvIssuance);
Filler.FillBooks(cbBook);
Filler.FillReaders(cbReader);
}