public static bool Update(Borrower b) { try { SqlConnection cn=new SqlConnection("Data Source=localhost;Initial Catalog=Library;Integrated Security=True"); SqlCommand cmd = new SqlCommand("Update Borrower set name = @name, " + "sex = @sex, address = @address,telephone = @telephone,email = @email where borrowerNumber = @borrowerNumber", cn); cmd.Parameters.AddWithValue("@borrowerNumber", b.BorrowerNumber); cmd.Parameters.AddWithValue("@name", b.Name); cmd.Parameters.AddWithValue("@sex", b.Sex); cmd.Parameters.AddWithValue("@telephone", b.Telephone); cmd.Parameters.AddWithValue("@email", b.Email); cmd.Parameters.AddWithValue("@address", b.Address); cn.Open(); cmd.ExecuteNonQuery(); cn.Close(); return true; } catch (Exception ex) { MessageBox.Show(ex.Message); return false; } }
public static bool Insert(Borrower b) { try { SqlConnection cn=new SqlConnection("Data Source=localhost;Initial Catalog=Library;Integrated Security=True"); SqlCommand cmd = new SqlCommand("Insert into Borrower(borrowerNumber, name, sex, address,telephone,email) " + "values(@borrowerNumber, @name, @sex, @address,@telephone,@email)", cn); cmd.Parameters.AddWithValue("@borrowerNumber", b.BorrowerNumber); cmd.Parameters.AddWithValue("@name", b.Name); cmd.Parameters.AddWithValue("@sex", b.Sex); cmd.Parameters.AddWithValue("@address", b.Address); cmd.Parameters.AddWithValue("@telephone", b.Telephone); cmd.Parameters.AddWithValue("@email", b.Email); cn.Open(); cmd.ExecuteNonQuery(); cn.Close(); return true; } catch (Exception ex) { MessageBox.Show(ex.Message); return false; } }
public static bool Delete(Borrower b) { try { SqlConnection cn=new SqlConnection("Data Source=localhost;Initial Catalog=Library;Integrated Security=True"); SqlCommand cmd = new SqlCommand("Delete Borrower where borrowerNumber = @borrowerNumber", cn); cmd.Parameters.AddWithValue("@borrowerNumber", b.BorrowerNumber); cn.Open(); cmd.ExecuteNonQuery(); cn.Close(); return true; } catch (Exception ex) { MessageBox.Show(ex.Message); return false; } }
private void button2_Click(object sender, EventArgs e) { if (AddSave == 0) { button2.Text = "Save"; SqlConnection cn=new SqlConnection("Data Source=localhost;Initial Catalog=Library;Integrated Security=True"); SqlDataAdapter da = new SqlDataAdapter("select max(borrowerNumber) from Borrower", cn); DataSet ds = new DataSet(); da.Fill(ds); int member= int.Parse(ds.Tables[0].Rows[0][0].ToString()) + 1; textBox1.Text = member + ""; textBox1.Enabled = false; textBox2.Text = ""; textBox2.Enabled = true; textBox3.Text = ""; textBox3.Enabled = true; textBox4.Text = ""; textBox4.Enabled = true; textBox5.Text = ""; textBox5.Enabled = true; textBox6.Text = ""; textBox6.Enabled = true; button1.Enabled = false; button3.Enabled = false; button4.Enabled = false; AddSave = 1;//Save } else { bool fail = false; int borNum = new int(); try { borNum = int.Parse(textBox1.Text); } catch (Exception) { memberError.SetError(textBox1, "Wrong input"); fail = true; } string name = textBox2.Text; char sex = new char(); try { sex = char.Parse(textBox3.Text); memberError.Clear(); } catch { memberError.SetError(textBox3, "Wrong input !"); fail = true; } string address = textBox4.Text; string telephone = textBox5.Text; string email = textBox6.Text; if (sex != 'M' && sex != 'F') { memberError.SetError(textBox3, "Sex must be M or F"); fail = true; } else { fail = false; memberError.Clear(); } Borrower borrower = new Borrower(borNum,name,sex,address,telephone,email); if (fail == false) { AddSave = 0;//Add button2.Text = "Add"; try { MemberBL.Insert(borrower); } catch (Exception ex) { MessageBox.Show(ex.Message); } InitializeMemberData(); button1.Enabled = true; button3.Enabled = true; button4.Enabled = true; } } }
private void button4_Click(object sender, EventArgs e) { if (!isSelected()) { MessageBox.Show("Please select a member to Delete"); return; } Borrower b = new Borrower(); b.BorrowerNumber = int.Parse(dataGridView1.SelectedRows[0].Cells["borrowerNumber"].Value.ToString()); DialogResult result = MessageBox.Show("Do you really want to delete this member", "Confirm", MessageBoxButtons.YesNo); if (result == DialogResult.Yes) { MemberBL.Delete(b); } else { } InitializeMemberData(); }
private void button3_Click(object sender, EventArgs e) { if (!isSelected()) { MessageBox.Show("Please select a book to edit"); return; } if (EditSave == 0) { button3.Text = "Save"; textBox1.Enabled = false; textBox2.Enabled = true; textBox3.Enabled = true; textBox4.Enabled = true; textBox5.Enabled = true; textBox6.Enabled = true; button2.Enabled = false; button4.Enabled = false; button1.Enabled = false; EditSave = 1;//Save } else { bool fail = false; int borNum = new int(); try { borNum = int.Parse(textBox1.Text); } catch (Exception) { memberError.SetError(textBox1, "Wrong input"); fail = true; } string name = textBox2.Text; char sex = new char(); try { sex = char.Parse(textBox3.Text); memberError.Clear(); } catch { memberError.SetError(textBox3, "Wrong input !"); fail = true; } string address = textBox4.Text; string telephone = textBox5.Text; string email = textBox6.Text; if (sex != 'M' && sex != 'F') { memberError.SetError(textBox3, "Sex must be M or F"); fail = true; } else { fail = false; memberError.Clear(); } Borrower borrower = new Borrower(borNum, name, sex, address, telephone, email); if (fail == false) { button3.Text = "Edit"; try { MemberBL.Update(borrower); } catch (Exception ex) { MessageBox.Show(ex.Message); } button2.Enabled = true; button4.Enabled = true; button1.Enabled = true; InitializeMemberData(); EditSave = 0;//Edit } } }
public static bool Update(Borrower b) { return MemberDA.Update(b); }
public static bool Insert(Borrower b) { return MemberDA.Insert(b); }
public static bool Delete(Borrower b) { return MemberDA.Delete(b); }