protected bool add(DTOBILLNHAP a)
{
string day = a.Ngay.ToString("yyyyMMdd");
string query = string.Format("INSERT dbo.billnhap (manvnhap, manhasx, ngay, tongtiennhap ) VALUES ( '{0}', '{1}','{2}', {3} )", a.Manv, a.Manhasx, day, a.Tongtien);
return(executenonquery(query));
}
private void buttonthanhtoannhap_Click(object sender, EventArgs e)
{
NHASX sx = comboBoxnhasxnhap.SelectedItem as NHASX;
string s = sx.Ma;
string manv = textBoxmanvnhap.Text;
DateTime day = dateTimePickernhap.Value;
int tt = Convert.ToInt32(textBoxtongtiennhap.Text);
DTOBILLNHAP bi = new DTOBILLNHAP(day, tt, manv, s);
if (billnhap.Add(bi))
{
string idbi = billnhap.Getnew().ToString();
foreach (ListViewItem item in listViewnhap.Items)
{
string nhasx = item.SubItems[2].Text;
string xe = item.SubItems[0].Text;
bool soluong = Int32.TryParse(item.SubItems[3].Text, out int sl);
Int32.TryParse(item.SubItems[4].Text, out int tien);
DTOINFORBILLNHAP bif = new DTOINFORBILLNHAP(xe, sl, idbi);
if (infbillnhap.Add(bif, tien))
{
load();
}
else
{
MessageBox.Show("them thong tin bill that bai");
billnhap.Delete(idbi);
load();
}
}
}
else
{
MessageBox.Show("them bill that bai");
}
}
public bool Add(DTOBILLNHAP a)
{
return(add(a));
}
