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 { }
}
}
}
