public bool InsertTraHang(DonTraHang DTH)
{
try
{
SqlConnection conn = DBUtils.GetDBConnection();
SqlCommand com = new SqlCommand("insert into LICHSU_TRA_NHACUNGCAP (MASP, NGAYTRA, SOLUONG, NVPHUTRACH, XACNHAN, NCC,LYDOTRA,QUANLY) values (@MASP,@NGAYTRA,@SOLUONG,@NVPHUTRACH,@XACNHAN,@NCC,@LYDOTRA,NULL)", conn);
conn.Open();
com.Parameters.AddWithValue("@MaSP", DTH.MaSp);
com.Parameters.AddWithValue("@NGAYTRA", DTH.NgayTra);
com.Parameters.AddWithValue("@SOLUONG", DTH.SoLuong);
com.Parameters.AddWithValue("@NVPHUTRACH", DTH.NVPHUTRACH);
com.Parameters.AddWithValue("@XACNHAN", DTH.XACNHAN);
com.Parameters.AddWithValue("@NCC", DTH.NCC);
com.Parameters.AddWithValue("@LYDOTRA", DTH.LydoTra);
com.ExecuteNonQuery();
conn.Close();
return(true);
}
catch
{
return(false);
}
}
public bool CapNhatTinQuangCao(TinQC pTinQC)
{
string query = "UPDATE dbo.TINDANG_QUANGCAO SET NOIDUNG = @noidung, NGAYSUA=@ngaysua WHERE ID=@id";
SqlConnection conn = DBUtils.GetDBConnection();
try
{
conn.Open();
DateTime dtDate = DateTime.Today;
SqlCommand cmd = new SqlCommand(query, conn);
cmd.Parameters.Add("@id", SqlDbType.Int).Value = pTinQC.ID;
cmd.Parameters.Add("@noidung", SqlDbType.Text).Value = pTinQC.NoiDung;
cmd.Parameters.Add("@ngaysua", SqlDbType.Date).Value = dtDate.Date;
cmd.ExecuteNonQuery();
conn.Close();
return(true);
}
catch
{
return(false);
}
}
public bool InsertNhapHang(DonNhapHang DNH)
{
try
{
SqlConnection conn = DBUtils.GetDBConnection();
SqlCommand com = new SqlCommand("insert into LICHSU_NHAP_NHACUNGCAP (MASP, NGAYNHAP, SOLUONG, NVPHUTRACH, XACNHAN, NCC,LYDONHAPHANG,QUANLY) values (@MASP,@NGAYNHAP,@SOLUONG,@NVPHUTRACH,@XACNHAN,@NCC,@LYDO,NULL)", conn);
conn.Open();
com.Parameters.AddWithValue("@MASP", DNH.Masp);
com.Parameters.AddWithValue("@NGAYNHAP", DNH.NgayNhap);
com.Parameters.AddWithValue("@SOLUONG", DNH.Soluong);
com.Parameters.AddWithValue("@NVPHUTRACH", DNH.NVPhuTrach);
com.Parameters.AddWithValue("@XACNHAN", DNH.XacNhan);
com.Parameters.AddWithValue("@NCC", DNH.NCC);
com.Parameters.AddWithValue("@LYDO", DNH.Lydo);
com.ExecuteNonQuery();
conn.Close();
return(true);
}
catch
{
return(false);
}
}