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;
}
}
