public void HuyNl()
{
HuyNguyenLieuDTO huynl = new HuyNguyenLieuDTO();
huynl.TenDn = TenDn ?? "admin";
bool t = huynl_bus.HuyNl_Insert(huynl);
for (int i = 0; i < datanguyenlieuhuy.Rows.Count - 1; i++)
{
CtHuyNguyenLieuDTO cthuynl = new CtHuyNguyenLieuDTO();
cthuynl.MaNl = datanguyenlieuhuy.Rows[i].Cells[0].Value.ToString();
cthuynl.DVt = datanguyenlieuhuy.Rows[i].Cells[1].Value.ToString();
cthuynl.SoLuong = datanguyenlieuhuy.Rows[i].Cells[2].Value.ToString();
cthuynl.HSd = datanguyenlieuhuy.Rows[i].Cells[3].Value.ToString();
cthuynl.LyDoHuy = datanguyenlieuhuy.Rows[i].Cells[4].Value.ToString();
cthuynl_bus.CtHuyNl_Insert(cthuynl);
}
CtHuyNl_DeleteNl();
HoaDonHuy hdh = new HoaDonHuy(TenDn);
HoaDonHuyy hdhy = new HoaDonHuyy();
hdh.crvhoadonhuy.ReportSource = hdhy;
this.Hide();
hdh.ShowDialog();
}
public bool CtHuyNl_Insert(CtHuyNguyenLieuDTO cthuynl)
{
//try
{
openConnect();
SqlCommand cmd = new SqlCommand("CTHUYNL_INSERT", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@TENNGUYENLIEU", cthuynl.MaNl));
cmd.Parameters.Add(new SqlParameter("@SOLUONG", Convert.ToDouble(cthuynl.SoLuong)));
/////////////////////////////////
DateTime hsd = DateTime.ParseExact(cthuynl.HSd, "dd/MM/yyyy", CultureInfo.InvariantCulture);
/////////////////////////////////
cmd.Parameters.Add(new SqlParameter("@HANSUDUNG", Convert.ToDateTime(hsd)));
cmd.Parameters.Add(new SqlParameter("@DVT", cthuynl.DVt));
cmd.Parameters.Add(new SqlParameter("@LYDOHUY", cthuynl.LyDoHuy));
cmd.ExecuteNonQuery();
closeConnect();
return(true);
}
//catch
{
return(false);
}
}
public bool CtHuyNl_Insert(CtHuyNguyenLieuDTO cthuynl)
{
return(cthuynl_dal.CtHuyNl_Insert(cthuynl));
}
