After doing some research which consisted mainly of searching through
this forum, I noticed a mantra along the lines of manipulate the
dataProvider, not the controls it populates. It makes sense,
especially since without directly manipulating the primary key of the
very first entry in a database , it will read as 1, while the first
index of a dataGrid will read as 0. Right now, I have a mostly
finished AIR form which serves as a way of maintaining a product
table. The dataGrid's provider is an array collection built from the
results of a select statement. To get to the point I'd like some
assistance in streamlining some things to not onlt help this form, but
others in the application which will use the same data access
functionality. For starters, here's how I update data:
Assume that the first primary key in the very first entry of the
database has been edited to read as 0 after it was entered so it syncs
up with the dataGrid.selectedIndex property.
--------------------
//Begins the proceedure to edit a currently existing item when the
edit button is clicked
public function newEdit():void
{
chosenMode = "Edit";
currentState = "Edit Item";
editColumn.visible = false;
deleteColumn.visible = false;
duplicateColumn.visible = false;
this.lblUniqueID.visible = false;
this.rbAll.visible = false;
this.rbBillable.visible = false;
this.rbNonBillable.visible = false;
try
{
var selectedItemIndex:int = adgProducts.selectedIndex;
//Uses another select statement to get the needed information and
passes the results into
//variables which populates the controls instead of an arrayCollection
dataManager.selectProdDataForEdit(selectedItemIndex);
this.lblUniqueID.text = model.editVarOne;
this.txtNewProductID.text = model.editVarTwo;
this.txtNewProductName.text = model.editVarThree;
this.txtNewBarcode.text = model.editVarFour;
this.txtNewUnit.text = model.editVarFive;
this.txtNewQuantity.text = model.editVarSix;
this.txtNewVendor.text = model.editVarSeven;
this.txtNewCost.text = model.editVarEight;
this.txtNewList.text = model.editVarNine;
this.chkNewBillable.selected = model.editVarBool;
this.lblCurrentStatus.text = "Currently " + model.editVarEleven;
}
catch(ex:Error)
{
trace(ex.toString());
trace(ex.getStackTrace());
}
}
private function saveItem(mode:String):void//Differentiates between
whether you want to insert a new item or edit an existing one
{
switch(mode)
{
case "Add_New": insertNew();
break;
case "Edit": editItem();
break;
default: Alert.show("Cannot Determine State","State Unknown")
break;
}
}
//Actually edits an existing item when the save button is clicked
private function editItem():void
{//Takes the information from the controls and sets them equal to
global variables of the same type which
//are then passed into the function which performs the update
model.insertStringOne = this.txtNewProductID.text;
model.insertStringTwo = this.txtNewProductName.text;
model.insertStringThree = this.txtNewBarcode.text;
model.insertStringFour = this.txtNewVendor.text;
model.insertIntOne = parseInt(this.txtNewUnit.text);
model.insertIntTwo = parseInt(this.txtNewQuantity.text);
model.insertNumberOne = Number(this.txtNewCost.text);
model.insertNumberTwo = Number(this.txtNewList.text);
model.insertStringFive = this.cmbNewClass.selectedItem.toString();
model.insertBooleanOne = this.chkNewBillable.selected;
model.insertStringSix = this.cmbStatus.selectedLabel.toString();
model.insertIntThree = parseInt(this.lblUniqueID.text);
dataManager.updateProduct(model.insertStringOne,
model.insertStringTwo, model.insertStringThree, model.insertIntOne,
model.insertIntTwo, model.insertStringFour, model.insertNumberOne,
model.insertNumberTwo, model.insertStringFive,
model.insertBooleanOne, model.insertStringSix, model.insertNewDate,
model.insertIntThree);
cancelOperation();
//Refreshes the datagrid
refreshGrid();
}
--------------------
What I want is to see if there's an easier way to do this via
accessing the ArrayCollection model.prodMaintData to get the values to
edit as opposed to going through another select statement as well as
some other things that might help. I don't totally understand the
functions associated with the ArrayCollection or at least what needs
to be passed into them to get what I need. Thanks in advance.
Brian Ross Edwards
Tech-Connect LLC
