private void cart_Paint(object sender, PaintEventArgs e)
{
businesslayer bl = new businesslayer();
MySqlDataReader dr = bl.Select("all", "cart", "", "");
DataTable table = new DataTable();
if (dr != null)
{
table.Load(dr);
if (table != null)
{
CartTable.DataSource = table;
}
}
double Price = 0;
foreach (DataGridViewRow row in CartTable.Rows)
{
if (!row.IsNewRow)
{
Price += Convert.ToDouble(row.Cells["ModSellPrice"].Value);
}
}
TotalPrice.Text = Price.ToString() + " L.E.";
foreach (DataGridViewRow row in CartTable.SelectedRows)
{
if (!row.IsNewRow)
{
bl.DeleteRow("cart", "MobileSerial", row.Cells["MobileSerial"].Value + "");
CartTable.Rows.Remove(row);
MessageBox.Show("Delete Operation is Completed");
}
}
}
private void button1_Click(object sender, EventArgs e)
{
businesslayer bl = new businesslayer();
foreach (DataGridViewRow row in CartTable.SelectedRows)
{
if (!row.IsNewRow)
{
bl.DeleteRow("cart", "MobileSerial", row.Cells["MobileSerial"].Value + "");
CartTable.Rows.Remove(row);
MessageBox.Show("Delete Operation is Completed");
}
}
double Price = 0;
foreach (DataGridViewRow row in CartTable.Rows)
{
if (!row.IsNewRow)
{
Price += Convert.ToDouble(row.Cells["ModSellPrice"].Value);
}
}
TotalPrice.Text = Price.ToString() + " L.E.";
}
