public static bool Insert(Borrower b)
{
try
{
string conn = ConfigurationManager.ConnectionStrings["LibraryConnectionString"].ConnectionString;
SqlConnection cn = new SqlConnection(conn);
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;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["borrowerNumber"] != null && !IsPostBack)
{
tbBorrowerNum.Enabled = false;
string s = (string)Session["borrowerNumber"];
Borrower b = new Borrower();
b = MemberBL.SelectByID(s);
tbBorrowerNum.Text = b.BorrowerNumber.ToString();
tbName.Text = b.Name.ToString();
tbSex.Text = b.Sex.ToString();
tbAddress.Text = b.Address;
tbTelephone.Text = b.Telephone;
tbEmail.Text = b.Email;
}
}
protected void gvBook_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
GridViewRow row = gvMember.SelectedRow;
if (row != null)
{
{
string s = gvMember.Rows[e.RowIndex].Cells[1].Text;
Borrower b = new Borrower();
b.BorrowerNumber = int.Parse(s);
MemberBL.Delete(b);
FillMember();
}
}
else
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "wtf", "alert('Please select a member!');", true);
}
}
public static bool Delete(Borrower b)
{
try
{
string conn = ConfigurationManager.ConnectionStrings["LibraryConnectionString"].ConnectionString;
SqlConnection cn = new SqlConnection(conn);
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;
}
}
protected void btSave_Click(object sender, EventArgs e)
{
lbSex.Visible = false;
if (tbName.Text != "")
{
lbName.Visible = false;
if (tbSex.Text == "F" || tbSex.Text == "M")
{
Borrower b = new Borrower(int.Parse(tbBorrowerNum.Text), tbName.Text, char.Parse(tbSex.Text), tbAddress.Text, tbTelephone.Text, tbEmail.Text);
MemberBL.Insert(b);
Response.Redirect("~/GUI/MemberUI.aspx");
}
else
{
lbSex.Visible = true;
}
}
else
{
lbName.Visible = true;
}
}
public static Borrower SelectByID(string s)
{
try
{
string conn = ConfigurationManager.ConnectionStrings["LibraryConnectionString"].ConnectionString;
string sql = "SELECT * FROM Borrower where borrowerNumber = " + s;
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
DataSet ds = new DataSet();
da.Fill(ds);
Borrower br = new Borrower();
br.BorrowerNumber = int.Parse(ds.Tables[0].Rows[0][0].ToString());
br.Name = ds.Tables[0].Rows[0][1].ToString();
br.Sex = char.Parse(ds.Tables[0].Rows[0][2].ToString());
br.Address = ds.Tables[0].Rows[0][3].ToString();
br.Telephone = ds.Tables[0].Rows[0][4].ToString();
br.Email = ds.Tables[0].Rows[0][5].ToString();
return br;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return new Borrower();
}
}
public static bool Update(Borrower b)
{
try
{
string conn = ConfigurationManager.ConnectionStrings["LibraryConnectionString"].ConnectionString;
SqlConnection cn = new SqlConnection(conn);
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 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);
}