private void buttonX_Add_Click(object sender, EventArgs e)
{
HienthiCTdathang();
if (c2.sosanhMSP(textBoxX_msp.Text.Trim())) //neu msp da ton tai thuc hien add
{
if (nh != null)
{
SP s = new SP();
s = s.SetSP(textBoxX_msp.Text, int.Parse(textBoxX_soluong.Text));
SP sp = nh.AddSP(s);
DataRow dr = DtableMuahang.NewRow();
dr["msp"] = sp.GetMSP();
dr["tensp"] = sp.GetTensp();
dr["giamua"] = sp.GetGiaMua();
dr["slnhap"] = sp.GetSoluong();
dr["thanhtien"] = sp.GetThanhtien();
DtableMuahang.Rows.Add(dr);
deleteRow(dataGridViewX1, "Column_msp");
}
}
else
{
MessageBox.Show("Hãy thêm Sp mới vào");
frSanpham frsp = new frSanpham();
frsp.Show();
}
}
public Boolean InsertSP(SP s)
{
connect();
if (con.State == ConnectionState.Closed)
{
con.Open();
}
try
{
SqlCommand insert_sp = new SqlCommand("INSERT_SANPHAM", con);
insert_sp.Parameters.Add("@MSP", SqlDbType.Char, 10).Value = s.GetMSP();
insert_sp.Parameters.Add("@ML", SqlDbType.Char, 10).Value = s.GetML();
insert_sp.Parameters.Add("@MNSX", SqlDbType.Char, 10).Value = s.GetMNSX();
insert_sp.Parameters.Add("@TENSP", SqlDbType.VarChar).Value = s.GetTensp();
// insert_sp.Parameters.Add("@HSD", SqlDbType.DateTime).Value = s.GetHSD();
insert_sp.Parameters.Add("@DVT", SqlDbType.Char, 10).Value = s.GetDVT();
insert_sp.Parameters.Add("@GIAMUA", SqlDbType.Money).Value = s.GetGiaMua();
insert_sp.Parameters.Add("@GIABAN", SqlDbType.Money).Value = s.GetGiaban();
insert_sp.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
return(false);
}
finally
{
con.Dispose();
}
}
