public DataSwapResponse AddPOSwap(VPBLL.API.Model.POSwap ps)
{
var retObj = new DataSwapResponse();
try
{
VPDAL.yb_po_report_swap obj = new VPDAL.yb_po_report_swap()
{
ebeln = ps.Ebeln,
ebelp = ps.Ebelp,
aedat = DateTime.Parse(ps.Aedat),
name_text = ps.Name_text,
name1 = ps.Name1,
lifnr = ps.Lifnr,
zterm = ps.Zterm,
bukrs = ps.Bukrs,
butxt = ps.Butxt,
matnr = ps.Matnr,
txz01 = ps.Txz01,
menge = double.Parse(ps.Menge),
mwskz = ps.Mwskz,
text1 = ps.Text1,
netpr = double.Parse(ps.Netpr),
peinh = ps.Peinh,
waers = ps.Waers,
netwr = double.Parse(ps.Netwr),
werks = ps.Werks,
eindt = DateTime.Parse(ps.Eindt),
stceg = ps.Stceg,
elikz = ps.Elikz,
ekgrp = ps.Ekgrp,
loekz = ps.Loekz,
status = ps.Status,
bsart = ps.Bsart,
retpo = ps.Retpo,
date_entered = DateTime.Now
};
m_dbContext.AddToyb_po_report_swap(obj);
m_dbContext.SaveChanges();
retObj.ResponseCode = (int)APIResponseCode.Success;
retObj.ResponseMessage = "Success";
}
catch (Exception ex)
{
m_logger.LogError(ps, ex);
retObj.ResponseCode = (int)APIResponseCode.DataSwap_AddDataFailed;
retObj.ResponseMessage = "Add PO Swap Error. " + ex.Message;
}
return retObj;
}
public DataSwapResponse AddGRSwap(VPBLL.API.Model.GRSwap gr)
{
var retObj = new DataSwapResponse();
try
{
var obj = new VPDAL.yb_gr_report_swap()
{
ebeln = gr.Ebeln,
ebelp = gr.Ebelp,
belnr = gr.Belnr,
buzei = gr.Buzei,
bwart = gr.Bwart,
budat = gr.Budat,
menge = gr.Menge,
meins = gr.Meins,
dmbtr = gr.Dmbtr,
bnbtr = gr.Bnbtr,
waers = gr.Waers,
gjahr = gr.Gjahr,
status = gr.Status,
lfbja = gr.Lfbja,
lfbnr = gr.Lfbnr,
lfpos = gr.Lfpos,
werks = gr.Werks
};
m_dbContext.AddToyb_gr_report_swap(obj);
m_dbContext.SaveChanges();
retObj.ResponseCode = (int)APIResponseCode.Success;
retObj.ResponseMessage = "Success";
}
catch (Exception ex)
{
m_logger.LogError(gr, ex);
retObj.ResponseCode = (int)APIResponseCode.DataSwap_AddDataFailed;
retObj.ResponseMessage = "Add GR Swap Error. " + ex.Message;
}
return retObj;
}
public DataSwapResponse SetInvoicePaymentStatus(Model.PaymentSwap ps)
{
var retObj = new DataSwapResponse();
try
{
m_dbContext.AddToyb_payment_report_swap(new VPDAL.yb_payment_report_swap() {
augbl = ps.augbl,
invoice_no = ps.invoice_no,
bukrs = ps.bukrs,
budat = ps.budat,
status_i = ps.status_i,
status = false,
date_entered = DateTime.Now
});
m_dbContext.SaveChanges();
retObj.ResponseCode = (int)APIResponseCode.Success;
retObj.ResponseMessage = "Success";
}
catch (Exception ex)
{
retObj.ResponseCode = (int)APIResponseCode.DataSwap_UpdateDataFailed;
retObj.ResponseMessage = "SetInvoicePaymentStatus() Failed. " + ex.Message;
m_logger.LogError(ps, ex);
}
return retObj;
}
public DataSwapResponse SetInvoiceMiroStatus(Model.MiroSwap ms)
{
var retObj = new DataSwapResponse();
try
{
m_dbContext.AddToyb_miro_iv_swap(new VPDAL.yb_miro_iv_swap() {
belnr = ms.belnr,
buzei = ms.buzei,
invoice_no = ms.invoice_no,
bukrs = ms.bukrs,
gjahr = ms.gjahr,
zfbdt = ms.zfbdt,
budat = ms.budat,
dmbtr = ms.dmbtr,
status_i = ms.status_i,
status = false,
date_entered = DateTime.Now
});
m_dbContext.SaveChanges();
retObj.ResponseCode = (int)APIResponseCode.Success;
retObj.ResponseMessage = "Success";
}
catch (Exception ex)
{
retObj.ResponseCode = (int)APIResponseCode.DataSwap_UpdateDataFailed;
retObj.ResponseMessage = "SetInvoiceMiroStatus() Failed. " + ex.Message;
m_logger.LogError(ms, ex);
}
return retObj;
}
public DataSwapResponse SetInvoiceDPStatus(string _docid, string _invoice_no, string _bukrs, string _status_i)
{
var retObj = new DataSwapResponse();
try
{
m_dbContext.AddToyb_dp_item_swap(new VPDAL.yb_dp_item_swap() {
docid = _docid,
invoice_no = _invoice_no,
bukrs = _bukrs,
status_i = _status_i,
status = false,
date_entered = DateTime.Now
});
m_dbContext.SaveChanges();
retObj.ResponseCode = (int)APIResponseCode.Success;
retObj.ResponseMessage = "Success";
}
catch (Exception ex)
{
retObj.ResponseCode = (int)APIResponseCode.DataSwap_UpdateDataFailed;
retObj.ResponseMessage = "Update Invoice Status Failed. " + ex.Message;
m_logger.LogError(String.Format("SetInvoiceDPStatus({0}, {1}, {2}, {3}) = Fail", _docid, _invoice_no, _bukrs, _status_i), ex);
}
return retObj;
}
public DataSwapResponse MarkInvoicesSynced(int[] invoiceSwapIds)
{
var retObj = new DataSwapResponse();
try
{
bool bHaveUpdate = false;
foreach (var id in invoiceSwapIds)
{
var objs = from o in m_dbContext.yb_invoice_report_swap
where o.id == id
select o;
foreach (var yi in objs)
{
yi.flag = false;
yi.date_modified = DateTime.Now;
bHaveUpdate = true;
}
}
if (bHaveUpdate)
m_dbContext.SaveChanges();
retObj.ResponseCode = (int)APIResponseCode.Success;
retObj.ResponseMessage = "Success";
}
catch (Exception ex)
{
retObj.ResponseCode = (int)APIResponseCode.DataSwap_UpdateDataFailed;
retObj.ResponseMessage = "Fail to mark the invoice sync flag. " + ex.Message;
m_logger.LogError(invoiceSwapIds, ex);
}
return retObj;
}
public VPBLL.API.DataSwapResponse AddVendorSwap(Model.VendorSwap vs)
{
var retObj = new DataSwapResponse();
try
{
m_dbContext.AddToyb_vendor_swap(new VPDAL.yb_vendor_swap() {
lifnr = vs.lifnr,
name1 = vs.name1,
brsch = vs.brsch,
stceg = vs.stceg,
bankl = vs.bankl,
banka = vs.bankl,
bankn = vs.bankn,
name2 = vs.name2,
bukrs = vs.bukrs,
zterm = vs.zterm,
sperr = vs.sperr,
loevm = vs.loevm,
status = false,
date_entered = DateTime.Now
});
m_dbContext.SaveChanges();
retObj.ResponseCode = (int)APIResponseCode.Success;
retObj.ResponseMessage = "Success";
}
catch (Exception ex)
{
retObj.ResponseCode = (int)APIResponseCode.DataSwap_UpdateDataFailed;
retObj.ResponseMessage = "AddVendorSwap() Failed. " + ex.Message;
m_logger.LogError(vs, ex);
}
return retObj;
}
