/// <summary>
/// Gets all records from the table the business object is connected to
/// </summary>
/// <param name="busObject"></param>
/// <param name="session"></param>
/// <returns></returns>
public static List <Dictionary <string, dynamic> > GetAllRecords(IDispatchObject busObject, ISessionService session)
{
string[] columnsObject;
object recordCount;
// get metadata
try
{
var metadata = Metadata.Metadata.GetMetadata(busObject, session);
columnsObject = metadata.columnsObject;
recordCount = metadata.recordCount;
}
catch (Exception e)
{
Logger.Error(e, "Error getting meta data for all records");
Logger.Error(e, e.Message);
Logger.Error(e, session.GetError());
throw;
}
// init output list
var outList = new List <Dictionary <string, dynamic> >();
// get information from tables
try
{
// return empty if no records
if (recordCount.ToString() == "0")
{
return(new List <Dictionary <string, dynamic> >());
}
// go to first record
busObject.InvokeMethod("nMoveFirst");
do
{
// add record
outList.Add(GetRecord(busObject, session, columnsObject));
// move to next record
busObject.InvokeMethod("nMoveNext");
// keep going until no more records
} while (busObject.GetProperty("nEOF").ToString() == "0");
// return all records
return(outList);
}
catch (Exception e)
{
Logger.Error(e, "Error getting all records");
Logger.Error(e, e.Message);
Logger.Error(e, session.GetError());
throw;
}
}
/// <summary>
/// Gets the most recent error created within the session
/// </summary>
/// <returns></returns>
public string GetError()
{
try
{
return((string)_oSS.GetProperty("sLastErrorMsg"));
}
catch (Exception e)
{
Logger.Error(e, e.Message);
throw;
}
}
public static string SalesOrders(IDispatchObject busObject, ISessionService session, Record record)
{
string _command = "";
string _method = "";
string _value = "";
string _variable = "";
void SetLogParams(string method, string command, string variable, string value)
{
_method = method;
_command = command;
_variable = variable;
_value = value;
}
string GetErrorMessage()
{
var sessionError = session.GetError();
return
($"Error: {sessionError}, Method: {_method}, Command: {_command}, Variable: {_variable}, Value: {_value}");
}
Dictionary <string, object> recordObject;
string[] keyColumnsObject = Metadata.Metadata.GetKeys(busObject, session);
// convert record json into object
try
{
recordObject = JsonConvert.DeserializeObject <Dictionary <string, object> >(record.DataJson);
}
catch (Exception e)
{
Logger.Error(e, e.Message);
throw;
}
// set key column value to enable editing of record
try
{
SetLogParams("InsertSingleRecord", "nGetNextSalesOrderNo", "", "");
var data = new object[] { "" };
busObject.InvokeMethodByRef("nGetNextSalesOrderNo", data);
var keyValue = data[0].ToString();
var key = keyColumnsObject[0];
SetLogParams("InsertSingleRecord", "nSetKey", key, keyValue);
busObject.InvokeMethod("nSetKey", keyValue);
// remove key column as it is already set
recordObject.Remove(key);
}
catch (Exception e)
{
var error = GetErrorMessage();
Logger.Error(e, "Error inserting single record");
Logger.Error(e, e.Message);
Logger.Error(e, error);
return(error);
}
// set and validate all required properties
var recordKey = "ARDivisionNo$";
if (recordObject.ContainsKey(recordKey))
{
var recordValue = recordObject[recordKey];
if (recordValue != null)
{
try
{
SetLogParams("InsertSingleRecord", "nSetValue", recordKey, recordValue.ToString());
busObject.InvokeMethod("nSetValue", recordKey, recordValue.ToString());
recordObject.Remove(recordKey);
}
catch (Exception e)
{
var error = GetErrorMessage();
Logger.Error(e, "Error inserting single record");
Logger.Error(e, e.Message);
Logger.Error(e, error);
return(error);
}
}
else
{
return($"{recordKey} was null");
}
}
else
{
return($"{recordKey} must be set");
}
recordKey = "CustomerNo$";
if (recordObject.ContainsKey(recordKey))
{
var recordValue = recordObject[recordKey];
if (recordValue != null)
{
try
{
SetLogParams("InsertSingleRecord", "nSetValue", recordKey, recordValue.ToString());
busObject.InvokeMethod("nSetValue", recordKey, recordValue.ToString());
recordObject.Remove(recordKey);
}
catch (Exception e)
{
var error = GetErrorMessage();
Logger.Error(e, "Error inserting single record");
Logger.Error(e, e.Message);
Logger.Error(e, error);
return(error);
}
}
else
{
return($"{recordKey} was null");
}
}
else
{
return($"{recordKey} must be set");
}
recordKey = "LineItems";
if (recordObject.ContainsKey(recordKey))
{
var recordValue = recordObject[recordKey];
if (recordValue != null)
{
try
{
var linesBusObject = new DispatchObject(busObject.GetProperty("oLines"));
var lineItems = JsonConvert.DeserializeObject <List <LineItem> >(JsonConvert.SerializeObject(recordValue));
foreach (var lineItem in lineItems)
{
SetLogParams("InsertSingleRecord", "nSetValue", recordKey, lineItem.ItemCode);
linesBusObject.InvokeMethod("nAddLine");
linesBusObject.InvokeMethod("nSetValue", "ItemCode$", lineItem.ItemCode);
linesBusObject.InvokeMethod("nSetValue", "QuantityOrdered", lineItem.QuantityOrdered.ToString());
}
recordObject.Remove(recordKey);
}
catch (Exception e)
{
var error = GetErrorMessage();
Logger.Error(e, "Error inserting single record");
Logger.Error(e, e.Message);
Logger.Error(e, error);
return(error);
}
}
else
{
return($"{recordKey} was null");
}
}
else
{
return($"{recordKey} must be set");
}
// write out all other columns
try
{
foreach (var col in recordObject)
{
if (col.Value != null)
{
SetLogParams("InsertSingleRecord", "nSetValue", col.Key, col.Value.ToString());
busObject.InvokeMethod("nSetValue", col.Key, col.Value.ToString());
}
}
SetLogParams("InsertSingleRecord", "nWrite", "", "");
busObject.InvokeMethod("nWrite");
}
catch (Exception e)
{
var error = GetErrorMessage();
Logger.Error(e, "Error inserting single record");
Logger.Error(e, e.Message);
Logger.Error(e, error);
return(error);
}
return("");
}