private bool Authorized(getOrderStatusDetailsRequest1 request, ref string errorMessage)
{
using (var context = new Landau_PromoStandardsEntities())
{
var authQuery = context.Authentications.Where(x => x.UserId == request.GetOrderStatusDetailsRequest.id).FirstOrDefault();
if (!string.IsNullOrEmpty(authQuery.UserId))
{
if (authQuery.Password.Equals(request.GetOrderStatusDetailsRequest.password))
{
return(true);
}
else
{
errorMessage += "105: Authentication Credentials failed";
return(false);
}
}
else
{
errorMessage += "100: ID (customerID) not found";
return(false);
}
}
}
private bool Valid(getOrderStatusDetailsRequest1 request, ref string errorMessage)
{
bool isValidRequest = true;
if (request.GetOrderStatusDetailsRequest is null)
{
isValidRequest = false;
errorMessage += "999: General Error – Contact the System Service Provider";
}
else
{
if (request.GetOrderStatusDetailsRequest.wsVersion != "1.0.0")
{
isValidRequest = false;
errorMessage += "115: wsVersion not found";
}
if (string.IsNullOrEmpty(request.GetOrderStatusDetailsRequest.id))
{
isValidRequest = false;
errorMessage += "110: Authentication Credentials required";
}
if (string.IsNullOrEmpty(request.GetOrderStatusDetailsRequest.password))
{
isValidRequest = false;
errorMessage += "110: Authentication Credentials required";
}
}
return(isValidRequest);
}
public GetOrderStatusDetailsResponse getOrderStatusDetails(GetOrderStatusDetailsRequest GetOrderStatusDetailsRequest)
{
getOrderStatusDetailsRequest1 inValue = new getOrderStatusDetailsRequest1();
inValue.GetOrderStatusDetailsRequest = GetOrderStatusDetailsRequest;
getOrderStatusDetailsResponse1 retVal = ((OrderStatusService)(this)).getOrderStatusDetails(inValue);
return(retVal.GetOrderStatusDetailsResponse);
}
getOrderStatusDetailsResponse1 OrderStatusService.getOrderStatusDetails(getOrderStatusDetailsRequest1 request)
{
return(base.Channel.getOrderStatusDetails(request));
}
public getOrderStatusDetailsResponse1 getOrderStatusDetails(getOrderStatusDetailsRequest1 request)
{
string errorMessage = string.Empty;
var response = new getOrderStatusDetailsResponse1();
if (Valid(request, ref errorMessage))
{
if (Authorized(request, ref errorMessage))
{
List <GetOrderStatusDetailsResponseOrderStatus> listOrderStatus = new List <GetOrderStatusDetailsResponseOrderStatus>();
switch (request.GetOrderStatusDetailsRequest.queryType)
{
case 1:
//PO Search
using (var context = new LAN_AX2012_PRODEntities1())
{
var orders = context.LAN_SP_B2B_SUBMITTEDORDERBYPONUMBER(request.GetOrderStatusDetailsRequest.referenceNumber).ToList();
foreach (var order in orders)
{
var details = new GetOrderStatusDetailsResponseOrderStatusOrderStatusDetail()
{
factoryOrderNumber = order.OrderNumber,
expectedShipDate = order.RequestedShipDate,
expectedShipDateSpecified = true,
validTimestamp = DateTime.UtcNow
};
switch (order.SALESSTATUS)
{
case 0:
details.statusID = GetOrderStatusDetailsResponseOrderStatusOrderStatusDetailStatusID.None;
details.statusName = "None";
break;
case 1:
details.statusID = GetOrderStatusDetailsResponseOrderStatusOrderStatusDetailStatusID.OpenOrder;
details.statusName = "Open Order";
break;
case 2:
details.statusID = GetOrderStatusDetailsResponseOrderStatusOrderStatusDetailStatusID.Delivered;
details.statusName = "Delivered";
break;
case 3:
details.statusID = GetOrderStatusDetailsResponseOrderStatusOrderStatusDetailStatusID.Invoiced;
details.statusName = "Invoiced";
break;
case 4:
details.statusID = GetOrderStatusDetailsResponseOrderStatusOrderStatusDetailStatusID.Canceled;
details.statusName = "Canceled";
break;
default:
break;
}
GetOrderStatusDetailsResponseOrderStatus ordersdetails = new GetOrderStatusDetailsResponseOrderStatus()
{
purchaseOrderNumber = order.PONumber,
OrderStatusDetailArray = new GetOrderStatusDetailsResponseOrderStatusOrderStatusDetail[] { details }
};
listOrderStatus.Add(ordersdetails);
}
response.GetOrderStatusDetailsResponse = new GetOrderStatusDetailsResponse();
response.GetOrderStatusDetailsResponse.OrderStatusArray = listOrderStatus.ToArray();
}
break;
case 2:
//SO Search
using (var context = new LAN_AX2012_PRODEntities1())
{
var orders = context.LAN_SP_B2B_SUBMITTEDORDERBYORDERIDWITHSTATUS(request.GetOrderStatusDetailsRequest.referenceNumber).ToList();
foreach (var order in orders)
{
var details = new GetOrderStatusDetailsResponseOrderStatusOrderStatusDetail()
{
factoryOrderNumber = order.OrderNumber,
expectedShipDate = order.RequestedShipDate,
expectedShipDateSpecified = true,
validTimestamp = DateTime.UtcNow
};
switch (order.SALESSTATUS)
{
case 0:
details.statusID = GetOrderStatusDetailsResponseOrderStatusOrderStatusDetailStatusID.None;
details.statusName = "None";
break;
case 1:
details.statusID = GetOrderStatusDetailsResponseOrderStatusOrderStatusDetailStatusID.OpenOrder;
details.statusName = "Open Order";
break;
case 2:
details.statusID = GetOrderStatusDetailsResponseOrderStatusOrderStatusDetailStatusID.Delivered;
details.statusName = "Delivered";
break;
case 3:
details.statusID = GetOrderStatusDetailsResponseOrderStatusOrderStatusDetailStatusID.Invoiced;
details.statusName = "Invoiced";
break;
case 4:
details.statusID = GetOrderStatusDetailsResponseOrderStatusOrderStatusDetailStatusID.Canceled;
details.statusName = "Canceled";
break;
default:
break;
}
GetOrderStatusDetailsResponseOrderStatus ordersdetails = new GetOrderStatusDetailsResponseOrderStatus()
{
purchaseOrderNumber = order.PONumber,
OrderStatusDetailArray = new GetOrderStatusDetailsResponseOrderStatusOrderStatusDetail[] { details }
};
listOrderStatus.Add(ordersdetails);
}
response.GetOrderStatusDetailsResponse = new GetOrderStatusDetailsResponse();
response.GetOrderStatusDetailsResponse.OrderStatusArray = listOrderStatus.ToArray();
}
break;
case 3:
//Last Update Search
using (var context = new LAN_AX2012_PRODEntities1())
{
var orders = context.LAN_SP_B2B_SUBMITTEDORDERSBYACCOUNTWITHSTATUS(request.GetOrderStatusDetailsRequest.id)
.Where(x => x.MODIFIEDDATETIME.ToUniversalTime() > request.GetOrderStatusDetailsRequest.statusTimeStamp).ToList();
foreach (var order in orders)
{
var details = new GetOrderStatusDetailsResponseOrderStatusOrderStatusDetail()
{
factoryOrderNumber = order.OrderNumber,
expectedShipDate = order.RequestedShipDate,
expectedShipDateSpecified = true,
validTimestamp = DateTime.UtcNow
};
switch (order.SALESSTATUS)
{
case 0:
details.statusID = GetOrderStatusDetailsResponseOrderStatusOrderStatusDetailStatusID.None;
details.statusName = "None";
break;
case 1:
details.statusID = GetOrderStatusDetailsResponseOrderStatusOrderStatusDetailStatusID.OpenOrder;
details.statusName = "Open Order";
break;
case 2:
details.statusID = GetOrderStatusDetailsResponseOrderStatusOrderStatusDetailStatusID.Delivered;
details.statusName = "Delivered";
break;
case 3:
details.statusID = GetOrderStatusDetailsResponseOrderStatusOrderStatusDetailStatusID.Invoiced;
details.statusName = "Invoiced";
break;
case 4:
details.statusID = GetOrderStatusDetailsResponseOrderStatusOrderStatusDetailStatusID.Canceled;
details.statusName = "Canceled";
break;
default:
break;
}
GetOrderStatusDetailsResponseOrderStatus ordersdetails = new GetOrderStatusDetailsResponseOrderStatus()
{
purchaseOrderNumber = order.PONumber,
OrderStatusDetailArray = new GetOrderStatusDetailsResponseOrderStatusOrderStatusDetail[] { details }
};
listOrderStatus.Add(ordersdetails);
}
response.GetOrderStatusDetailsResponse = new GetOrderStatusDetailsResponse();
response.GetOrderStatusDetailsResponse.OrderStatusArray = listOrderStatus.ToArray();
}
break;
case 4:
//All Open Search
using (var context = new LAN_AX2012_PRODEntities1())
{
var orders = context.LAN_SP_B2B_SUBMITTEDORDERSBYACCOUNTWITHSTATUS(request.GetOrderStatusDetailsRequest.id)
.Where(x => x.SALESSTATUS == 1).ToList();
foreach (var order in orders)
{
var details = new GetOrderStatusDetailsResponseOrderStatusOrderStatusDetail()
{
factoryOrderNumber = order.OrderNumber,
expectedShipDate = order.RequestedShipDate,
expectedShipDateSpecified = true,
validTimestamp = DateTime.UtcNow
};
switch (order.SALESSTATUS)
{
case 0:
details.statusID = GetOrderStatusDetailsResponseOrderStatusOrderStatusDetailStatusID.None;
details.statusName = "None";
break;
case 1:
details.statusID = GetOrderStatusDetailsResponseOrderStatusOrderStatusDetailStatusID.OpenOrder;
details.statusName = "Open Order";
break;
case 2:
details.statusID = GetOrderStatusDetailsResponseOrderStatusOrderStatusDetailStatusID.Delivered;
details.statusName = "Delivered";
break;
case 3:
details.statusID = GetOrderStatusDetailsResponseOrderStatusOrderStatusDetailStatusID.Invoiced;
details.statusName = "Invoiced";
break;
case 4:
details.statusID = GetOrderStatusDetailsResponseOrderStatusOrderStatusDetailStatusID.Canceled;
details.statusName = "Canceled";
break;
default:
break;
}
GetOrderStatusDetailsResponseOrderStatus ordersdetails = new GetOrderStatusDetailsResponseOrderStatus()
{
purchaseOrderNumber = order.PONumber,
OrderStatusDetailArray = new GetOrderStatusDetailsResponseOrderStatusOrderStatusDetail[] { details }
};
listOrderStatus.Add(ordersdetails);
}
response.GetOrderStatusDetailsResponse = new GetOrderStatusDetailsResponse();
response.GetOrderStatusDetailsResponse.OrderStatusArray = listOrderStatus.ToArray();
}
break;
default:
errorMessage += "Unknown Query Type.";
response.GetOrderStatusDetailsResponse.errorMessage = errorMessage;
break;
}
}
}
else
{
response.GetOrderStatusDetailsResponse = new GetOrderStatusDetailsResponse();
response.GetOrderStatusDetailsResponse.errorMessage = errorMessage;
}
return(response);
}