public int UpdateLoaiHangHoa(vo_LoaiHangHoa vo) { try { dao_LoaiHangHoa dao = new dao_LoaiHangHoa(); int id = dao.updateLoaiHangHoa(vo); return(id); } catch (Exception ex) { throw ex; } }
public int AddLoaiHangHoa(vo_LoaiHangHoa vo_loaiHH) { try { dao_LoaiHangHoa dao = new dao_LoaiHangHoa(); int value = dao.insertLoaiHangHoa(vo_loaiHH); return(value); } catch (Exception ex) { throw ex; } }
public pl_windowThemLoaiHangHoa() { try { InitializeComponent(); this.bus_LoaiHH = new bus_LoaiHangHoa(); this.vo_loaiHH = new vo_LoaiHangHoa(); this.DataContext = this.vo_loaiHH; this.vo_loaiHH.Id = this.bus_LoaiHH.GetLastesIDLoaiHH() + 1; } catch (Exception ex) { MessageBox.Show(ex.Message, "Loi!", MessageBoxButton.OK, MessageBoxImage.Information); } }
public ObservableCollection <vo_LoaiHangHoa> getAllLoaiHangHoa() { try { dao_LoaiHangHoa dao = new dao_LoaiHangHoa(); DataTable dt = dao.getAllLoaiHangHoa(); ObservableCollection <vo_LoaiHangHoa> dsLoaiHH = new ObservableCollection <vo_LoaiHangHoa>(); foreach (DataRow row in dt.Rows) { vo_LoaiHangHoa vo = new vo_LoaiHangHoa(int.Parse(row["ID"].ToString()), row["LOAIHANGHOA"].ToString()); dsLoaiHH.Add(vo); } return(dsLoaiHH); } catch (Exception ex) { throw ex; } }
public int updateLoaiHangHoa(params object[] oParams) { try { if (oParams != null) { vo_LoaiHangHoa vo = (vo_LoaiHangHoa)oParams[0]; ConnectionString cnn = new ConnectionString(); string query = "UPDATE LOAIHANGHOA SET NAME=@name output INSERTED.ID WHERE ID=@id"; string[] arrParam = new string[] { "@name", "@id" }; SqlDbType[] arrType = new SqlDbType[] { SqlDbType.NVarChar, SqlDbType.Int }; object[] arrvalues = new object[] { vo.Name, vo.Id }; return(cnn.conn.ExecuteQueryReturnID(query, arrParam, arrvalues, arrType)); } return(0); } catch (Exception ex) { throw ex; } }
public int insertLoaiHangHoa(params object[] oParams) { try { if (oParams != null) { vo_LoaiHangHoa vo_LoaiHH = (vo_LoaiHangHoa)oParams[0]; ConnectionString cnn = new ConnectionString(); string query = "INSERT INTO LOAIHANGHOA(LOAIHANGHOA) output INSERTED.ID VALUES( @name)"; string[] arrParam = new string[] { "@name" }; SqlDbType[] arrType = new SqlDbType[] { SqlDbType.NVarChar }; object[] arrvalues = new object[] { vo_LoaiHH.Name }; return(cnn.conn.ExecuteQueryReturnID(query, arrParam, arrvalues, arrType)); } return(0); } catch (Exception ex) { throw ex; } }