public int Operation(string _operator, ListLoaiVatTu _operand, ListLoaiVatTu oldstate)
{
int code = 0;
switch (_operator)
{
case "insert":
code = CreateLoaiVatTu(_operand);
break;
case "update":
code = UpdateLoaiVatTu(_operand);
break;
case "delete":
code = RemoveLoaiVatTu(_operand);
break;
case "unupdate":
code = UpdateLoaiVatTu(oldstate);
break;
}
return(code);
}
private int RemoveLoaiVatTu(ListLoaiVatTu lvt)
{
string[] name = { "MALOAI" };
string[] param = { lvt.MALOAI };
return(Access.ExecuteNonQuery("SP_XOA_LOAIVT", name, param, 1));
}
private int UpdateLoaiVatTu(ListLoaiVatTu lvt)
{
string[] name = { "MALOAI", "@TENLOAI" };
string[] param = { lvt.MALOAI, lvt.TENLOAI };
return(Access.ExecuteNonQuery("SP_SUA_LOAIVT", name, param, 2));
}
public LoaiVTCommand(string _operator, ListLoaiVatTu _operand, ListLoaiVatTu oldstate)
{
this._operator = _operator;
this._operand = _operand;
this.oldstate = oldstate;
}
