protected virtual void HandleMaterials(MaximoOperationExecutionContext maximoTemplateData, CrudOperationData entity, object wo)
{
var materials = (IEnumerable <CrudOperationData>)entity.GetRelationship("matusetrans");
var newMaterials = materials.Where(r => r.GetAttribute("matusetransid") == null);
var recordKey = entity.Id;
var user = SecurityFacade.CurrentUser();
WsUtil.CloneArray(newMaterials, wo, "MATUSETRANS", delegate(object integrationObject, CrudOperationData crudData) {
var qtyRequested = ReflectionUtil.GetProperty(integrationObject, "QTYREQUESTED");
if (qtyRequested == null)
{
WsUtil.SetValue(integrationObject, "QTYREQUESTED", 0);
}
var realValue = (double)WsUtil.GetRealValue(integrationObject, "QTYREQUESTED");
WsUtil.SetValue(integrationObject, "QUANTITY", -1 * realValue);
WsUtil.SetValue(integrationObject, "MATUSETRANSID", -1);
WsUtil.SetValue(integrationObject, "ENTERBY", user.Login);
WsUtil.SetValue(integrationObject, "ORGID", user.OrgId);
WsUtil.SetValue(integrationObject, "SITEID", user.SiteId);
WsUtil.SetValue(integrationObject, "REFWO", recordKey);
WsUtil.SetValue(integrationObject, "ACTUALDATE", DateTime.Now.FromServerToRightKind(), true);
WsUtil.SetValue(integrationObject, "TRANSDATE", DateTime.Now.FromServerToRightKind(), true);
ReflectionUtil.SetProperty(integrationObject, "action", OperationType.Add.ToString());
});
}
//protected override void HandleMaterials(MaximoOperationExecutionContext maximoTemplateData, CrudOperationData entity, object wo) {
// var materials = (IEnumerable<CrudOperationData>)entity.GetRelationship("matusetrans");
// var newMaterials = materials.Where(r => r.GetAttribute("matusetransid") == null);
// var recordKey = entity.Id;
// var user = SecurityFacade.CurrentUser();
// var crudOperationDatas = newMaterials as CrudOperationData[] ?? newMaterials.ToArray();
// WsUtil.CloneArray(crudOperationDatas, wo, "MATUSETRANS", delegate(object integrationObject, CrudOperationData crudData) {
// var itemsetid = (string)crudOperationDatas[0].GetAttribute("item_.itemsetid");
// var qtyRequested = (double)WsUtil.GetRealValue(integrationObject, "QTYREQUESTED");
// WsUtil.SetValue(integrationObject, "MATUSETRANSID", -1);
// WsUtil.SetValue(integrationObject, "QUANTITY", -1 * qtyRequested);
// WsUtil.SetValue(integrationObject, "CURBAL", 3.00);
// WsUtil.SetValue(integrationObject, "PHYSCNT", 15.00);
// WsUtil.SetValue(integrationObject, "UNITCOST", 17.36);
// WsUtil.SetValue(integrationObject, "ACTUALCOST", 17.36);
// WsUtil.SetValue(integrationObject, "CONVERSION", 1.00);
// WsUtil.SetValue(integrationObject, "ISSUETYPE", "RETURN");
// WsUtil.SetValue(integrationObject, "CURRENCYCODE", "USD");
// WsUtil.SetValue(integrationObject, "LINETYPE", "ITEM");
// WsUtil.SetValue(integrationObject, "TOSITEID", user.SiteId.ToUpper());
// WsUtil.SetValue(integrationObject, "CONSIGNMENT", false);
// WsUtil.SetValue(integrationObject, "LINECOST", 0);
// WsUtil.SetValue(integrationObject, "OUTSIDE", false);
// WsUtil.SetValue(integrationObject, "ROLLUP", false);
// WsUtil.SetValue(integrationObject, "ENTEREDASTASK", false);
// WsUtil.SetValue(integrationObject, "ITEMSETID", itemsetid);
// WsUtil.SetValue(integrationObject, "ENTERBY", user.Login.ToUpper());
// WsUtil.SetValue(integrationObject, "ORGID", user.OrgId.ToUpper());
// WsUtil.SetValue(integrationObject, "SITEID", user.SiteId.ToUpper());
// WsUtil.SetValue(integrationObject, "REFWO", recordKey);
// WsUtil.SetValue(integrationObject, "ACTUALDATE", DateTime.Now.FromServerToRightKind(), true);
// WsUtil.SetValue(integrationObject, "TRANSDATE", DateTime.Now.FromServerToRightKind(), true);
// WsUtil.SetValue(integrationObject, "TRANSDATE", DateTime.Now.FromServerToRightKind(), true);
// WsUtil.SetValue(integrationObject, "ENTERDATE", DateTime.Now.FromServerToRightKind(), true);
// ReflectionUtil.SetProperty(integrationObject, "action", OperationType.AddChange.ToString());
// });
//}
protected override void HandleMaterials(MaximoOperationExecutionContext maximoTemplateData, CrudOperationData entity, object wo)
{
var materials = (IEnumerable <CrudOperationData>)entity.GetRelationship("matusetrans");
var newMaterials = materials.Where(r => r.GetAttribute("matusetransid") == null);
var recordKey = entity.Id;
var user = SecurityFacade.CurrentUser();
var crudOperationDatas = newMaterials as CrudOperationData[] ?? newMaterials.ToArray();
WsUtil.CloneArray(crudOperationDatas, wo, "MATUSETRANS", delegate(object integrationObject, CrudOperationData crudData) {
var itemsetid = (string)crudOperationDatas[0].GetAttribute("item_.itemsetid");
var qtyRequested = (double)WsUtil.GetRealValue(integrationObject, "QTYREQUESTED");
WsUtil.SetValue(integrationObject, "MATUSETRANSID", -1);
WsUtil.SetValue(integrationObject, "ITEMNUM", "PK-NO1-7006");
WsUtil.SetValue(integrationObject, "STORELOC", "NO1");
WsUtil.SetValue(integrationObject, "TRANSDATE", DateTime.Now.FromServerToRightKind(), true);
WsUtil.SetValue(integrationObject, "ACTUALDATE", DateTime.Now.FromServerToRightKind(), true);
WsUtil.SetValue(integrationObject, "QUANTITY", -1);
WsUtil.SetValue(integrationObject, "CURBAL", 3);
WsUtil.SetValue(integrationObject, "PHYSCNT", 7);
WsUtil.SetValue(integrationObject, "UNITCOST", 17.36);
WsUtil.SetValue(integrationObject, "ACTUALCOST", 17.36);
WsUtil.SetValue(integrationObject, "CONVERSION", 1);
WsUtil.SetValue(integrationObject, "ASSETNUM", "400-153");
WsUtil.SetValue(integrationObject, "ENTERBY", "JMALONG");
WsUtil.SetValue(integrationObject, "MEMO", "123");
WsUtil.SetValue(integrationObject, "OUTSIDE", false);
WsUtil.SetValue(integrationObject, "ISSUETO", "DHELMS");
WsUtil.SetValue(integrationObject, "ROLLUP", false);
WsUtil.SetValue(integrationObject, "BINNUM", "AL001");
WsUtil.SetValue(integrationObject, "ISSUETYPE", "ISSUE");
WsUtil.SetValue(integrationObject, "GLDEBITACCT", "5030-100-101");
WsUtil.SetValue(integrationObject, "LINECOST", 17.36);
WsUtil.SetValue(integrationObject, "FINANCIALPERIOD", "QTR3_7");
WsUtil.SetValue(integrationObject, "CURRENCYCODE", "USD");
WsUtil.SetValue(integrationObject, "CURRENCYUNITCOST", 17.36);
WsUtil.SetValue(integrationObject, "CURRENCYLINECOST", 17.36);
WsUtil.SetValue(integrationObject, "LOCATION", "22335");
WsUtil.SetValue(integrationObject, "DESCRIPTION", "FILTER FUEL / CAT 1R-0751");
WsUtil.SetValue(integrationObject, "EXCHANGERATE", 1);
WsUtil.SetValue(integrationObject, "SPAREPARTADDED", false);
WsUtil.SetValue(integrationObject, "QTYREQUESTED", 1);
WsUtil.SetValue(integrationObject, "ORGID", "BSAKSS");
WsUtil.SetValue(integrationObject, "SITEID", "KOD016");
WsUtil.SetValue(integrationObject, "REFWO", "41772");
WsUtil.SetValue(integrationObject, "ENTEREDASTASK", false);
WsUtil.SetValue(integrationObject, "LINETYPE", "ITEM");
WsUtil.SetValue(integrationObject, "ITEMSETID", "ITEM2");
WsUtil.SetValue(integrationObject, "CONDRATE", 100);
WsUtil.SetValue(integrationObject, "COMMODITYGROUP", "AUTO");
WsUtil.SetValue(integrationObject, "COMMODITY", "FILTERS");
WsUtil.SetValue(integrationObject, "TOSITEID", "KOD016");
WsUtil.SetValue(integrationObject, "CONSIGNMENT", false);
ReflectionUtil.SetProperty(integrationObject, "action", OperationType.AddChange.ToString());
});
}
private static void FillLineCostLabor(object integrationObject)
{
try {
var payRateAux = WsUtil.GetRealValue(integrationObject, "PAYRATE");
double payRate;
double.TryParse(payRateAux.ToString(), out payRate);
var regularHrsAux = WsUtil.GetRealValue(integrationObject, "REGULARHRS");
int regularHrs;
int.TryParse(regularHrsAux.ToString(), out regularHrs);
var lineCost = (payRate * regularHrs);
WsUtil.SetValue(integrationObject, "LINECOST", lineCost);
}
catch {
WsUtil.SetValue(integrationObject, "LINECOST", null);
}
}
private static void HandleTools(MaximoOperationExecutionContext maximoTemplateData, CrudOperationData entity, object wo)
{
var tooltrans = (IEnumerable <CrudOperationData>)entity.GetRelationship("tooltrans");
var newTools = tooltrans.Where(r => r.GetAttribute("tooltransid") == null);
var recordKey = entity.Id;
var user = SecurityFacade.CurrentUser();
var crudOperationDatas = newTools as CrudOperationData[] ?? newTools.ToArray();
WsUtil.CloneArray(crudOperationDatas, wo, "TOOLTRANS", delegate(object integrationObject, CrudOperationData crudData) {
var itemsetid = (string)crudOperationDatas[0].GetAttribute("toolitem_.itemsetid");
var qtyRequested = (Int64)WsUtil.GetRealValue(integrationObject, "TOOLQTY");
var hrsRequested = (double)WsUtil.GetRealValue(integrationObject, "TOOLHRS");
var rate = qtyRequested / hrsRequested;
WsUtil.SetValue(integrationObject, "TOOLTRANSID", -1);
WsUtil.SetValue(integrationObject, "TOOLQTY", qtyRequested);
WsUtil.SetValue(integrationObject, "TOOLHRS", hrsRequested);
WsUtil.SetValue(integrationObject, "TOOLRATE", rate);
WsUtil.SetValue(integrationObject, "LINECOST", 0);
WsUtil.SetValue(integrationObject, "OUTSIDE", false);
WsUtil.SetValue(integrationObject, "ROLLUP", false);
WsUtil.SetValue(integrationObject, "ENTEREDASTASK", false);
WsUtil.SetValue(integrationObject, "ITEMSETID", itemsetid);
WsUtil.SetValue(integrationObject, "ENTERBY", user.Login.ToUpper());
WsUtil.SetValue(integrationObject, "ORGID", user.OrgId.ToUpper());
WsUtil.SetValue(integrationObject, "SITEID", user.SiteId.ToUpper());
WsUtil.SetValue(integrationObject, "REFWO", recordKey);
WsUtil.SetValue(integrationObject, "ACTUALDATE", DateTime.Now.FromServerToRightKind(), true);
WsUtil.SetValue(integrationObject, "TRANSDATE", DateTime.Now.FromServerToRightKind(), true);
WsUtil.SetValue(integrationObject, "TRANSDATE", DateTime.Now.FromServerToRightKind(), true);
WsUtil.SetValue(integrationObject, "ENTERDATE", DateTime.Now.FromServerToRightKind(), true);
ReflectionUtil.SetProperty(integrationObject, "action", OperationType.Change.ToString());
});
}
public void UpdateStatus(UpdateStatusOperationData opData)
{
MaximoOperationExecutionContext maximoExecutionContext = GetContext(opData);
var user = SecurityFacade.CurrentUser();
object wo = maximoExecutionContext.IntegrationObject;
//just to validate that the json can be converted to a num
WsUtil.SetValue(wo, "wonum", opData.wonum);
var woStatus = WsUtil.SetValue(wo, "STATUS", opData.status);
var statusDate = WsUtil.SetValue(wo, "STATUSDATE", opData.statusdate ?? DateTime.Now.FromServerToRightKind());
object statusIFace = WsUtil.SetValue(wo, "STATUSIFACE", true);
var nemo = ReflectionUtil.InstantiateProperty(wo, "NP_STATUSMEMO", new { Value = WsUtil.GetRealValue(wo, "MEMO") });
WsUtil.SetChanged(nemo, statusIFace, statusDate, woStatus);
maximoExecutionContext.InvokeProxy();
}