public int UpdateDepartment(DepartmentDTO departmentDTO) { string sql = string.Format("Update BOPHAN set TenBP = N'{0}', GhiChu = N'{1}', Active = '{2}' where MaBP = '{3}'", departmentDTO.iTenBP, departmentDTO.iGhiChu, departmentDTO.iActive, departmentDTO.iActive); try { ConnectionDB.ExecNonQuery(sql); return(1); } catch { return(0); } }
public int UpdateNhomHang(NhomHang nhomHang) { string sql = string.Format("Update NHOMHANG set TenNhom = N'{0}', GhiChu = N'{1}', Active = '{2}' where MaNhom = '{3}'", nhomHang.tenNhomHang, nhomHang.ghiChu, nhomHang.kichHoat, nhomHang.maNhomHang); try { ConnectionDB.ExecNonQuery(sql); return(1); } catch { return(0); } }
public int deleteUnit(string madvt) { string sql = string.Format(" delete from DONVITINH where MaDVT = N'{0}'", madvt); try { ConnectionDB.ExecNonQuery(sql); return(1); } catch { return(0); } }
public int deleteWarehouse(string makho) { string sql = string.Format(" delete from KHOHANG where MaKho = N'{0}'", makho); try { ConnectionDB.ExecNonQuery(sql); return(1); } catch { return(0); } }
//Đổi mật khẩu mới(update) public int updatePassword(string username, string password) { string sql = string.Format(" update SYS_USER " + " set [Password] = '{0}' " + " where UserName = N'{1}' ", password, username); try { ConnectionDB.ExecNonQuery(sql); return(1); } catch { return(0); } }
public int updateUnit(UnitDTO unit) { string sql = string.Format(" update DONVITINH " + " set Ten = N'{0}', GhiChu = N'{1}', Active = N'{2}' " + " where MaDVT = '{3}' ", unit.iTen, unit.iGhiChu, unit.iActive, unit.iMaDVT); try { ConnectionDB.ExecNonQuery(sql); return(1); } catch { return(0); } }
public int updateWarehouse(WarehouseDTO w) { string sql = string.Format(" update KHOHANG " + " set TenKho = N'{0}', LienHe = N'{1}', DiaChi = N'{2}', DienThoai = N'{3}', KyHieu = N'{4}', GhiChu = N'{5}', MaNV = N'{6}', Active = N'{7}' " + " where MaKho = '{8}' ", w.iTenKho, w.iLienHe, w.iDiaChi, w.iDienThoai, w.iKyHieu, w.iGhiChu, w.iMaNV, w.iActive, w.iMaKho); try { ConnectionDB.ExecNonQuery(sql); return(1); } catch { return(0); } }
public int insertUnit(UnitDTO unit) { string id = IDAuto(); string sql = string.Format(" insert into DONVITINH (MaDVT, Ten, GhiChu, Active) values" + "('{0}', N'{1}', N'{2}', N'{3}')", id, unit.iTen, unit.iGhiChu, unit.iActive); try { ConnectionDB.ExecNonQuery(sql); return(1); } catch { return(0); } }
public int insertWarehouse(WarehouseDTO w) { string id = IDAuto(); string sql = string.Format(" insert into KHOHANG (MaKho, TenKho, LienHe, DiaChi, DienThoai, KyHieu, GhiChu, MaNV, Active) values" + "('{0}', N'{1}', N'{2}', N'{3}', N'{4}', N'{5}', N'{6}', N'{7}' , N'{8}')", w.iMaKho, w.iTenKho, w.iLienHe, w.iDiaChi, w.iDienThoai, w.iKyHieu, w.iGhiChu, w.iMaNV, w.iActive); try { ConnectionDB.ExecNonQuery(sql); return(1); } catch { return(0); } }
public int InsertEmployees(EmployeesDTO employeesDTO) { //string bophan = employeesDTO.iBoPhan != null ? string.Format("'{0}'", employeesDTO.iBoPhan) : "null"; //string nql = employeesDTO.iNguoiQL != null ? string.Format("'{0}'", employeesDTO.iNguoiQL) : "null"; string id = IDAuto(); string sql = string.Format("INSERT INTO _NHANVIEN Values(N'{0}', N'{1}', N'{2}', N'{3}', N'{4}', N'{5}', N'{6}', N'{7}', '{8}')", id, employeesDTO.iTenNV, employeesDTO.iDiaChi, employeesDTO.iDienThoai, employeesDTO.iDiDong, employeesDTO.iEmail, employeesDTO.iBoPhan, employeesDTO.iNguoiQL, employeesDTO.iActive); try { ConnectionDB.ExecNonQuery(sql); return(1); } catch { return(0); } }
public int UpdateEmployees(EmployeesDTO employeesDTO) { string sql = "update _NHANVIEN set " + string.Format("TenNV = N'{0}', DiaChi = N'{1}', Email = '{2}',", employeesDTO.iTenNV, employeesDTO.iDiaChi, employeesDTO.iEmail) + string.Format("DienThoai = '{0}', DiDong = '{1}', BoPhan = '{2}', NguoiQL = '{3}'", employeesDTO.iDienThoai, employeesDTO.iDiDong, employeesDTO.iBoPhan, employeesDTO.iNguoiQL) + string.Format("ConQuanLy={0} where MaNV='{1}'", employeesDTO.iActive, employeesDTO.iMaNV); try { ConnectionDB.ExecNonQuery(sql); return(1); } catch { return(0); } }