public bool CreateIEDetail(IEDetail iedetail)
{
try
{
string cs = CocBook.Properties.Settings.Default.connectionString;
SqlConnection con = new SqlConnection(cs);
//Insert Command
SqlCommand cmd = new SqlCommand("Insert into IEDetail values (@CheckNo,@ISBNBook,@Quantity,@Discount,@Value)", con);
cmd.Parameters.AddWithValue("CheckNo", iedetail.CheckNo);
cmd.Parameters.AddWithValue("ISBNBook", iedetail.ISBNBook);
cmd.Parameters.AddWithValue("Quantity", iedetail.Quantity);
cmd.Parameters.AddWithValue("Discount", iedetail.Discount);
cmd.Parameters.AddWithValue("Value", iedetail.Value);
//
con.Open();
int count = cmd.ExecuteNonQuery();
con.Close();
return (count == 1);
}
catch (Exception)
{
return false;
}
}
public List<IEDetail> GetAllIEDetail()
{
string cs = CocBook.Properties.Settings.Default.connectionString;
SqlConnection con = new SqlConnection(cs);
//SqlConnection con = new SqlConnection(@"Server=(local);Database = CocBook;uid=sa;pwd=123456789");
//
// View all Command
SqlCommand cmd = new SqlCommand("SELECT * from IEDetail", con);
//
con.Open();
SqlDataReader sdr = cmd.ExecuteReader();
List<IEDetail> list = new List<IEDetail>();
while (sdr.Read())
{
IEDetail iedetail = new IEDetail();
iedetail.CheckNo = (int)sdr["CheckNo"];
iedetail.ISBNBook = (string)sdr["ISBNBook"];
iedetail.Quantity = (int)sdr["Quantity"];
iedetail.Discount = (int)sdr["Discount"];
iedetail.Value = (int)sdr["Value"];
list.Add(iedetail);
}
con.Close();
return list;
}
public bool UpdateIEDetail(IEDetail iedetail)
{
try
{
string cs = CocBook.Properties.Settings.Default.connectionString;
SqlConnection con = new SqlConnection(cs);
//
//Update Command
SqlCommand cmd = new SqlCommand("UPDATE IEDetail SET Quantity = @quantity, Discount = @discount, Value = @value WHERE CheckNo = @no AND ISBNBook = @isbn", con);
cmd.Parameters.AddWithValue("quantity", iedetail.Quantity);
cmd.Parameters.AddWithValue("discount", iedetail.Discount);
cmd.Parameters.AddWithValue("value", iedetail.Value);
cmd.Parameters.AddWithValue("no", iedetail.CheckNo);
cmd.Parameters.AddWithValue("isbn", iedetail.ISBNBook);
//
con.Open();
int count = cmd.ExecuteNonQuery(); // Trả về số dòng bị tác động
con.Close();
return (count == 1);
}
catch (Exception)
{
return false;
}
}
public IEDetail GetIEDetailByCheckNoAndISBN(int no, string isbn)
{
string cs = CocBook.Properties.Settings.Default.connectionString;
SqlConnection con = new SqlConnection(cs);
//SqlConnection con = new SqlConnection(@"Server=(local);Database = CocBook;uid=sa;pwd=123456789");
//
SqlCommand cmd = new SqlCommand("SELECT * FROM IEDetail WHERE CheckNo = @no AND ISBNBook = @isbn", con);
cmd.Parameters.AddWithValue("no", no);
cmd.Parameters.AddWithValue("isbn", isbn);
con.Open();
SqlDataReader sdr = cmd.ExecuteReader();
IEDetail iedetail = new IEDetail();
if (sdr.HasRows)
{
sdr.Read();
iedetail.CheckNo = (int)sdr["CheckNo"];
iedetail.ISBNBook = (string)sdr["ISBNBook"];
iedetail.Quantity = (int)sdr["Quantity"];
iedetail.Discount = (int)sdr["Discount"];
iedetail.Value = (int)sdr["Value"];
return iedetail;
}
con.Close();
return null;
}