/// <summary>
/// Add data
/// </summary>
/// <param name="maVachSanPham"></param>
/// <returns></returns>
public bool AddData(clsMaVachSanPham maVachSanPham, int idSanPham)
{
DialogResult result = MessageBox.Show("Xác nhận thêm mã " + maVachSanPham.MaVach + " ?", "Xác nhận",
MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.No)
{
return(false);
}
///them hoa don
if (_mdlMaVachSanPham.AddMaVachTheoIdSanPham(maVachSanPham, idSanPham))
{
MessageBox.Show("Thêm thành công", "Thêm mã vạch", MessageBoxButtons.OK, MessageBoxIcon.Information);
//them chi tiet hoa don
_view.UpdateMaVachSanPhamView();
//if (!this.AddCuaHangTheoSanPham())
// MessageBox.Show("Thêm cửa hàng theo sản phẩm thất bại", "Thêm sản phẩm cửa hàng", MessageBoxButtons.OK, MessageBoxIcon.Information);
return(true);
}
else
{
MessageBox.Show("Thêm thất bại", "Thêm mã vạch", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(false);
}
public bool UpdateData(clsMaVachSanPham maVachSanPham)
{
DataTable table = new DataTable();//Create template table to get data from database
_conn.CMD.CommandText = String.Format("update tbMaVachSanPham set MaVach ='{0}' "
+ ",idNhaCungCap = '{1}'"
+ ",VAT = '{2}' "
+ " where id = '{3}'"
, maVachSanPham.MaVach
, maVachSanPham.IdNhaCungCap
, maVachSanPham.VAT
, maVachSanPham.Id
);
return(_conn.ExecuteCMD());
}
public bool AddMaVachTheoIdSanPham(clsMaVachSanPham maVachSanPham, int idSanPham)
{
DataTable tbSanPhamCuaHang = _mdlSanPhamCuaHang.GetThongTinByIdSanPham(idSanPham);
foreach (DataRow row in tbSanPhamCuaHang.Rows)
{
maVachSanPham.IdSanPhamCuaHang = Convert.ToInt32(row["id"].ToString());
if (!AddData(maVachSanPham))
{
MessageBox.Show("Lỗi", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
}
return(true);
}
/// <summary>
/// Update Data
/// </summary>
/// <param name="sanPham"></param>
/// <returns></returns>
public bool UpdateData(clsMaVachSanPham maVachSanPham)
{
if (_mdlMaVachSanPham.UpdateData(maVachSanPham))
{
MessageBox.Show("Sửa thành công", "Sửa mã vạch", MessageBoxButtons.OK, MessageBoxIcon.Information);
//them chi tiet hoa don
_view.UpdateMaVachSanPhamView();
return(true);
}
else
{
MessageBox.Show("Sửa thất bại", "Sửa mã vạch", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(false);
}
public bool AddData(clsMaVachSanPham maVachSanPham)
{
DataTable table = new DataTable();//Create template table to get data from database
_conn.CMD.CommandText = String.Format("insert tbMaVachSanPham (MaVach,idNhaCungCap,SoLuong,SuDung,GiaBan,"
+ "idNhanVien,GiaNhap,GiaBQGQ,VAT,HetBan,KhongTichLuyDiem,GiaSi,idSanPhamCuaHang,NgayTao) "
+ "VALUES ('{0}', '{1}','{2}','{3}','{4}',{5},'{6}','{7}','{8}','{9}','{10}','{11}','{12}', cast('{13}' as datetime))"
, maVachSanPham.MaVach
, maVachSanPham.IdNhaCungCap
, 0
, maVachSanPham.SuDung
, maVachSanPham.GiaBan
, maVachSanPham.IdNhanVien
, maVachSanPham.GiaNhap
, maVachSanPham.GiaBQGQ
, maVachSanPham.VAT
, false
, maVachSanPham.KhongTichLuyDiem
, maVachSanPham.GiaSi
, maVachSanPham.IdSanPhamCuaHang
, maVachSanPham.NgayTao.ToString("yyyy-MM-dd hh:mm:ss.FFF")
);
return(_conn.ExecuteCMD());
}
