//zaki - Insert record and get Scope_Identity()
public object Insert(CustomList <BaseItem> itemList, Util.OperationType operationType)
{
String spName = String.Empty;
switch (operationType)
{
case Util.OperationType.Insert:
spName = itemList.InsertSpName;
break;
case Util.OperationType.Update:
spName = itemList.UpdateSpName;
break;
case Util.OperationType.Delete:
spName = itemList.DeleteSpName;
break;
}
Object[] parameterValues = null;
object retVal = null;
parameterValues = itemList[0].GetParameterValues();
if (parameterValues.IsNotNull())
{
retVal = DataAccessHelper.ExecuteScalar(transaction, spName, parameterValues);
}
return(retVal);
}
public void Update(CustomList <BaseItem> itemList, Util.OperationType operationType)
{
String spName = String.Empty;
switch (operationType)
{
case Util.OperationType.Insert:
spName = itemList.InsertSpName;
break;
case Util.OperationType.Update:
spName = itemList.UpdateSpName;
break;
case Util.OperationType.Delete:
spName = itemList.DeleteSpName;
break;
}
Object[] parameterValues = null;
foreach (BaseItem item in itemList)
{
parameterValues = item.GetParameterValues();
if (parameterValues.IsNotNull())
{
DataAccessHelper.ExecuteNonQueryProcedure(transaction, spName, parameterValues);
}
}
}