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);
}
