} //----------------------
#endregion
#region Programmer-Defined Function Procedures
//this function determines if the procedure name already exists
public Boolean IsExistsNameProcedureInformation(CommonExchange.SysAccess userInfo, CommonExchange.Procedure procedureInfo)
{
using (DatabaseLib.DbLibProcedureManager dbLib = new DatabaseLib.DbLibProcedureManager())
{
return(dbLib.IsExistsNameProcedureInformation(userInfo, procedureInfo));
}
} //-----------------------------
} //----------------------------
//this procedure updates a procedure information
public void UpdateProcedureInformation(CommonExchange.SysAccess userInfo, CommonExchange.Procedure procedureInfo)
{
using (DatabaseLib.DbLibProcedureManager dbLib = new DatabaseLib.DbLibProcedureManager())
{
dbLib.UpdateProcedureInformation(userInfo, procedureInfo);
}
Int32 index = 0;
if (_procedureTable != null)
{
foreach (DataRow procRow in _procedureTable.Rows)
{
if (String.Equals(procRow["sysid_procedure"].ToString(), procedureInfo.ProcedureSystemId))
{
DataRow editRow = _procedureTable.Rows[index];
editRow.BeginEdit();
editRow["procedure_name"] = procedureInfo.ProcedureName;
editRow["amount"] = procedureInfo.Amount;
editRow.EndEdit();
}
index++;
}
_procedureTable.AcceptChanges();
}
} //---------------------------
} //---------------------------
//this function returns all the procedures
private void InitializeClass(CommonExchange.SysAccess userInfo)
{
using (DatabaseLib.DbLibProcedureManager dbLib = new DatabaseLib.DbLibProcedureManager())
{
_procedureTable = dbLib.SelectProcedureInformation(userInfo);
}
} //----------------------
//this procedure inserts a new procedure information
public void InsertProcedureInformation(CommonExchange.SysAccess userInfo, CommonExchange.Procedure procedureInfo)
{
using (DatabaseLib.DbLibProcedureManager dbLib = new DatabaseLib.DbLibProcedureManager())
{
dbLib.InsertProcedureInformation(userInfo, ref procedureInfo);
}
if (_procedureTable != null)
{
DataRow newRow = _procedureTable.NewRow();
newRow["sysid_procedure"] = procedureInfo.ProcedureSystemId;
newRow["procedure_name"] = procedureInfo.ProcedureName;
newRow["amount"] = procedureInfo.Amount;
_procedureTable.Rows.Add(newRow);
}
_procedureTable.AcceptChanges();
} //----------------------------
