/// <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()); }