public bool updateCT_HoaDonDatHang(CT_HoaDonNhapHang _CT_hoaDonNhapHang)
{
try
{
SqlCommand cmd = new SqlCommand("CT_HOADONHAPHANG_Update", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@maHD", SqlDbType.VarChar, 10)).Value = _CT_hoaDonNhapHang.MaHD;
cmd.Parameters.Add(new SqlParameter("@maSP", SqlDbType.Date)).Value = _CT_hoaDonNhapHang.MaSP;
cmd.Parameters.Add(new SqlParameter("@soLuong", SqlDbType.Int)).Value = _CT_hoaDonNhapHang.SoLuong;
cmd.Parameters.Add(new SqlParameter("@thanhTien", SqlDbType.Int)).Value = _CT_hoaDonNhapHang.ThanhTien;
cmd.Parameters.Add(new SqlParameter("@ghiChu", SqlDbType.VarChar, 100)).Value = _CT_hoaDonNhapHang.GhiChu;
cmd.Parameters.Add(new SqlParameter("@isActive", SqlDbType.Bit)).Value = _CT_hoaDonNhapHang.IsActive;
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
cmd.ExecuteNonQuery();
conn.Close();
return(true);
}
catch (Exception e)
{
conn.Close();
Console.WriteLine("Lỗi: " + e.Message);
return(false);
}
}
public CT_HoaDonNhapHang getCT_HoaDonNhapHang(string _maHD)
{
try
{
SqlCommand cmd = new SqlCommand("CT_HOADONNHAPHANG_getHoaDonNhapHang", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@maHD", SqlDbType.VarChar, 10)).Value = _maHD;
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
SqlDataReader dr = cmd.ExecuteReader();
CT_HoaDonNhapHang CT_hoadonnhaphang = null;
if (dr.Read())
{
CT_hoadonnhaphang = new CT_HoaDonNhapHang();
CT_hoadonnhaphang.MaHD = dr["MaHD"].ToString();
CT_hoadonnhaphang.MaSP = dr["MaSP"].ToString();
CT_hoadonnhaphang.SoLuong = (int)dr["SoLuong"];
CT_hoadonnhaphang.ThanhTien = (int)dr["ThanhTien"];
CT_hoadonnhaphang.GhiChu = dr["GhiChu"].ToString();
CT_hoadonnhaphang.IsActive = (Convert.ToInt32(dr["IsActive"]) == 1) ? true : false;
}
conn.Close();
return(CT_hoadonnhaphang);
}
catch (Exception e)
{
conn.Close();
Console.WriteLine("Lỗi: " + e.Message);
return(null);
}
}
public bool addCT_HoaDonNhapHang(CT_HoaDonNhapHang _CT_hoaDonNhapHang)
{
try
{
SqlCommand cmd = new SqlCommand("CT_HOADONHAPHANG_Insert", conn);
cmd.CommandType = CommandType.StoredProcedure;
_maHD = cmd.Parameters.Add(new SqlParameter("@maHD", SqlDbType.VarChar, 10));
_maSP = cmd.Parameters.Add(new SqlParameter("@maSP", SqlDbType.VarChar, 10));
_soLuong = cmd.Parameters.Add(new SqlParameter("@maNV", SqlDbType.Int));
_thanhTien = cmd.Parameters.Add(new SqlParameter("@thanhTien", SqlDbType.Int));
_ghiChu = cmd.Parameters.Add(new SqlParameter("@ghiChu", SqlDbType.NVarChar, 100));
_isActive = cmd.Parameters.Add(new SqlParameter("@isActive", SqlDbType.Bit));
//Get value to parameters:
_maHD.Value = _CT_hoaDonNhapHang.MaHD;
_maSP.Value = _CT_hoaDonNhapHang.MaSP;
_soLuong.Value = _CT_hoaDonNhapHang.SoLuong;
_thanhTien.Value = _CT_hoaDonNhapHang.ThanhTien;
_ghiChu.Value = _CT_hoaDonNhapHang.GhiChu;
_isActive.Value = _CT_hoaDonNhapHang.IsActive;
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
cmd.ExecuteNonQuery();
conn.Close();
return(true);
}
catch (Exception e)
{
conn.Close();
Console.WriteLine("Lỗi: " + e.Message);
return(false);
}
}
public void UpdateCTHDN(CT_HoaDonNhapHang ex)
{
bus.UpdateCTHDN(ex);
}
public void XoaCTHoaDonNhap(CT_HoaDonNhapHang ex)
{
bus.XoaCTHoaDonNhap(ex);
}
public void DeleteCT_HoaDonNhap(CT_HoaDonNhapHang ex)
{
bus.DeleteCT_HoaDonNhap(ex);
}
public void AddCTHD(CT_HoaDonNhapHang exx)
{
bus.AddCTHD(exx);
}
public bool updateCT_HoaDonDatHang(CT_HoaDonNhapHang _CT_hoadonnhaphang)
{
return(objCT_HDNH.updateCT_HoaDonDatHang(_CT_hoadonnhaphang));
}
public bool addCT_HoaDonNhapHang(CT_HoaDonNhapHang _CT_hoadonnhaphang)
{
return(objCT_HDNH.addCT_HoaDonNhapHang(_CT_hoadonnhaphang));
}
public void UpdateCTHDN(CT_HoaDonNhapHang ex)
{
KetNoi.ExecuteReader(@"update CT_HoaDonNhapHang Set SoLuong=" + ex.SoLuong + ",DonGia=" + ex.DonGia + ",KhuyenMai=" + ex.KhuyenMai + ",ThanhTien=" + ex.ThanhTien + ",TrangThai=N'" + ex.TrangThai + "' Where MaHDNH=N'" + ex.MaHDNH + "' and MaLK=N'" + ex.MaLK + "' ");
}
public void XoaCTHoaDonNhap(CT_HoaDonNhapHang ex)
{
KetNoi.ExecuteReader(@"Delete From CT_HoaDonNhapHang Where MaHDNH=N'" + ex.MaHDNH + "' and MaLK=N'" + ex.MaLK + "'");
}
public void AddCTHD(CT_HoaDonNhapHang exx)
{
KetNoi.ExecuteReader(@"insert into CT_HoaDonNhapHang(MaHDNH,MaLK,SoLuong,DonGia,KhuyenMai,ThanhTien,TrangThai)
values(N'" + exx.MaHDNH + "',N'" + exx.MaLK + "'," + exx.SoLuong + "," + exx.DonGia + "," + exx.KhuyenMai + "," + exx.ThanhTien + ",N'" + exx.TrangThai + "')");
}
