private void BtnReturnBook_Click(object sender, EventArgs e)
{
if (comboBox1.Text == "")
{
MessageBox.Show("Please select Status.", "Select Status", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else
{
var result = MessageBox.Show("Confirm Status?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
using (var con = new MySqlConnection(GetConnection()))
{
string command = $"UPDATE `lms.sad`.`tblissue`" +
$" SET " +
$"`Status`='{comboBox1.Text}'" +
$" WHERE `Book_Title`='{BookDataGridView["Book_Title", BookDataGridView.CurrentRow.Index].Value.ToString()}'";
con.Open();
using (var cmd = new MySqlCommand(command, con))
{
cmd.CommandType = CommandType.Text;
var i = cmd.ExecuteNonQuery();
if (i > 0)
{
MessageBox.Show("Successfully Updated! Please refresh Book List to view entry!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
BookDataGridView.Refresh();
}
}
con.Close();
}
}
}
}
private void BookDataGridView_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
BookDataGridView.ClearSelection();
}
private void SearchButton_Click(object sender, EventArgs e)
{
if (BookTextBox.Text.Length == 0 && checkBox1.Checked == false)
{
MessageBox.Show("Please Enter Book Name Or Search By A Certain Store");
}
else if (BookTextBox.Text.Length != 0 && checkBox1.Checked == false)
{
search = 1;
index = 0;
DataTable dt = controllerObj.GetBooksByBName(BookTextBox.Text);
BookDataGridView.DataSource = dt;
BookDataGridView.Refresh();
if (BookDataGridView.Rows.Count > 0)
{
label10.Text = BookDataGridView.Rows[index].Cells[0].Value.ToString();
label11.Text = BookDataGridView.Rows[index].Cells[1].Value.ToString();
label12.Text = BookDataGridView.Rows[index].Cells[3].Value.ToString();
label13.Text = BookDataGridView.Rows[index].Cells[4].Value.ToString();
label14.Text = BookDataGridView.Rows[index].Cells[5].Value.ToString();
label17.Text = BookDataGridView.Rows[index].Cells[2].Value.ToString();
}
else
{
label10.Text = "";
label11.Text = "";
label12.Text = "";
label13.Text = "";
label14.Text = "";
label17.Text = "";
}
}
if (checkBox1.Checked == true)
{
if (BookTextBox.Text.Length == 0)
{
search = 2;
string StoreName = StoreComboBox.Text;
storeselected = StoreName;
DataTable dt = controllerObj.GetBooksByName(StoreName);
BookDataGridView.DataSource = dt;
BookDataGridView.Refresh();
if (BookDataGridView.Rows.Count > 0)
{
index = 0;
label10.Text = BookDataGridView.Rows[index].Cells[0].Value.ToString();
label11.Text = BookDataGridView.Rows[index].Cells[1].Value.ToString();
label12.Text = BookDataGridView.Rows[index].Cells[3].Value.ToString();
label13.Text = BookDataGridView.Rows[index].Cells[4].Value.ToString();
label14.Text = BookDataGridView.Rows[index].Cells[5].Value.ToString();
label17.Text = BookDataGridView.Rows[index].Cells[2].Value.ToString();
}
else
{
label10.Text = "";
label11.Text = "";
label12.Text = "";
label13.Text = "";
label14.Text = "";
label17.Text = "";
}
}
else
{
search = 3;
string StoreName = StoreComboBox.Text;
storeselected = StoreName;
DataTable dt = controllerObj.GetBooksByBNameAndStore(BookTextBox.Text, StoreName);
BookDataGridView.DataSource = dt;
BookDataGridView.Refresh();
index = 0;
if (BookDataGridView.Rows.Count > 0)
{
label10.Text = BookDataGridView.Rows[index].Cells[0].Value.ToString();
label11.Text = BookDataGridView.Rows[index].Cells[1].Value.ToString();
label12.Text = BookDataGridView.Rows[index].Cells[3].Value.ToString();
label13.Text = BookDataGridView.Rows[index].Cells[4].Value.ToString();
label14.Text = BookDataGridView.Rows[index].Cells[5].Value.ToString();
label17.Text = BookDataGridView.Rows[index].Cells[2].Value.ToString();
}
else
{
label10.Text = "";
label11.Text = "";
label12.Text = "";
label13.Text = "";
label14.Text = "";
label17.Text = "";
}
}
}
}
private void AddBookButton_Click(object sender, EventArgs e)
{
if (BookDataGridView.Rows.Count > 0)
{
int CID = controllerObj.GetCUID(Cuser);
string storename = BookDataGridView.Rows[index].Cells[5].Value.ToString();
string ItemName = BookDataGridView.Rows[index].Cells[0].Value.ToString();
string priceDollar = BookDataGridView.Rows[index].Cells[3].Value.ToString();
string PricePoints = BookDataGridView.Rows[index].Cells[4].Value.ToString();
int result = controllerObj.AddBookToSC(CID, CID, ItemName, storename, Int32.Parse(priceDollar), Int32.Parse(PricePoints));
if (result == 1)
{
controllerObj.DecBQuantity(ItemName, storename);
MessageBox.Show("Item Added To Shopping Cart");
if (search == 1)
{
index = 0;
DataTable dt = controllerObj.GetBooksByBName(BookTextBox.Text);
BookDataGridView.DataSource = dt;
BookDataGridView.Refresh();
if (BookDataGridView.Rows.Count > 0)
{
label10.Text = BookDataGridView.Rows[index].Cells[0].Value.ToString();
label11.Text = BookDataGridView.Rows[index].Cells[1].Value.ToString();
label12.Text = BookDataGridView.Rows[index].Cells[3].Value.ToString();
label13.Text = BookDataGridView.Rows[index].Cells[4].Value.ToString();
label14.Text = BookDataGridView.Rows[index].Cells[5].Value.ToString();
label17.Text = BookDataGridView.Rows[index].Cells[2].Value.ToString();
}
else
{
label10.Text = "";
label11.Text = "";
label12.Text = "";
label13.Text = "";
label14.Text = "";
label17.Text = "";
}
}
if (search == 2)
{
string StoreName = StoreComboBox.Text;
storeselected = StoreName;
DataTable dt = controllerObj.GetBooksByName(StoreName);
BookDataGridView.DataSource = dt;
BookDataGridView.Refresh();
if (BookDataGridView.Rows.Count > 0)
{
index = 0;
label10.Text = BookDataGridView.Rows[index].Cells[0].Value.ToString();
label11.Text = BookDataGridView.Rows[index].Cells[1].Value.ToString();
label12.Text = BookDataGridView.Rows[index].Cells[3].Value.ToString();
label13.Text = BookDataGridView.Rows[index].Cells[4].Value.ToString();
label14.Text = BookDataGridView.Rows[index].Cells[5].Value.ToString();
label17.Text = BookDataGridView.Rows[index].Cells[2].Value.ToString();
}
else
{
label10.Text = "";
label11.Text = "";
label12.Text = "";
label13.Text = "";
label14.Text = "";
label17.Text = "";
}
}
if (search == 3)
{
string StoreName = StoreComboBox.Text;
storeselected = StoreName;
DataTable dt = controllerObj.GetBooksByBNameAndStore(BookTextBox.Text, StoreName);
BookDataGridView.DataSource = dt;
BookDataGridView.Refresh();
index = 0;
if (BookDataGridView.Rows.Count > 0)
{
label10.Text = BookDataGridView.Rows[index].Cells[0].Value.ToString();
label11.Text = BookDataGridView.Rows[index].Cells[1].Value.ToString();
label12.Text = BookDataGridView.Rows[index].Cells[3].Value.ToString();
label13.Text = BookDataGridView.Rows[index].Cells[4].Value.ToString();
label14.Text = BookDataGridView.Rows[index].Cells[5].Value.ToString();
label17.Text = BookDataGridView.Rows[index].Cells[2].Value.ToString();
}
else
{
label10.Text = "";
label11.Text = "";
label12.Text = "";
label13.Text = "";
label14.Text = "";
label17.Text = "";
}
}
}
}
}