protected void Button1_Click(object sender, EventArgs e)
{
Borrower b = new Borrower();
b.BorrowerNumber = int.Parse(tbBorrowerNum.Text);
b.Name = tbName.Text;
b.Sex = DropDownList1.Text;
b.Address = tbAddress.Text;
b.Telephone = tbTelephone.Text;
b.Email = tbEmail.Text;
if (BorrowerBL.Insert(b))
{
Response.Redirect("Member.aspx");
}
}
public static Boolean Delete(Borrower b)
{
try
{
string strConn = ConfigurationManager.ConnectionStrings["LibraryConnectionString2"].ConnectionString;
SqlConnection conn = new SqlConnection(strConn);
SqlCommand cmd = new SqlCommand("delete Borrower where borrowerNumber=@borrowerNumber", conn);
cmd.Parameters.Add(new SqlParameter("@borrowerNumber", b.BorrowerNumber));
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
return true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return false;
}
}
public static Borrower gerBorrower(int borrowerNumber)
{
try
{
string strConn = ConfigurationManager.ConnectionStrings["LibraryConnectionString2"].ConnectionString;
SqlConnection cn = new SqlConnection(strConn);
SqlCommand cmd = new SqlCommand("select * from Borrower where borrowerNumber = @borrowerNumber", cn);
cmd.Parameters.AddWithValue("@borrowerNumber", borrowerNumber);
cn.Open();
SqlDataReader rd = cmd.ExecuteReader();
if (rd.Read())
{
Borrower b = new Borrower(int.Parse(rd["borrowerNumber"].ToString()), rd["name"].ToString(), rd["sex"].ToString(), rd["address"].ToString(), rd["telephone"].ToString(), rd["email"].ToString());
return b;
}
else return null;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return null;
}
}
public static bool Insert(Borrower b)
{
return BorrowerDA.Insert(b);
}
public static bool Delete(Borrower b)
{
return BorrowerDA.Delete(b);
}
public static bool Update(Borrower b)
{
return BorrowerDA.Update(b);
}
public static bool Update(Borrower b)
{
try
{
string strConn = ConfigurationManager.ConnectionStrings["LibraryConnectionString2"].ConnectionString;
SqlConnection conn = new SqlConnection(strConn);
SqlCommand cmd = new SqlCommand("Update Borrower set name = @name ,"
+ "sex = @sex ,address = @address, telephone = @telephone, email = @email where borrowerNumber = @borrowerNumber", conn);
cmd.Parameters.Add(new SqlParameter("@BorrowerNumber", b.BorrowerNumber));
cmd.Parameters.Add(new SqlParameter("@name", b.Name));
cmd.Parameters.Add(new SqlParameter("@sex", b.Sex));
cmd.Parameters.Add(new SqlParameter("@Address", b.Address));
cmd.Parameters.Add(new SqlParameter("@Telephone", b.Telephone));
cmd.Parameters.Add(new SqlParameter("@Email", b.Email));
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
return true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return false;
}
}
public static bool Insert(Borrower b)
{
try
{
string strConn = ConfigurationManager.ConnectionStrings["LibraryConnectionString2"].ConnectionString;
SqlConnection conn = new SqlConnection(strConn);
SqlCommand cmd = new SqlCommand("Insert into Borrower(borrowerNumber, name,sex,address, telephone, email) " +
"values(@borrowerNumber, @name, @sex, @address,@telephone,@email)", conn);
cmd.Parameters.Add(new SqlParameter("@BorrowerNumber", b.BorrowerNumber));
cmd.Parameters.Add(new SqlParameter("@name", b.Name));
cmd.Parameters.Add(new SqlParameter("@sex", b.Sex));
cmd.Parameters.Add(new SqlParameter("@Address", b.Address));
cmd.Parameters.Add(new SqlParameter("@Telephone", b.Telephone));
cmd.Parameters.Add(new SqlParameter("@Email", b.Email));
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
return true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return false;
}
}