public bool Process(out string psMessages)
{
bool lbResult = true;
psMessages = "";
try
{
string strUserName = Util.GetString(ConfigurationManager.AppSettings["SAPUserName"]);
string strPassword = Util.GetString(ConfigurationManager.AppSettings["SAPUserPassword"]);
if (strUserName == "")
{
strUserName = "******";
}
if (strPassword == "")
{
strPassword = "******";
}
if (strUserName == "" || strPassword == "")
{
Log.LogError("Failed to get sap username and or password", "OrderImportClasses.ProcessOrders");
psMessages = "Failed to get sap username and or password";
return(false);
}
List <ShippingRequestHeader> headerList;
using (SCT hdb = new SCT())
{
headerList = (from p in hdb.ShippingRequestHeaders where p.ProcessedDate == null select p).ToList();
}
if (headerList.Count > 0)
{
SCTWS.zsd_create_web_so ws = new SCTWS.zsd_create_web_so();
ws.Timeout = 60000;
ws.Url = ws.Url + "?ts=" + System.DateTime.Now.ToString("yyyyMMddHHmmss");
NetworkCredential netCredential = new NetworkCredential(strUserName, strPassword);
Uri uri = new Uri(ws.Url);
ICredentials credentials = netCredential.GetCredential(uri, "Basic");
ws.Credentials = credentials;
foreach (ShippingRequestHeader h in headerList)
{
string lsMessage = "";
if (!ProcessHeader(ws, h.ShipReqID, out lsMessage))
{
SendErrorEmails(lsMessage, h);
lbResult = false;
}
psMessages = string.Concat(psMessages, psMessages == "" ? "" : System.Environment.NewLine, "Processed Header ", h.ShipReqID.ToString(), " ", lsMessage);
}
}
else
{
psMessages = "No unprocessed headers found.";
}
}
catch (Exception ex)
{
Log.LogError(ex.ToString(), "OrderImportClasses.ProcessOrders");
psMessages = ex.ToString();
lbResult = false;
}
return(lbResult);
}
private bool ProcessHeader(SCTWS.zsd_create_web_so poWS, Int32 piShipReqID, out string psMessage)
{
bool lbResult = true;
psMessage = "";
string lsMessage = "";
SCT db = new SCT();
try {
List <ShippingRequestDetail> itemList = null;
ShippingRequestHeader h = db.ShippingRequestHeaders.Find(piShipReqID);
h.ProcessedDate = System.DateTime.Now;
db.SaveChanges();
itemList = (from p in db.ShippingRequestDetails where p.ShipReqID == piShipReqID select p).ToList();
if (itemList != null && itemList.Count > 0)
{
string lsSAPOrderNumber = "";
ZSD_CREATE_WEB_SALES_ORDER so = new ZSD_CREATE_WEB_SALES_ORDER();
so.IS_SO_HEADER = new ZSD_WEB_SO_HEADER_S();
ZSD_WEB_SO_HEADER_S header = so.IS_SO_HEADER;
header.BSTKD = Util.GetString(h.CustomerPONum);
header.BSTKD_E = Util.GetString(h.ConsignmentRef);
header.TEMP = Util.GetString(h.TemperatureID);
header.TRATY = Util.GetString(h.MeansOfTransportID);
header.KUNAG = Util.GetString(h.CustomerAccountID);
header.SHIPFR = Util.GetString(h.PickupFromID);
header.BSTDK = Util.GetString(h.PickupDate.ToString("yyyy-MM-dd"));
header.PICKUP = GetTimeCode(Util.GetString(h.PickupTime), false);
if (header.PICKUP == "")
{
lsMessage = "Unable to resolve PICKUP time code for " + Util.GetString(h.PickupTime);
Log.LogError(lsMessage, "OrderImportClasses.ProcessOrder", piShipReqID);
return(false);
}
header.SHIPTO = Util.GetString(h.DeliverToID);
header.VDATU = Util.GetString(h.DeliveryDate.ToString("yyyy-MM-dd"));
header.DELCO = GetTimeCode(Util.GetString(h.DeliveryTime), true);
if (header.DELCO == "")
{
psMessage = "Unable to resolve DELCO time code for " + Util.GetString(h.DeliveryTime);
Log.LogError(psMessage, "OrderImportClasses.ProcessOrder", piShipReqID);
return(false);
}
header.DELIV_INSTR = Util.GetString(h.DeliveryInstructions);
List <ZSD_WEB_SO_ITEM_S> items = new List <ZSD_WEB_SO_ITEM_S>();
foreach (ShippingRequestDetail i in itemList)
{
ZSD_WEB_SO_ITEM_S item = new ZSD_WEB_SO_ITEM_S();
item.BRGEW = Util.GetDecimal(i.GrossWeight);
item.KWMENG = Util.GetDecimal(i.Quantity);
item.MATNR = Util.GetString(i.MaterialNumber);
item.MEINS = Util.GetString(i.UnitOfMeasure);
item.NTGEW = Util.GetDecimal(i.NetWeight);
item.VOLUM = Util.GetDecimal(i.Volume);
items.Add(item);
}
so.IT_SO_ITEM = items.ToArray();
List <BAPIRET2> retlist = new List <BAPIRET2>();
BAPIRET2 bret = new BAPIRET2();
retlist.Add(bret);
so.ET_RETURN = retlist.ToArray();
ZSD_CREATE_WEB_SALES_ORDERResponse ret = null;
try
{
// Log.LogError("Pre send web request", "OrderImportClasses.ProcessOrders");
ret = poWS.ZSD_CREATE_WEB_SALES_ORDER(so);
// Log.LogError("Post send web request", "OrderImportClasses.ProcessOrders");
if (ret != null && ret.ET_RETURN != null && ret.ET_RETURN.Length > 0)
{
for (int i = 0; i < ret.ET_RETURN.Length; i++)
{
BAPIRET2 returnLine = ret.ET_RETURN[i];
string allMessages = returnLine.MESSAGE + " " +
returnLine.MESSAGE_V1 + " " +
returnLine.MESSAGE_V2 + " " +
returnLine.MESSAGE_V3 + " " +
returnLine.MESSAGE_V4;
if (returnLine.TYPE.ToUpper() != "S")
{
lbResult = false;
psMessage += " " + allMessages;
}
else
{
if (returnLine.NUMBER == "311")
{
allMessages = allMessages.ToLower();
int start = allMessages.IndexOf("booking request");
allMessages = allMessages.Substring(start + "booking request".Length + 1);
start = allMessages.IndexOf("has been saved");
lsSAPOrderNumber = allMessages.Substring(0, start).Trim();
}
}
}
}
else
{
psMessage += "No return data from web service.";
lbResult = false;
}
}
catch (Exception ex)
{
psMessage = ex.ToString();
lbResult = false;
}
if (lbResult)
{
h.SAPOrderNumber = lsSAPOrderNumber;
psMessage += " created order " + lsSAPOrderNumber;
}
else
{
h.SAPOrderNumber = "";
Log.LogError("Failed to create Sales Request Header. " + psMessage + " Customer ID = " + so.IS_SO_HEADER.KUNAG + "; Order No = " + so.IS_SO_HEADER.BSTDK,
"OrderImportClasses.ProcessOrder", h.ShipReqID);
}
h.ProcessedSuccessfully = lbResult;
h.UpdateDate = System.DateTime.Now;
db.SaveChanges();
}
}
catch (Exception e)
{
Log.LogError(e.ToString(), "ProcessOrders.ProcessOrder", piShipReqID);
}
finally
{
if (db != null)
{
db.Dispose();
}
}
return(lbResult);
}
