static void ProcessReadingForAsset(string assetNumber)
{
bool
pIsDisregardHoursValidation = true,
pIsOverwriteOldReading = true,
pCheckIdentical = true,
pIsUpdateComponents = false;
DateTime pCompletedDateTime = DateTime.Now;
int pFrequencyTypeID = DataToken.FrequencyTypes.Where(y => y.FrequencyTypeName == "Hours").FirstOrDefault().FrequencyTypeID,
pAssetID = GetAssetWithAssetNumber(assetNumber).AssetID,
pCreatedContactID = 1,
pLanguageNameID = 1,
pNewReading = 5;
var request = DataToken.CreateQuery <ODataFunctionImportQueryableData>("ProcessReading")
.AddQueryOption(nameof(pFrequencyTypeID), pFrequencyTypeID)
.AddQueryOption(nameof(pNewReading), $"'{pNewReading}'")
.AddQueryOption(nameof(pCompletedDateTime), $"'{pCompletedDateTime.ToString("yyyy-MM-dd hh:mm:ss")}'")
.AddQueryOption(nameof(pAssetID), pAssetID)
.AddQueryOption(nameof(pIsUpdateComponents), $"'{pIsUpdateComponents}'")
.AddQueryOption(nameof(pCreatedContactID), pCreatedContactID)
.AddQueryOption(nameof(pIsDisregardHoursValidation), $"'{pIsDisregardHoursValidation}'")
.AddQueryOption(nameof(pIsOverwriteOldReading), $"'{pIsOverwriteOldReading}'")
.AddQueryOption(nameof(pCheckIdentical), $"'{pCheckIdentical}'")
.AddQueryOption(nameof(pLanguageNameID), pLanguageNameID);
ODataFunctionImportQueryableData result = request.Execute().FirstOrDefault();
Debug.WriteLine(result.FieldValue);
}
static void CloseWorkOrderWithWorkOrderNumber(int workOrderNumberToClose)
{
WorkOrder workOrderToClose = GetWorkOrderWithWorkOrderNumber(workOrderNumberToClose);
ODataFunctionImportQueryableData result = DataToken.CreateQuery <ODataFunctionImportQueryableData>("CloseWorkOrdersToHistory")
.AddQueryOption("pWorkOrderIDs", $"'({workOrderToClose.WorkOrderID})'")
.AddQueryOption("pCompleteRequests", "'False'").Execute().FirstOrDefault();
Debug.WriteLine(result.FieldValue);
}
static void CreateRequestWithDescription(string requestDescription)
{
// these are the only valid approval statuses
const string
pendingApproval = "Pending Approval",
approved = "Approved",
declined = "Declined";
// call GetRequestNumber to retrieve a valid unused request number
ODataFunctionImportQueryableData requestNumber = DataToken.CreateQuery <ODataFunctionImportQueryableData>("GetRequestNumber").Execute().FirstOrDefault();
Request newRequest = Request.CreateRequest(
0, // request ID
int.Parse(requestNumber.FieldValue), // request number
false, // is cancelled
false, // is completed
0, // estimated cost
1, // created by
DateTime.Now, // created date
1, // modified by
DateTime.Now, // modified date
false // is accepted by requester
);
newRequest.RequestedByContactID = 1;
newRequest.RequestDescription = requestDescription;
// AddToRequests so when SaveChanges is called it gets persisted
DataToken.AddToRequests(newRequest);
DataToken.SaveChanges();
// Requests need a RecordApproval database entry to be valid
RecordApproval newRequestRecordApproval = RecordApproval.CreateRecordApproval(
0, // record approval ID
nameof(Request), // entity Name
newRequest.RequestID, // request ID
pendingApproval, // approval status
1, // approved by
DateTime.Now, // approved date time
1, // created by
DateTime.Now, // created date
1, // modified by
DateTime.Now // modified date
);
DataToken.AddToRecordApprovals(newRequestRecordApproval);
DataToken.SaveChanges();
}
