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