public List<Book> GetAllBooks()
{
BookGateway bGateway1 = new BookGateway();
//List<Book> books = bGateway1.GetALLBooks();
return null;
}
private void saveToolStripMenuItem_Click(object sender, EventArgs e)
{
try
{
BookGateway gateway=new BookGateway();
List<Book> books = new List<Book>();
int count = dataGridView1.RowCount;
for (int i = 0; i < count; i++)
{
DataGridViewRow row = this.dataGridView1.Rows[i];
string s1 = row.Cells["S#No"].Value.ToString();
string name = row.Cells["Name"].Value.ToString();
string writer = row.Cells["Writer"].Value.ToString();
string edition = row.Cells["Edition"].Value.ToString();
string type = row.Cells["Type"].Value.ToString();
string print = row.Cells["Book_Print"].Value.ToString();
int quantity = Convert.ToInt16(row.Cells["Quantiy"].Value);
double bookUnitPrice = Convert.ToDouble(row.Cells["B_Unit_Price"].Value);
//double totalPrice = Convert.ToDouble(row.Cells["Total_Price"].Value);
string date = row.Cells["Purchase_Date"].Value.ToString();
Book aBook=new Book();
aBook.SerialNo = s1;
aBook.BookName = name;
aBook.AuthorName = writer;
aBook.Edition = edition;
aBook.TypeOfBook = type;
aBook.BookPrint = print;
aBook.Quantity = quantity;
aBook.UnitPrice = bookUnitPrice;
aBook.PurchasesDate = date;
gateway.SaveBook(aBook);
//books.Add(aBook);
}
}
catch (Exception exception)
{
MessageBox.Show("Saved");
}
}
private void editToolStripMenuItem_Click(object sender, EventArgs e)
{
int index = listView1.SelectedIndices[0];
ListViewItem item = listView1.Items[index];
Book aBook = (Book)item.Tag;
BookGateway gateway = new BookGateway();
string i = gateway.DeleteInfo(aBook);
MessageBox.Show(i);
}
