public void Update(Edi_Customer instance)
{
if (instance == null)
{
throw new ArgumentNullException();
}
this._repository.Update(instance);
}
public string Create(Edi_Customer instance)
{
if (instance == null)
{
throw new ArgumentNullException();
}
return(this._repository.Create(instance));
}
public override string Process(Edi_Customer c, string s, string _EdiBase)
{
string _Log = "";
if (c.Mode == true)
{
FtpFile.RemoveFile(c.RSSBus_PortId + "/Receive", _EdiBase, s);
}
return(_Log);
}
/// <summary> _ediAdapterFactory
/// read edi message to map order list
/// </summary>
/// <param name="parserFile"></param>
/// <returns></returns>
private void readEdi(string parserFile, Edi_Customer c, string s)
{
string _EdiBasePath = ConfigurationManager.AppSettings["EdiBase"];
string edi = System.IO.File.ReadAllText(parserFile);
EdiDataReader r = new EdiDataReader();
EdiBatch b = r.FromString(edi);
EdiTrans _Trans = b.Interchanges[0].Groups[0].Transactions[0];
EdiBase _EdiBase = _ediAdapterFactory.CreateEdiAdapter(_Trans.Definition.ToString());
string _Log = _EdiBase.Parse(b, c, parserFile);
txtLog.Text += _Log;
_Log = _EdiBase.Process(c, s, _EdiBasePath);
txtLog.Text += _Log;
}
public override string Process(Edi_Customer c, string s, string _EdiBase)
{
string _Log = "";
string _ParserFile = "";
string _OrderNumber = FormJob.creatOrder(edi.SapSalesOrder);
if (_OrderNumber != "")
{
insertZSDT046(_OrderNumber);
if (c.Mode == true)
{
FtpFile.RemoveFile(c.RSSBus_PortId + "/Receive", _EdiBase, s);
}
}
else
{
_Log = _Log + " File :" + _ParserFile + "\r\n" + "Create order fail";
logger.Error(_Log);
}
return(_Log);
}
/// <summary>
/// for mouser
/// </summary>
/// <param name="b"></param>
/// <returns></returns>
public override string Parse(EdiBatch b, Edi_Customer c, string parserFile)
{
return("");
}
public virtual string Process(Edi_Customer c, string s, string _EdiBase)
{
string _Log = "";
return(_Log);
}
public virtual string Parse(EdiBatch b, Edi_Customer c, string _FilePath)
{
string _Log = "";
return(_Log);
}
/// <summary>
/// get Sap ZSDT046 table SAP_PROC = ''
/// get status = 'S' sap order
/// 855 message:according to 850 table & sap order data
/// insert 855 data to database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void BtnOrderComfirm_Click(object sender, EventArgs e)
{
string _Log = "";
string _OrderNumber = "";
try
{
string _EdiBase = ConfigurationManager.AppSettings["EdiBase"];
btnLogin.PerformClick();
btnGet.PerformClick();
List <Edi_SalesHeader> _SalesHeaderList = getSalesHeaderList();
Edi_SalesOrder_855 _Edi_SalesOrder_855 = new Edi_SalesOrder_855();
TestWebApi.BLL.Edi.Edi_SalesHeader_855 _855 = new TestWebApi.BLL.Edi.Edi_SalesHeader_855();
List <EdiStatus> _EdiStatusList = GetSapEdiStatusList();
foreach (EdiStatus s in _EdiStatusList)
{
_OrderNumber = s.VBELN;
_Log = "\r\n" + DateTime.Now.ToString("yyyy/MM/dd hh:mm:ss") + " CreateOrderComfirm: Order Number:" + _OrderNumber;
List <SOrder> _SOrderList = GetSapSalesHeaderList(s.VBELN);
List <Edi_SalesItem> _SalesItemList = getSalesItemList(s.VBELN);
List <Edi_SalesSchedule> _SalesScheduleList = getSalesScheduleList(s.VBELN);
if (_SOrderList.Count > 0)
{
Edi_SalesHeader _Edi_SalesHeader = _SalesHeaderList.Where(x => x.OrderNumber == s.VBELN).First();
if (_edi_Customerlist.Where(x => x.SapCustomerId == _SOrderList.First().KUNNR).ToList().Count > 0)
{
Edi_Customer c = _edi_Customerlist.Where(x => x.SapCustomerId == _SOrderList.First().KUNNR).First();
_Edi_SalesOrder_855 = _855.LineItemStatus(_Edi_SalesHeader, _SOrderList, _SalesItemList, _SalesScheduleList);
if (_855.ListError.Count == 0)
{
string _Mode = c.Mode == true ? "P" : "T";
if (c.Mode == _EdiMode)//PRD
{
string _855Msg = _855.X12_855(_Edi_SalesOrder_855, _Mode, c.ReceiverId);
insertEdi_855(_Edi_SalesOrder_855);
string _FileName = "855_" + _Edi_SalesOrder_855.Header.PURCH_NO_C + "_" + DateTime.Now.ToString("yyyyMMdd") + "_" + Guid.NewGuid().ToString("N") + ".edi";
string _EdiCustomerSend = c.RSSBus_PortId + "/Send";
//write edi file
FtpFile.CopyTo("Edi", _EdiCustomerSend, _FileName, _855Msg);
//upload to RSSBus send directory
FtpFile.Upload("Edi", _EdiCustomerSend, _EdiBase, _FileName);
if (c.Mode == true)
{
updateZSDT046(s.VBELN);
}
}
}
else
{
_Log = _Log + "\r\n" + _855.ListError[0];
logger.Error(_Log);
txtLog.Text += _Log;
}
}
}
}
}
catch (Exception ex)
{
_Log = "\r\n" + DateTime.Now.ToString("yyyy/MM/dd hh:mm:ss") + " OrderComfirm:Order Number:" + _OrderNumber + "\r\n" + ex.Message;
logger.Error(_Log);
txtLog.Text += _Log;
}
}
/// <summary>
/// for mouser
/// </summary>
/// <param name="b"></param>
/// <returns></returns>
public override string Parse(EdiBatch b, Edi_Customer c, string parserFile)
{
int _ItemNumber = 1;
string _CustomerName = "";
string _Log = "";
SapSalesOrder _SapSalesOrder = new SapSalesOrder();
List <SalesItem> _ItemList = new List <SalesItem>();
List <SalesPartner> _PartnerList = new List <SalesPartner>();
List <SalesSchedule> _ScheduleList = new List <SalesSchedule>();
SalesHeader _Header = new SalesHeader();
_Header.DOC_TYPE = c.DOC_TYPE; //need to discuss
_Header.SALES_ORG = c.SALES_ORG; //need to discuss
_Header.DISTR_CHAN = c.DISTR_CHAN; //need to discuss
_Header.DIVISION = c.DIVISION; //need to discuss
try
{
EdiTrans _PO = b.Interchanges[0].Groups[0].Transactions[0];
EdiSegment _BEG = (EdiSegment)_PO.Content.FirstOrDefault(l => l.Definition.Name == "BEG");
if (_BEG != null)
{
_Header.PURCH_NO_C = _BEG.Content[2].ToString();
_Header.PURCH_DATE = _BEG.Content[4].ToString();
}
_SapSalesOrder.Header = _Header;
var listL_N1 = _PO.Content.Where(l => l.Definition.GetType() == typeof(M_850.L_N1)).Select(l => l).ToList();
foreach (EdiLoop n1 in listL_N1)
{
SalesPartner _Partner = new SalesPartner();
// var _N1Loop = (EdiLoop)n1;
EdiSegment _N1 = (EdiSegment)n1.Content.FirstOrDefault(l => l.Definition.Name == "N1");
if (_N1 != null)
{
if ((_N1.Content[0].ToString() == "BT") || (_N1.Content[0].ToString() == "BY"))
{
_Partner.PARTN_ROLE = "AG";
}
else if (_N1.Content[0].ToString() == "ST")
{
_Partner.PARTN_ROLE = "WE";
}
if (c.EdiType == 1)
{
_Partner.PARTN_NUMB = c.SapCustomerId; //how to know what code in altw sap ,loop edi table
}
else
{
_Partner.PARTN_NUMB = _N1.Content[3].ToString();
}
_CustomerName = _N1.Content[1].ToString();
}
EdiSegment _N3 = (EdiSegment)n1.Content.FirstOrDefault(l => l.Definition.Name == "N3");
if (_N3 != null)
{
_Partner.STREET = _N3.Content[0].ToString();
}
EdiSegment _N4 = (EdiSegment)n1.Content.FirstOrDefault(l => l.Definition.Name == "N4");
if (_N4 != null)
{
_Partner.CITY = _N4.Content[0].ToString();
_Partner.POSTL_CODE = _N4.Content[2].ToString();
_Partner.COUNTRY = _N4.Content[3].ToString();
_Partner.REGION = _N4.Content[1].ToString();
}
EdiSegment _PER = (EdiSegment)n1.Content.FirstOrDefault(l => l.Definition.Name == "PER");
if (_PER != null)
{
_Partner.NAME = _PER.Content[1].ToString();
_Partner.TELEPHONE = _PER.Content[3].ToString();
}
_PartnerList.Add(_Partner);
}
_SapSalesOrder.PartnerList = _PartnerList;
var listL_PO1 = _PO.Content.Where(l => l.Definition.GetType() == typeof(M_850.L_PO1)).Select(l => l).ToList();
foreach (EdiLoop po1 in listL_PO1)
{
int _SchedLine = 1;
SalesItem _Item = new SalesItem();
// var _PO1Loop = (EdiLoop)po1;
EdiSegment _PO1 = (EdiSegment)po1.Content.FirstOrDefault(l => l.Definition.Name == "PO1");
if (_PO1 != null)
{
_Item.ITM_NUMBER = (_ItemNumber * 10).ToString().PadLeft(6, '0'); //need use altw rule 000010
//mouser special logic PO111 is part number
// if(c.SapCustomerId== "0010000136") _Item.MATERIAL = _PO1.Content[10].ToString();
//else _Item.MATERIAL = _PO1.Content[8].ToString();
_Item.MATERIAL = _PO1.Content[Convert.ToInt32(c.PartNumberIndex)].ToString();
_Item.TARGET_QTY = _PO1.Content[1].ToString();
_Item.CUST_MAT35 = _PO1.Content[6].ToString();
_Item.CustomerItemNumber = _PO1.Content[0].ToString();
_Item.CustomerPrice = _PO1.Content[3].ToString();
_Item.CustomerUnit = _PO1.Content[2].ToString();
_Item.CustomerUnitOfPrice = _PO1.Content[4].ToString();
}
_ItemList.Add(_Item);
var listL_SCH = po1.Content.Where(l => l.Definition.GetType() == typeof(M_850.L_SCH)).Select(l => l).ToList();
foreach (EdiLoop sch in listL_SCH)
{
SalesSchedule _Schedule = new SalesSchedule();
// var _SCHLoop = (EdiLoop)sch;
EdiSegment _SCH = (EdiSegment)sch.Content.FirstOrDefault(l => l.Definition.Name == "SCH");
if (_SCH != null)
{
_Schedule.REQ_QTY = _SCH.Content[0].ToString();
_Schedule.ITM_NUMBER = _Item.ITM_NUMBER;
_Schedule.SCHED_LINE = _SchedLine.ToString().PadLeft(4, '0');
_Schedule.REQ_DATE = _SCH.Content[5].ToString();
}
_ScheduleList.Add(_Schedule);
_SchedLine++;
}
_ItemNumber++;
}
_SapSalesOrder.ItemList = _ItemList;
_SapSalesOrder.ScheduleList = _ScheduleList;
_SapSalesOrder.CustomerName = _CustomerName;
_SapSalesOrder.CreateBy = "Edi";
_SapSalesOrder.SalesEmail = c.SalesEmail;
edi.SapSalesOrder = _SapSalesOrder;
}
catch (Exception ex)
{
_Log = "\r\n" + DateTime.Now.ToString("yyyy/MM/dd hh:mm:ss") + " setSalesOrderByEdi: Customer Id:" + c.SapCustomerId + " File :" + parserFile + "\r\n" + ex.Message;
logger.Error(_Log);
edi.Log = _Log;
}
return(_Log);
}
