public static bool Insert(Copy c) { try { SqlConnection cn = new SqlConnection("Data Source=localhost;Initial Catalog=Library;Integrated Security=True"); SqlCommand cmd = new SqlCommand("Insert into Copy(copyNumber, bookNumber, sequenceNumber, type, price) " + "values(@copyNumber, @bookNumber, @sequenceNumber, @type, @price)", cn); cmd.Parameters.AddWithValue("@copyNumber", c.CopyNumber); cmd.Parameters.AddWithValue("@bookNumber", c.BookNumber); cmd.Parameters.AddWithValue("@sequenceNumber", c.SequenceNumber); cmd.Parameters.AddWithValue("@type", c.Type); cmd.Parameters.AddWithValue("@price", c.Price); cn.Open(); cmd.ExecuteNonQuery(); cn.Close(); return true; } catch (Exception ex) { MessageBox.Show(ex.Message); return false; } }
public static bool Delete(Copy c) { try { SqlConnection cn = new SqlConnection("Data Source=localhost;Initial Catalog=Library;Integrated Security=True"); SqlCommand cmd = new SqlCommand("Delete Copy where copyNumber = @copyNumber", cn); cmd.Parameters.AddWithValue("@copyNumber", c.CopyNumber); cn.Open(); cmd.ExecuteNonQuery(); cn.Close(); return true; } catch (Exception ex) { MessageBox.Show(ex.Message); return false; } }
public static bool Update(Copy c) { return CopyDA.Update(c); }
public static bool Update(Copy c) { try { SqlConnection cn = new SqlConnection("Data Source=localhost;Initial Catalog=Library;Integrated Security=True"); SqlCommand cmd = new SqlCommand("Update Copy set sequenceNumber = @sequenceNumber, " + "type = @type,bookNumber = @bookNumber,price = @price where copyNumber = @copyNumber", cn); cmd.Parameters.AddWithValue("@copyNumber", c.CopyNumber); cmd.Parameters.AddWithValue("@type", c.Type); cmd.Parameters.AddWithValue("@price", c.Price); cmd.Parameters.AddWithValue("@sequenceNumber", c.SequenceNumber); cmd.Parameters.AddWithValue("@bookNumber", c.BookNumber); cn.Open(); cmd.ExecuteNonQuery(); cn.Close(); return true; } catch (Exception ex) { MessageBox.Show(ex.Message); return false; } }
public static bool Insert(Copy c) { return CopyDA.Insert(c); }
public static bool Delete(Copy c) { return CopyDA.Delete(c); }
private void button6_Click(object sender, EventArgs e) { if (!Grid2isSelected()) { MessageBox.Show("Please select a copy to delete"); return; } Copy c = new Copy(); c.CopyNumber = int.Parse(dataGridView2.SelectedRows[0].Cells["copyNumber"].Value.ToString()); DialogResult result = MessageBox.Show("Do you really want to delete this copy", "Confirm", MessageBoxButtons.YesNo); if (result == DialogResult.Yes) { CopyBL.Delete(c); } else { } String cmd = "Select * from Copy where bookNumber = " + txtBookNumber.Text; loadSpecifiCopy(cmd); }
private void button5_Click(object sender, EventArgs e) { if (!Grid2isSelected()) { MessageBox.Show("Please select a copy to edit"); return; } if (EditSaveCopy == 0) { button5.Text = "Save"; button2.Enabled = false; button6.Enabled = false; txtPrice.Enabled = true; txtType.Enabled = true; EditSaveCopy = 1;//Save } else { bool fail = false; int BookNum = int.Parse(txtCopyBookNumber.Text); int CopyNum = int.Parse(txtCopyNumber.Text); int sequence = int.Parse(txtSequenceNumber.Text); char type = new char(); try { type = char.Parse(txtType.Text); errorBook.Clear(); } catch (Exception) { fail = true; errorBook.SetError(txtType, "Must be A or B or R"); } if (type != 'A' && type != 'B' && type != 'R') { errorBook.SetError(txtType, "Must be A or B or R"); fail = true; } else { errorBook.Clear(); fail = false; } double price = 0; try { price = double.Parse(txtPrice.Text); } catch (Exception) { errorBook.SetError(txtPrice, "Price must be a digit"); fail = true; } Copy copy = new Copy(BookNum, CopyNum, sequence, type, price); if (fail == false) { try { CopyBL.Update(copy); } catch (Exception ex) { MessageBox.Show(ex.Message); } button2.Enabled = true; button6.Enabled = true; txtPrice.Enabled = false; txtType.Enabled = false; AddSaveCopy = 0;//Add button5.Text = "Edit"; String cmd = "Select * from Copy where bookNumber = " + txtBookNumber.Text; loadSpecifiCopy(cmd); } else { } } }
private void button2_Click(object sender, EventArgs e) { if (!isSelected()) { MessageBox.Show("Please select book to add a copy"); return; } else { if (AddSaveCopy == 0) { button5.Enabled = false; button6.Enabled = false; button2.Text = "Save"; int Num = CopyDA.GetCopyNumberMax() + 1; int Seq; try { Seq = CopyDA.getSequenceMax(txtBookNumber.Text.Trim()) + 1; } catch (Exception) { Seq = 1; } txtCopyNumber.Text = Num + ""; txtCopyBookNumber.Text = txtBookNumber.Text; txtCopyBookNumber.Enabled = false; txtPrice.Enabled = true; txtPrice.Text = ""; txtSequenceNumber.Enabled = false; txtSequenceNumber.Text = Seq + ""; txtPrice.Enabled = true; txtType.Text = ""; txtType.Enabled = true; AddSaveCopy = 1; } else { bool fail = false; int BookNum = int.Parse(txtCopyBookNumber.Text); int CopyNum = int.Parse(txtCopyNumber.Text); int sequence = int.Parse(txtSequenceNumber.Text); char type = new char(); try { type = char.Parse(txtType.Text); errorBook.Clear(); } catch (Exception) { fail = true; errorBook.SetError(txtType, "Must be A or B or R"); } if (type != 'A' && type != 'B' && type != 'R') { errorBook.SetError(txtType, "Must be A or B or R"); fail = true; } else{ errorBook.Clear(); fail = false; } double price = 0; try { price = double.Parse(txtPrice.Text); } catch (Exception) { errorBook.SetError(txtPrice, "Price must be a digit"); fail = true; } Copy copy = new Copy(BookNum, CopyNum, sequence, type, price); if (fail == false) { try { CopyBL.Insert(copy); } catch (Exception ex) { MessageBox.Show(ex.Message); } button5.Enabled = true; button6.Enabled = true; txtPrice.Enabled = false; txtType.Enabled = false; AddSaveCopy = 0;//Add button2.Text = "Add"; String cmd = "Select * from Copy where bookNumber = " + txtBookNumber.Text; loadSpecifiCopy(cmd); } else { } } } }