//SetValue
private void SetDataTableValuesAuction(List <InvoiceExpDTO> pLstAuctionDTO)
{
try
{
DtMatrixInvoice = this.UIAPIRawForm.DataSources.DataTables.Item("DT_NC");
DtMatrixInvoice.Rows.Clear();
int i = 0;
foreach (InvoiceExpDTO lObjInvoiceExp in pLstAuctionDTO)
{
DtMatrixInvoice.Rows.Add();
DtMatrixInvoice.SetValue("#", i, i + 1);
DtMatrixInvoice.SetValue("C_BP", i, lObjInvoiceExp.BussinesPartner);
DtMatrixInvoice.SetValue("C_Cert", i, lObjInvoiceExp.Certificate);
DtMatrixInvoice.SetValue("C_Inv", i, lObjInvoiceExp.DocNum);
DtMatrixInvoice.SetValue("C_HeadInv", i, lObjInvoiceExp.HeadInvoice);
DtMatrixInvoice.SetValue("C_HeadExp", i, lObjInvoiceExp.HeatExport);
DtMatrixInvoice.SetValue("C_HeadNoCr", i, lObjInvoiceExp.HeadNoCruz);
DtMatrixInvoice.SetValue("C_Amount", i, lObjInvoiceExp.Amount);
DtMatrixInvoice.SetValue("C_DocEntry", i, lObjInvoiceExp.DocEntry);
DtMatrixInvoice.SetValue("C_Paid", i, lObjInvoiceExp.PaidToDate);
i++;
}
}
catch (Exception ex)
{
UIApplication.ShowError("frm (BindDataMatrix) " + ex.Message);
LogService.WriteError("frm (BindDataMatrix) " + ex.Message);
LogService.WriteError(ex);
}
}
private void getCodes()
{
dtList.Rows.Clear();
string codeType = "Group";
if (opI.Selected)
{
codeType = "Item";
}
string strSql = "SELECT \"Name\",\"U_Descr\" FROM \"@B1_QA_ATTR_CODES\" WHERE \"U_CodeType\" = '" + codeType + "'";
System.Data.DataTable dtCodes = Program.objHrmsUI.getDataTable(strSql, "gettingCodes");
int i = 0;
foreach (System.Data.DataRow dr in dtCodes.Rows)
{
i++;
dtList.Rows.Add(1);
dtList.SetValue("Id", i - 1, i.ToString());
dtList.SetValue("Code", i - 1, dr["Name"].ToString());
dtList.SetValue("Name", i - 1, dr["U_Descr"].ToString());
}
mtList.LoadFromDataSource();
}
private Boolean ValidarDataTable(String Cuenta, Int32 pRow)
{
try
{
for (Int32 i = 0; i < oDataTable.Rows.Count; i++)
{
if (((System.String)oDataTable.GetValue("Cuenta", i)) != "")
{
if ((((System.String)oDataTable.GetValue("Cuenta", i)).Trim() == Cuenta) && (pRow != i))
{
FSBOApp.StatusBar.SetText("Cuenta " + Cuenta + " ya se encuentra ingresada en el formulario", BoMessageTime.bmt_Short, BoStatusBarMessageType.smt_Warning);
oDataTable.SetValue("Cuenta", pRow, "");
oDataTable.SetValue("Descripcion", pRow, "");
return(false);
}
}
}
return(true);
}
catch (Exception a)
{
FSBOApp.StatusBar.SetText("ValidarDataTable: " + a.Message + " ** Trace: " + a.StackTrace, BoMessageTime.bmt_Short, BoStatusBarMessageType.smt_Error);
OutLog("ValidarDataTable: " + a.Message + " ** Trace: " + a.StackTrace);
return(false);
}
}
/// <summary>
/// Fill Livestock Matrix Data By Parallel Loopps
/// </summary>
/// <param name="tableID"></param>
/// <param name="dataTable"></param>
/// <param name="client"></param>
/// <param name="type"></param>
private void FillMatrix1(string tableID, SAPbouiCOM.DataTable dataTable, string client, string type)
{
try {
dataTable.Rows.Clear();
livestock = massInvoicingDAO.GetDistributedLiveStock(client, type);
var columns = new List <string>(columnsExit.Keys);
if (livestock.Count > 0)
{
Parallel.For(0, livestock.Count, row => {
dataTable.Rows.Add();
});
Task.Factory.StartNew(() => {
Parallel.For(0, livestock.Count, row => {
dataTable.SetValue("C_#", row, row + 1);
});
});
Parallel.ForEach(Partitioner.Create(0, livestock.Count), (range, state) => {
for (int i = range.Item1; i < range.Item2; i++)
{
Parallel.ForEach(columns.Skip(1), column => {
dataTable.SetValue(column, i, livestock[i].GetType().GetProperty(column.Replace("C_", String.Empty)).GetValue(livestock[i], null));
});
}
});
BindDataMatrix(mtx1, tableID, columns);
if (type.Equals("N"))
{
Task.Factory.StartNew(() => {
batches = massInvoicingDAO.GetBatches(client, user.WhsCode, type);
floorServiceLines = massInvoicingDAO.GetFloorServiceLines(client, user.WhsCode, type);
});
}
}
else
{
ClearMtx(mtx1);
}
}
catch (AggregateException ae) {
ae.Handle(e => {
HandleException(e, "(AE)");
return(true);
});
}
catch (Exception ex) {
HandleException(ex, "(FillMatrix2)");
}
}
/// <summary>
/// Fill Client Matrix Data By Parallel Loopps
/// </summary>
/// <param name="tableID"></param>
/// <param name="dataTable"></param>
private void FillMatrix0(string tableID, SAPbouiCOM.DataTable dataTable, string type)
{
try {
dataTable.Rows.Clear();
var columns = new List <string>(columnsClient.Keys);
pendingInvoices = massInvoicingDAO.GetInvoicesPending(type);
if (pendingInvoices.Count > 0)
{
//add empty rows to datatable
Parallel.For(0, pendingInvoices.Count, row => {
dataTable.Rows.Add();
});
//add the index column in a separate task
Task.Factory.StartNew(() => {
Parallel.For(0, pendingInvoices.Count, row => {
dataTable.SetValue("C_#", row, row + 1);
});
});
//popolate the empty rows of the matrix
Parallel.ForEach(Partitioner.Create(0, pendingInvoices.Count), (range, state) => {
for (int i = range.Item1; i < range.Item2; i++)
{
Parallel.ForEach(columns.Skip(1), column => {
dataTable.SetValue(column, i, pendingInvoices[i].GetType().GetProperty(column.Replace("C_", String.Empty)).GetValue(pendingInvoices[i], null));
});
}
});
//bind datatable with matrix
BindDataMatrix(mtx0, tableID, columns);
LogService.WriteInfo("(frmDelivery) Matriz Cargada correctamente");
}
else
{
ClearMtx(mtx0);
}
}
catch (AggregateException ae) {
ae.Handle(e => {
HandleException(e, "(AE)");
return(true);
});
}
catch (Exception ex) {
if (!invoicedFlag)
{
HandleException(ex, "(FillMatrix0)");
}
}
}
}//fin InitForm
public new void FormEvent(String FormUID, ref SAPbouiCOM.ItemEvent pVal, ref Boolean BubbleEvent)
{
Int32 nErr;
String sErr;
base.FormEvent(FormUID, ref pVal, ref BubbleEvent);
try
{
if (pVal.ItemUID == "3")
{
if ((pVal.ColUID == "Code") && (!pVal.BeforeAction) && (pVal.EventType == BoEventTypes.et_COMBO_SELECT))
{
if (pVal.Row == oDataTable.Rows.Count - 1)
{
if ((System.String)(oDataTable.GetValue("Code", oDataTable.Rows.Count - 1)) != "")
{
oDataTable.Rows.Add(1);
oDataTable.SetValue("Code", oDataTable.Rows.Count - 1, "");
oDataTable.SetValue("Name", oDataTable.Rows.Count - 1, "");
}
}
}
}
if ((pVal.EventType == BoEventTypes.et_ITEM_PRESSED) && (pVal.BeforeAction))
{
var paso = false;
if ((pVal.ItemUID == "1") && ((oForm.Mode == BoFormMode.fm_ADD_MODE) || (oForm.Mode == BoFormMode.fm_UPDATE_MODE)))
{
BubbleEvent = false;
if (LimpiarGrid())
{
paso = CrearDatos();
}
if ((paso) && (oForm.Mode != BoFormMode.fm_OK_MODE))
{
oForm.Mode = BoFormMode.fm_OK_MODE;
}
}
else if ((pVal.ItemUID == "1") && (oForm.Mode == BoFormMode.fm_OK_MODE))
{
BubbleEvent = true;
}
}
}
catch (Exception e)
{
FCmpny.GetLastError(out nErr, out sErr);
FSBOApp.StatusBar.SetText("FormEvent: " + e.Message + " ** Trace: " + e.StackTrace, BoMessageTime.bmt_Short, BoStatusBarMessageType.smt_Error);
OutLog("FormEvent: " + e.Message + " ** Trace: " + e.StackTrace);
}
}//fin FormEvent
private void loadSetting()
{
Program.objHrmsUI.loadSettings();
try
{
cardCode = Program.objHrmsUI.settings["WebCardCode"].ToString();
dtHead.SetValue("CardCode", 0, Program.objHrmsUI.settings["WebCardCode"].ToString());
dtHead.SetValue("slp", 0, Program.objHrmsUI.settings["WebSlpCode"].ToString());
dtHead.SetValue("branch", 0, Program.objHrmsUI.settings["WebBranch"].ToString());
dtHead.SetValue("Whs", 0, Program.objHrmsUI.settings["Warehouse"].ToString());
}
catch { }
}
private void getCodes()
{
dtList.Rows.Clear();
string codeType = "Group";
string strSql = "SELECT \"Code\" , \"Name\" FROM \"@B1_QA_OUSR\"";
System.Data.DataTable dtCodes = Program.objHrmsUI.getDataTable(strSql, "gettingCodes");
int i = 0;
foreach (System.Data.DataRow dr in dtCodes.Rows)
{
i++;
dtList.Rows.Add(1);
dtList.SetValue("Id", i - 1, i.ToString());
dtList.SetValue("Code", i - 1, dr["Code"].ToString());
dtList.SetValue("Name", i - 1, dr["Name"].ToString());
}
mtList.LoadFromDataSource();
}
private void fillAddons()
{
dtHead.Rows.Clear();
string strSql = "Select * from [@B1_MODULES]";
System.Data.DataTable dtModules = Program.objHrmsUI.getDataTable(strSql, "Filling Module");
int i = 0;
foreach (System.Data.DataRow dr in dtModules.Rows)
{
dtHead.Rows.Add(1);
dtHead.SetValue("Id", i, (i + 1).ToString());
dtHead.SetValue("AC", i, dr["CODE"].ToString());
dtHead.SetValue("AN", i, dr["NAME"].ToString());
dtHead.SetValue("LK", i, dr["U_LicenseKey"].ToString());
dtHead.SetValue("Active", i, dr["U_Enabled"].ToString());
i++;
}
mtAddon.LoadFromDataSource();
}
private void FillOrderMatrix()
{
oForm.Freeze(true);
dtWebO.Rows.Clear();
int i = 0;
DateTime OrdersSinceCreateDate = Convert.ToDateTime(dtHead.GetValue("From", 0));
DateTime OrdersToCreateDate = Convert.ToDateTime(dtHead.GetValue("To", 0));
string LTDINCCard = Program.objHrmsUI.getSetting("INCCODE").ToString();
string strSql = "Select DocEntry, Convert(varchar(30),DocDate,101) as DocDate,OINV.DocNum from OINV where OINV.CardCode = '" + LTDINCCard + "' And DocDate between '" + OrdersSinceCreateDate.ToString("yyyyMMdd") + "' and '" + OrdersToCreateDate.ToString("yyyyMMdd") + "' order by DocNum";
System.Data.DataTable dtOrders = Program.dsLTD.getDataTable(strSql, "gettingOrders");
string selStatus = cbOS.Selected.Value.ToString();
foreach (System.Data.DataRow dr in dtOrders.Rows)
{
string orderStatus = "O";
string strId = dr["DocEntry"].ToString();
string pchEntry = getDocNum("LTD Inv # " + dr["DocNum"].ToString(), "OPOR");
if (pchEntry != "" && pchEntry != "0")
{
orderStatus = "C";
}
if (selStatus == "01" || (selStatus == "02" && orderStatus == "O") || (selStatus == "03" && orderStatus == "C"))
{
dtWebO.Rows.Add(1);
dtWebO.SetValue("Id", i, (i + 1).ToString());
dtWebO.SetValue("WebNum", i, dr["DocNum"].ToString());
dtWebO.SetValue("RdrNum", i, pchEntry);
dtWebO.SetValue("RdrDT", i, dr["DocDate"].ToString());
i++;
}
}
mtWO.LoadFromDataSource();
oForm.Freeze(false);
lblStatus.Caption = "";
updateRetMatrix();
}
private void fillJeDetailHead(string docNum, int RowNum)
{
txDS.Value = "0.00";
txCS.Value = "0.00";
txDD.Value = "";
txDN.Value = "";
txRem.Value = "";
txRef1.Value = "";
txRef2.Value = "";
txPJ.Value = "";
txCJ.Value = "";
dtDet.Rows.Clear();
string jeType = "PP";
if (optPP.Selected)
{
jeType = "PP";
}
if (optPC.Selected)
{
jeType = "PC";
}
if (optC.Selected)
{
jeType = "C";
}
try
{
if (jeType == "C")
{
btPost.Item.Enabled = false;
}
else
{
btPost.Item.Enabled = true;
}
}
catch { }
if (RowNum > 0)
{
txRem.Value = Convert.ToString(dtHead.GetValue("cRemarks", RowNum - 1));
txRef1.Value = Convert.ToString(dtHead.GetValue("cNum", RowNum - 1));
txPJ.Value = Convert.ToString(dtHead.GetValue("cPostedJE", RowNum - 1));
txCJ.Value = Convert.ToString(dtHead.GetValue("cCanceledJE", RowNum - 1));
oForm.DataSources.UserDataSources.Item("txDD").ValueEx = Convert.ToDateTime(dtHead.GetValue("cDate", RowNum - 1)).ToString("yyyyMMdd");
}
chkPost.Checked = false;
dtPendingJEs.Rows.Clear();
DataServices ds = new DataServices(Program.strConMena);
string strSelect = " Select MenaCode as lineType ,acctCode,acctName,debit ,credit , project ,ocr1 ,ocr2 ,ocr3 ,ocr4 ,ocr5 from [dbo].[JE_PRL_getJEDetRows]('" + docNum + "') ";
dtDet.Rows.Clear();
System.Data.DataTable dtRows = ds.getDataTable(strSelect, "Filling Detail");
if (dtRows != null && dtRows.Rows.Count > 0)
{
int i = 0;
double debit = 0.00;
double credit = 0.00;
foreach (DataRow dr in dtRows.Rows)
{
double lineDebit = 0.00;
double lineCredit = 0.00;
lineDebit = Convert.ToDouble(dr["debit"].ToString());
lineCredit = Convert.ToDouble(dr["credit"].ToString());
debit += lineDebit;
credit += lineCredit;
dtDet.Rows.Add(1);
dtDet.SetValue("cNum", i, i.ToString());
dtDet.SetValue("cType", i, Convert.ToString(dr["lineType"].ToString()));
dtDet.SetValue("cCode", i, Convert.ToString(Program.objHrmsUI.getAcctSys(dr["lineType"].ToString().Replace("-", ""))));
dtDet.SetValue("cName", i, Convert.ToString(Program.objHrmsUI.getAcctName(dr["lineType"].ToString().Replace("-", ""))));
dtDet.SetValue("cDebit", i, Convert.ToString(dr["debit"].ToString()));
dtDet.SetValue("cCredit", i, Convert.ToString(dr["credit"].ToString()));
dtDet.SetValue("cProject", i, Convert.ToString(dr["project"].ToString()));
dtDet.SetValue("cOcr1", i, Convert.ToString(dr["ocr1"].ToString()));
dtDet.SetValue("cOcr2", i, Convert.ToString(dr["ocr2"].ToString()));
dtDet.SetValue("cOcr3", i, Convert.ToString(dr["ocr3"].ToString()));
dtDet.SetValue("cOcr4", i, Convert.ToString(dr["ocr4"].ToString()));
dtDet.SetValue("cOcr5", i, Convert.ToString(dr["ocr5"].ToString()));
i++;
}
mtDet.LoadFromDataSource();
txDS.Value = debit.ToString();
txCS.Value = credit.ToString();
}
mtDet.LoadFromDataSource();
}
}//fin InitForm
public new void FormEvent(String FormUID, ref SAPbouiCOM.ItemEvent pVal, ref Boolean BubbleEvent)
{
SAPbouiCOM.DataTable oDataTable;
SAPbouiCOM.IChooseFromListEvent oCFLEvento = null;
String sValue;
String sValue2;
base.FormEvent(FormUID, ref pVal, ref BubbleEvent);
try
{
if ((pVal.ItemUID == "1") && (pVal.BeforeAction) && (pVal.EventType == BoEventTypes.et_ITEM_PRESSED))
{
if ((oForm.Mode == BoFormMode.fm_ADD_MODE) || (oForm.Mode == BoFormMode.fm_UPDATE_MODE))
{
BubbleEvent = false;
if (ValidarDatos())
{
GuardarDatos();
}
}
}
if ((pVal.EventType == BoEventTypes.et_CHOOSE_FROM_LIST) && (!pVal.BeforeAction))
{
oForm.Freeze(true);
if (pVal.ColUID == "U_CtaSAP")
{
oCFLEvento = (SAPbouiCOM.IChooseFromListEvent)(pVal);
oDataTable = oCFLEvento.SelectedObjects;
if (oDataTable != null)
{
sValue = ((System.String)oDataTable.GetValue("FormatCode", 0)).Trim();
sValue2 = ((System.String)oDataTable.GetValue("AcctName", 0)).Trim();
if (ValidarDataTable(sValue))
{
odt.SetValue("U_CtaSAP", pVal.Row, sValue);
odt.SetValue("U_DescSAP", pVal.Row, sValue2);
if ((odt.Rows.Count - 1 == pVal.Row) && (sValue != ""))
{
odt.Rows.Add(1);
}
oGrid.AutoResizeColumns();
if (oForm.Mode == BoFormMode.fm_OK_MODE)
{
oForm.Mode = BoFormMode.fm_UPDATE_MODE;
}
}
}
}
}
}
catch (Exception e)
{
if (FCmpny.InTransaction)
{
FCmpny.EndTransaction(BoWfTransOpt.wf_RollBack);
}
FSBOApp.StatusBar.SetText(e.Message + " ** Trace: " + e.StackTrace, BoMessageTime.bmt_Short, BoStatusBarMessageType.smt_Error);
OutLog("FormEvent: " + e.Message + " ** Trace: " + e.StackTrace);
}
finally
{
oForm.Freeze(false);
}
}//fin FormEvent
}//fin InitForm
public new void FormEvent(String FormUID, ref SAPbouiCOM.ItemEvent pVal, ref Boolean BubbleEvent)
{
SAPbouiCOM.DataTable oDataTable;
SAPbouiCOM.IChooseFromListEvent oCFLEvento = null;
String sValue;
String sValue2;
base.FormEvent(FormUID, ref pVal, ref BubbleEvent);
try
{
if (pVal.EventType == BoEventTypes.et_ITEM_PRESSED)
{
if (pVal.BeforeAction == true)
{
if (((oForm.Mode == BoFormMode.fm_ADD_MODE) || (oForm.Mode == BoFormMode.fm_UPDATE_MODE)) && (pVal.ItemUID == "1"))
{
BubbleEvent = false;
if (Validar())
{
Guardar_Registros();
}
}
}
if ((pVal.BeforeAction == false) && (pVal.ItemUID == "btn_Borrar"))
{
BorrarLinea();
}
}
if ((pVal.EventType == BoEventTypes.et_CHOOSE_FROM_LIST) && (!pVal.BeforeAction))
{
oForm.Freeze(true);
if (pVal.ColUID == "U_CardCode")
{
oCFLEvento = (SAPbouiCOM.IChooseFromListEvent)(pVal);
oDataTable = oCFLEvento.SelectedObjects;
if (oDataTable != null)
{
sValue = ((System.String)oDataTable.GetValue("CardCode", 0)).Trim();
sValue2 = ((System.String)oDataTable.GetValue("CardName", 0)).Trim();
for (Int32 iCont_1 = 0; iCont_1 < odt.Rows.Count; iCont_1++)
{
if (((System.String)odt.GetValue("U_CardCode", iCont_1)).Length > 0)
{
var CardCode = ((System.String)odt.GetValue("U_CardCode", iCont_1));
if (CardCode == sValue)
{
FSBOApp.StatusBar.SetText("Proveedor ya se encuentra en la lista Negra", BoMessageTime.bmt_Short, BoStatusBarMessageType.smt_Warning);
return;
}
}
}
if (GlobalSettings.RunningUnderSQLServer)
{
s = @"SELECT COUNT(*) 'count' FROM [@VID_FELISTABL] WHERE U_CardCode = '{0}'";
}
else
{
s = @"SELECT COUNT(*) ""count"" FROM ""@VID_FELISTABL"" WHERE ""U_CardCode"" = '{0}'";
}
s = String.Format(s, sValue);
oRecordSet.DoQuery(s);
if (((System.Int32)oRecordSet.Fields.Item("count").Value) > 0)
{
FSBOApp.StatusBar.SetText("Codigo Proveedor se encuentra en la lista blanca, no se puede seleccionar -> Codigo " + sValue, BoMessageTime.bmt_Short, BoStatusBarMessageType.smt_Warning);
return;
}
odt.SetValue("U_CardCode", pVal.Row, sValue);
odt.SetValue("U_CardName", pVal.Row, sValue2);
odt.SetValue("U_Activado", pVal.Row, "Y");
if ((odt.Rows.Count - 1 == pVal.Row) && (sValue != ""))
{
odt.Rows.Add(1);
}
ogrid.AutoResizeColumns();
if (oForm.Mode == BoFormMode.fm_OK_MODE)
{
oForm.Mode = BoFormMode.fm_UPDATE_MODE;
}
}
}
}
}
catch (Exception e)
{
if (FCmpny.InTransaction)
{
FCmpny.EndTransaction(BoWfTransOpt.wf_RollBack);
}
FSBOApp.StatusBar.SetText(e.Message + " ** Trace: " + e.StackTrace, BoMessageTime.bmt_Short, BoStatusBarMessageType.smt_Error);
OutLog("FormEvent: " + e.Message + " ** Trace: " + e.StackTrace);
}
finally
{
if (oForm != null)
{
oForm.Freeze(false);
}
}
}//fin FormEvent
private void getDocs()
{
string strWhs = "";
foreach (string whs in userWhs)
{
if (strWhs == "")
{
strWhs = "'" + whs + "'";
}
else
{
strWhs += " ,'" + whs + "'";
}
}
string strOT = "";
foreach (string ot in userOT)
{
if (strOT == "")
{
strOT = "'" + ot + "'";
}
else
{
strOT += " ,'" + ot + "'";
}
}
if (strOT == "" || strWhs == "")
{
return;
}
string strDocs = " SELECT t0.\"Comments\" , t0.\"TransType\", t0.BASE_REF,t0.\"CreatedBy\", t1.\"Name\" , t1.\"U_TblScm\" FROM OINM t0 INNER JOIN \"@B1_QA_OBJS\" t1 ON t0.\"TransType\" = CAST(t1.\"Code\" AS integer) ";
strDocs += " WHERE t0.\"InQty\" > 0 AND t0.\"Warehouse\" IN (" + strWhs + ") AND t0.\"TransType\" IN (" + strOT + ") " +
" AND NOT EXISTS (SELECT tObj.\"U_ObjType\" FROM \"@B1_QA_DOC\" tObj WHERE tObj.\"U_Final\" = 'Y' AND tObj.\"U_ObjType\" = t0.\"TransType\" AND tObj.\"U_DocEntry\" = t0.\"CreatedBy\" ) " +
"GROUP BY t0.\"TransType\", t0.BASE_REF,t0.\"CreatedBy\", t1.\"Name\", t1.\"U_TblScm\" ,t0.\"Comments\" ";
System.Data.DataTable dtdocs = Program.objHrmsUI.getDataTable(strDocs, "getting docs");
int i = 0;
dtDoc.Rows.Clear();
foreach (System.Data.DataRow dr in dtdocs.Rows)
{
string DocType = dr["Name"].ToString();
string transType = dr["TransType"].ToString();
if (transType == "59")
{
string DE = dr["CreatedBy"].ToString();
string strProdNum = "SELECT \"U_B1_QA_INSP_PN\" FROM \"OIGN\" WHERE \"DocEntry\" ='" + DE + "'";
System.Data.DataTable dtProdNum = Program.objHrmsUI.getDataTable(strProdNum, "ProdNum");
if (dtProdNum != null && dtProdNum.Rows.Count > 0)
{
if (dtProdNum.Rows[0]["U_B1_QA_INSP_PN"] != DBNull.Value && Convert.ToInt32(dtProdNum.Rows[0]["U_B1_QA_INSP_PN"]) > 0)
{
DocType = "Offer for Inspection";
}
}
}
i++;
dtDoc.Rows.Add(1);
dtDoc.SetValue("Id", i - 1, i.ToString());
dtDoc.SetValue("DE", i - 1, dr["CreatedBy"].ToString());
dtDoc.SetValue("DN", i - 1, dr["BASE_REF"].ToString());
dtDoc.SetValue("DT", i - 1, DocType);
dtDoc.SetValue("Tbl", i - 1, dr["U_TblScm"].ToString());
dtDoc.SetValue("OT", i - 1, dr["TransType"].ToString());
}
mtDocs.LoadFromDataSource();
}
private void fillJeDetailHead(string docNum)
{
txDS.Value = "0.00";
txCS.Value = "0.00";
chkPost.Checked = false;
Hashtable hp = new Hashtable();
hp.Add("~p1", docNum);
string strSelect = Program.objHrmsUI.getQryString("JE_getJEDetHead", hp);
dtPendingJEs.Rows.Clear();
System.Data.DataTable dtJeHead = Program.objHrmsUI.getDataTable(strSelect, "Filling All Jes");
if (dtJeHead != null && dtJeHead.Rows.Count > 0)
{
foreach (DataRow dr in dtJeHead.Rows)
{
oForm.DataSources.UserDataSources.Item("txDD").ValueEx = Convert.ToDateTime(dr["docDate"]).ToString("yyyyMMdd");
txDN.Value = dr["docNum"].ToString();
txRem.Value = dr["Remarks"].ToString();
txRef1.Value = dr["Ref1"].ToString();
txRef2.Value = dr["Ref2"].ToString();
}
}
strSelect = @"SELECT case when ( t0.U_DAccCode in (select cardcode from ocrd)) then 'BP' else 'GL' end lineType,
case when (t0.U_DAccCode in (select cardcode from ocrd)) then U_DAccCode else
(select acctcode from oact where replace( t0.U_DAccCode,'-','') = oact.FormatCode ) end acctCode
, t0.U_DAccName, t0.U_DebitAmt debit ,0 credit
, t0.U_Project project ,t0.U_ProfitCode ocr1 , t0.U_OcrCode2 ocr2 , t0.U_OcrCode3 ocr3 , t0.U_OcrCode4 ocr4 , t0.U_OcrCode5 ocr5
FROM dbo.[@ABGP] t0
where t0.DocNum = '~p1'" ;
strSelect = Program.objHrmsUI.getQryString("JE_getJEDetRows_D", hp);
double debit = 0.00;
double credit = 0.00;
dtDet.Rows.Clear();
System.Data.DataTable dtRows = Program.objHrmsUI.getDataTable(strSelect, "Filling Detail");
if (dtRows != null && dtRows.Rows.Count > 0)
{
int i = 0;
foreach (DataRow dr in dtRows.Rows)
{
double lineDebit = 0.00;
double lineCredit = 0.00;
lineDebit = Convert.ToDouble(dr["debit"].ToString());
lineCredit = Convert.ToDouble(dr["credit"].ToString());
debit += lineDebit;
credit += lineCredit;
dtDet.Rows.Add(1);
dtDet.SetValue("cNum", i, i.ToString());
dtDet.SetValue("cType", i, Convert.ToString(dr["lineType"].ToString()));
dtDet.SetValue("cCode", i, Convert.ToString(dr["acctCode"].ToString()));
dtDet.SetValue("cName", i, Convert.ToString(dr["acctName"].ToString()));
dtDet.SetValue("cDebit", i, Convert.ToString(dr["debit"].ToString()));
dtDet.SetValue("cCredit", i, Convert.ToString(dr["credit"].ToString()));
dtDet.SetValue("cProject", i, Convert.ToString(dr["project"].ToString()));
dtDet.SetValue("cOcr1", i, Convert.ToString(dr["ocr1"].ToString()));
dtDet.SetValue("cOcr2", i, Convert.ToString(dr["ocr2"].ToString()));
dtDet.SetValue("cOcr3", i, Convert.ToString(dr["ocr3"].ToString()));
dtDet.SetValue("cOcr4", i, Convert.ToString(dr["ocr4"].ToString()));
dtDet.SetValue("cOcr5", i, Convert.ToString(dr["ocr5"].ToString()));
i++;
}
}
strSelect = Program.objHrmsUI.getQryString("JE_getJEDetRows_C", hp);
dtRows = Program.objHrmsUI.getDataTable(strSelect, "Filling Detail");
if (dtRows != null && dtRows.Rows.Count > 0)
{
int i = 1;
foreach (DataRow dr in dtRows.Rows)
{
double lineDebit = 0.00;
double lineCredit = 0.00;
lineDebit = Convert.ToDouble(dr["debit"].ToString());
lineCredit = Convert.ToDouble(dr["credit"].ToString());
debit += lineDebit;
credit += lineCredit;
dtDet.Rows.Add(1);
dtDet.SetValue("cNum", i, i.ToString());
dtDet.SetValue("cType", i, Convert.ToString(dr["lineType"].ToString()));
dtDet.SetValue("cCode", i, Convert.ToString(dr["acctCode"].ToString()));
dtDet.SetValue("cName", i, Convert.ToString(dr["acctName"].ToString()));
dtDet.SetValue("cDebit", i, Convert.ToString(dr["debit"].ToString()));
dtDet.SetValue("cCredit", i, Convert.ToString(dr["credit"].ToString()));
dtDet.SetValue("cProject", i, Convert.ToString(dr["project"].ToString()));
dtDet.SetValue("cOcr1", i, Convert.ToString(dr["ocr1"].ToString()));
dtDet.SetValue("cOcr2", i, Convert.ToString(dr["ocr2"].ToString()));
dtDet.SetValue("cOcr3", i, Convert.ToString(dr["ocr3"].ToString()));
dtDet.SetValue("cOcr4", i, Convert.ToString(dr["ocr4"].ToString()));
dtDet.SetValue("cOcr5", i, Convert.ToString(dr["ocr5"].ToString()));
i++;
}
}
mtDet.LoadFromDataSource();
txDS.Value = debit.ToString();
txCS.Value = credit.ToString();
}
protected virtual void e_FormLoad(ref SAPbouiCOM.ItemEvent pVal, ref bool BubbleEvent)
{
try
{
if (pVal.BeforeAction == false && bLoadInputEvents)
{
oform = oApplication.Forms.Item(pVal.FormUID);
oform.ClientWidth = 450;
oform.ClientHeight = 400;
dtSearch = oform.DataSources.DataTables.Add("dtSearch");
// oform.Width = 600;
oform.Title = sTitle;
oform.State = BoFormStateEnum.fs_Maximized;
SAPbouiCOM.Item oItem;
IbtChoos = oform.Items.Item("1");
IbtChoos.Top = 350;
btChoos = (SAPbouiCOM.Button)IbtChoos.Specific;
btChoos.Caption = "Choose";
ISearchField = oform.Items.Item("2");
ISearchField.Top = 350;
SAPbouiCOM.Columns oColumns;
SAPbouiCOM.DataColumns dtCols;
dtCols = dtSearch.Columns;
SAPbouiCOM.Column oColumn;
SAPbouiCOM.DataColumn dtCol;
oItem = oform.Items.Add("mtSearch", BoFormItemTypes.it_MATRIX);
oItem.Width = 440;
oItem.Height = 290;
oItem.Top = 60;
oItem.Enabled = true;
mtSearch = (SAPbouiCOM.Matrix)oItem.Specific;
// mtSearch.
oItem = oform.Items.Add("lbCritaria", BoFormItemTypes.it_STATIC);
oItem.Top = 40;
oItem.Left = 10;
SAPbouiCOM.StaticText lblCri = (SAPbouiCOM.StaticText)oItem.Specific;
lblCri.Caption = "Find";
oItem = oform.Items.Add("txCritaria", BoFormItemTypes.it_EDIT);
oItem.Top = 40;
oItem.Width = 300;
oItem.Left = 130;
//SAPbouiCOM.StaticText lblCri = oItem.Specific;
if (flgMultiple)
{
}
else
{
mtSearch.SelectionMode = BoMatrixSelect.ms_Single;
}
// mtSearch
oColumns = mtSearch.Columns;
//mtSearch.Layout = BoMatrixLayoutType.mlt_Vertical;
oColumn = oColumns.Add("vFix", SAPbouiCOM.BoFormItemTypes.it_EDIT);
// oColumn.Editable = false;
oColumn.Width = 40;
//oColumn.Visible = false;
int i = 0;
int j = 0;
foreach (System.Data.DataColumn cl in dtTable.Columns)
{
dtOut.Columns.Add(cl.ColumnName);
oColumn = oColumns.Add("v_" + i.ToString(), SAPbouiCOM.BoFormItemTypes.it_EDIT);
oColumn.TitleObject.Caption = cl.Caption;
oColumn.Width = 100;
oColumn.Editable = false;
dtCol = dtCols.Add("cd" + i.ToString(), BoFieldsType.ft_AlphaNumeric);
oColumn.DataBind.Bind("dtSearch", "cd" + i.ToString());
// oColumn.
i++;
// col.DataBind.TableName = "dtSearch";
//col.DataBind
}
dtSearch.Rows.Clear();
i = 0;
j = 0;
foreach (DataRow dr in dtTable.Rows)
{
dtSearch.Rows.Add(1);
j = 0;
foreach (System.Data.DataColumn col in dtTable.Columns)
{
dtSearch.SetValue("cd" + j.ToString(), i, dr[j].ToString());
j++;
}
i++;
}
mtSearch.LoadFromDataSource();
oform = null;
}
}
catch (Exception ex)
{
bLoadInputEvents = false;
}
}
private void InitiallizeForm()
{
oForm.Freeze(true);
// Program.objHrmsUI.ExecQuery("Update B1_SCHMDT set u_upd='Y' where isnull(u_upd,'N') = 'N'", "Finalizing temp");
Program.objHrmsUI.ExecQuery("delete from [@B1_SCHMDT] where isnull(u_upd,'N') = 'N'", "Finalizing temp");
Program.objHrmsUI.ExecQuery("delete from [@B1_SCHMDY] where isnull(u_upd,'N') = 'N'", "Finalizing temp");
Program.objHrmsUI.ExecQuery("delete from [@B1_SO] where isnull(u_upd,'N') = 'N'", "Finalizing temp");
Program.objHrmsUI.ExecQuery("delete from [@B1_SCHOT] where isnull(u_upd,'N') = 'N'", "Finalizing temp");
cardCFL = (SAPbouiCOM.ChooseFromList)oForm.ChooseFromLists.Item("cflCRD");
SAPbouiCOM.Conditions oCons = cardCFL.GetConditions();
SAPbouiCOM.Condition oCon = oCons.Add();
oCon.Alias = "CardType";
oCon.Operation = SAPbouiCOM.BoConditionOperation.co_EQUAL;
oCon.CondVal = "C";
cardCFL.SetConditions(oCons);
dtHead = oForm.DataSources.DataTables.Item("dtHead");
dtItem = oForm.DataSources.DataTables.Item("dtItem");
dtDate = oForm.DataSources.DataTables.Item("dtDate");
dtDays = oForm.DataSources.DataTables.Item("dtDays");
dtOSCN = oForm.DataSources.DataTables.Item("dtOSCN");
dtOT = oForm.DataSources.DataTables.Item("dtOT");
mtItem = (SAPbouiCOM.Matrix)oForm.Items.Item("mtItem").Specific;
mtDate = (SAPbouiCOM.Matrix)oForm.Items.Item("mtDate").Specific;
mtDay = (SAPbouiCOM.Matrix)oForm.Items.Item("mtDays").Specific;
mtOSCN = (SAPbouiCOM.Matrix)oForm.Items.Item("mtOSCN").Specific;
mtOT = (SAPbouiCOM.Matrix)oForm.Items.Item("mtOT").Specific;
dtHead.Rows.Add(1);
dtHead.SetValue("tsActive", 0, "Y");
txCode = (SAPbouiCOM.EditText)oForm.Items.Item("txCode").Specific;
txName = (SAPbouiCOM.EditText)oForm.Items.Item("txName").Specific;
txCT = (SAPbouiCOM.EditText)oForm.Items.Item("txCT").Specific;
txOTDT = (SAPbouiCOM.EditText)oForm.Items.Item("txOTDT").Specific;
txICode = (SAPbouiCOM.EditText)oForm.Items.Item("txICode").Specific;
txOMDT = (SAPbouiCOM.EditText)oForm.Items.Item("txOMDT").Specific;
txOICODE = (SAPbouiCOM.EditText)oForm.Items.Item("txOICODE").Specific;
imgImage = (SAPbouiCOM.PictureBox)oForm.Items.Item("imgImage").Specific;
txSL = (SAPbouiCOM.EditText)oForm.Items.Item("txSL").Specific;
cbSP = (SAPbouiCOM.ComboBox)oForm.Items.Item("cbSP").Specific;
cbDays = (SAPbouiCOM.ComboBox)oForm.Items.Item("cbDays").Specific;
cbWeeks = (SAPbouiCOM.ComboBox)oForm.Items.Item("cbWeeks").Specific;
cbHH = (SAPbouiCOM.ComboBox)oForm.Items.Item("cbHH").Specific;
cbMM = (SAPbouiCOM.ComboBox)oForm.Items.Item("cbMM").Specific;
cbAP = (SAPbouiCOM.ComboBox)oForm.Items.Item("cbAP").Specific;
cbEWN = (SAPbouiCOM.ComboBox)oForm.Items.Item("cbEWN").Specific;
cbOTHH = (SAPbouiCOM.ComboBox)oForm.Items.Item("cbOTHH").Specific;
cbOTMM = (SAPbouiCOM.ComboBox)oForm.Items.Item("cbOTMM").Specific;
cbOTAP = (SAPbouiCOM.ComboBox)oForm.Items.Item("cbOTAP").Specific;
opOD = (SAPbouiCOM.OptionBtn)oForm.Items.Item("opOD").Specific;
opOW = (SAPbouiCOM.OptionBtn)oForm.Items.Item("opOW").Specific;
opOM = (SAPbouiCOM.OptionBtn)oForm.Items.Item("opOM").Specific;
OMDY = (SAPbouiCOM.OptionBtn)oForm.Items.Item("OMDY").Specific;
OMDT = (SAPbouiCOM.OptionBtn)oForm.Items.Item("OMDT").Specific;
opOW.GroupWith("opOD");
opOM.GroupWith("opOD");
OMDY.GroupWith("OMDT");
opOD.Selected = true;
OMDT.Selected = true;
tbSO = (SAPbouiCOM.Folder)oForm.Items.Item("tbSO").Specific;
tbTS = (SAPbouiCOM.Folder)oForm.Items.Item("tbTS").Specific;
tbTS.Select();
fillCBs();
oForm.Freeze(false);
txCode.Active = true;
}
private void addWebOrder(string incrementId, Mag.MagentoService svc)
{
string mLogin = "";
svc.PreAuthenticate = true;
Program.LoginToMagento(out mLogin, out svc);
Mag.salesOrderPaymentEntity pmt = new Mag.salesOrderPaymentEntity();
Mag.shoppingCartPaymentEntity scpmt = new Mag.shoppingCartPaymentEntity();
Mag.salesOrderEntity soe = new Mag.salesOrderEntity();
Mag.shoppingCartInfoEntity cart = new Mag.shoppingCartInfoEntity();
Mag.shoppingCartPaymentMethodEntity pmtmethod = new Mag.shoppingCartPaymentMethodEntity();
soe = svc.salesOrderInfo(mLogin, incrementId);
cart = svc.shoppingCartInfo(mLogin, Convert.ToInt32(soe.quote_id), soe.store_id);
pmt = soe.payment;
string WebID = soe.increment_id;
DateTime utcDate = Convert.ToDateTime(soe.created_at);
utcDate = DateTime.SpecifyKind(utcDate, DateTimeKind.Utc);
DateTime localDT = utcDate.ToLocalTime();
string OrderDate = localDT.ToString();
string CCode = "";
if (cart.customer_id != null)
{
CCode = cart.customer_id;
}
else
{
CCode = soe.customer_id;
}
string CTel1 = soe.shipping_address.telephone;
string CMail = soe.customer_email;
string Contact = soe.customer_firstname + " " + soe.customer_lastname;
string CNTel = soe.billing_address.telephone;
string CNEmail = soe.customer_email;
string bName = soe.billing_address.firstname + " " + soe.billing_address.lastname;
string bStreet = soe.billing_address.street;
string bCity = soe.billing_address.city;
string bState = soe.billing_address.region;
string bZipCode = soe.billing_address.postcode;
string bPhone = soe.billing_address.telephone == null ? "" : soe.billing_address.telephone;
string bEmail = soe.customer_email;
string sName = soe.shipping_address.firstname + " " + soe.shipping_address.lastname;
string sStreet = soe.shipping_address.street;
string sCity = soe.shipping_address.city;
string sState = soe.shipping_address.region;
string sPhone = soe.shipping_address.telephone == null ? "" : soe.shipping_address.telephone;
string sZipCode = soe.shipping_address.postcode;
string sEmail = soe.customer_email;
string shipcharge = "Ship Charge";
string sCompany = soe.shipping_address.company == null ? "" : soe.shipping_address.company;
dtCard.Rows.Clear();
dtCard.Rows.Add(1);
if (CCode == null)
{
CCode = "99999999";
}
CCode = "W-" + CCode.PadLeft(8, '0');
dtCard.SetValue("BName", 0, bName);
dtCard.SetValue("BStPO", 0, bStreet);
string[] streetArr = bStreet.Split('\n');
string addr1B = "";
string addr2B = "";
if (streetArr.Length > 0)
{
addr1B = streetArr[0].ToString();
}
if (streetArr.Length > 1)
{
addr2B = streetArr[1].ToString();
}
dtCard.SetValue("BAdd1", 0, addr1B);
dtCard.SetValue("BAdd2", 0, addr2B);
//dtCard.SetValue("BCompany", 0, soe.com);
dtCard.SetValue("BCity", 0, bCity);
dtCard.SetValue("BState", 0, bState);
dtCard.SetValue("BZip", 0, bZipCode);
dtCard.SetValue("BTel", 0, bPhone);
dtCard.SetValue("BEmail", 0, bEmail);
dtCard.SetValue("SName", 0, sName);
dtCard.SetValue("SStPO", 0, sStreet);
streetArr = sStreet.Split('\n');
string addr1S = "";
string addr2S = "";
if (streetArr.Length > 0)
{
addr1S = streetArr[0].ToString();
}
if (streetArr.Length > 1)
{
addr2S = streetArr[1].ToString();
}
dtCard.SetValue("SAdd1", 0, addr1S);
dtCard.SetValue("SAdd2", 0, addr2S);
dtCard.SetValue("SCity", 0, sCity);
dtCard.SetValue("SZip", 0, sZipCode);
dtCard.SetValue("STel", 0, sPhone);
dtCard.SetValue("SEmail", 0, sEmail);
dtCard.SetValue("SState", 0, sState);
dtCard.SetValue("SComp", 0, sCompany);
Mag.shoppingCartPaymentEntity cpmt = new Mag.shoppingCartPaymentEntity();
cpmt = cart.payment;
string numAtCard = soe.increment_id;
string DiscCode = cart.coupon_code == null ? "" : cart.coupon_code;
string BillingZip = soe.billing_address.postcode;
string ordrsource = "W";
string CCName = cart.payment.cc_owner == null ? "" : cart.payment.cc_owner;; // soe.payment.cc_owner;
string l4Digit = cart.payment.cc_last4 == null ? "" : cart.payment.cc_last4;
string AuthNet = cart.payment.cc_ss_issue == null ? "" : cart.payment.cc_ss_issue;
string ChargeAmount = soe.payment.amount_ordered;
string MagentoId = soe.master_order_id;
string TransDate = localDT.ToString();
string WebOrderAt = localDT.ToString();
string WebDiscP = cart.items[0].discount_percent.ToString();
string WebDiscAmonut = soe.discount_amount;
string CardExp = cart.payment.cc_exp_month + "/1/" + cart.payment.cc_exp_year;
string CardType = cart.payment.cc_type;
DateTime expDate = Convert.ToDateTime(CardExp);
expDate = expDate.AddMonths(1).AddDays(-1);
string slpCode = "Websales";
dtORDR.Rows.Clear();
dtORDR.Rows.Add(1);
dtORDR.SetValue("CreateDate", 0, Convert.ToDateTime(TransDate).ToString("yyyyMMdd"));
try
{
dtORDR.SetValue("ShipDate", 0, Convert.ToDateTime(soe.ship_date));
}
catch { dtORDR.SetValue("ShipDate", 0, Convert.ToDateTime(DateTime.Now.AddDays(1))); }
try
{
dtORDR.SetValue("DelDate", 0, Convert.ToDateTime(soe.delivery_date));
}
catch { dtORDR.SetValue("DelDate", 0, Convert.ToDateTime(DateTime.Now.Date.AddDays(1))); }
dtORDR.SetValue("ShipDescr", 0, soe.shipping_description);
dtORDR.SetValue("ShipAmount", 0, soe.shipping_amount);
dtORDR.SetValue("CustFName", 0, soe.customer_firstname);
dtORDR.SetValue("CustLName", 0, soe.customer_lastname);
dtORDR.SetValue("CustEmail", 0, soe.customer_email);
dtORDR.SetValue("isGuest", 0, soe.customer_is_guest);
dtORDR.SetValue("CustGroup", 0, soe.customer_group_id);
dtORDR.SetValue("Store", 0, soe.store_id);
dtHead.SetValue("ProdType", 0, soe.items[0].product_type);
dtHead.SetValue("ProdOpt", 0, soe.items[0].product_options);
DateTime shipDate = DateTime.Now.AddDays(1);
DateTime DeliveryDate = DateTime.Now.AddDays(1);
try { shipDate = Convert.ToDateTime(soe.ship_date); } catch { }
try { DeliveryDate = Convert.ToDateTime(soe.delivery_date); } catch { }
string statuscomment = "";
string authTransId = "";
if (cart.payment.method == "authorizenet")
{
foreach (Mag.salesOrderStatusHistoryEntity status in soe.status_history)
{
if (status.comment == null)
{
continue;
}
if (status.comment.Contains("Authorize.Net Transaction ID"))
{
statuscomment = status.comment;
}
}
int start = statuscomment.IndexOf('"');
statuscomment = statuscomment.Substring(start + 1);
int len = statuscomment.IndexOf('"');
authTransId = statuscomment.Substring(0, len);
}
CCName = cart.payment.cc_ss_owner; // soe.payment.cc_owner;
l4Digit = cart.payment.cc_last4;
string strInsert = @"INSERT INTO [@B1_MORDR]
([Code]
,[Name]
,[U_CardCode]
,[U_Tel1]
,[U_Email]
,[U_Contact]
,[U_CNPhone]
,[U_CNEmail]
,[U_BName]
,[U_BStreet]
,[U_BCity]
,[U_BState]
,[U_BZip]
,[U_BPhone]
,[U_BEmail]
,[U_SName]
,[U_SStreet]
,[U_SCity]
,[U_SState]
,[U_SZip]
,[U_SPhone]
,[U_SEmail]
,[U_WEBID]
,[U_NumAtCard]
,[U_DiscCode]
,[U_CCName]
,[U_L4Dig]
,[U_AuthNetId]
,[U_CCAmnt]
,[U_MagentoID]
,[U_CCTDate]
,[U_CCExpDate]
,[U_CCType]
,[U_CCZip]
,[U_WODate]
,[U_WODiscP]
,[U_WODiscA]
,[U_DPMCreated]
,[U_WOSource]
,[U_Printed]
,[U_SlpCode]
,[U_SComp])
VALUES
(@Code
,@Name
,@U_CardCode
,@U_Tel1
,@U_Email
,@U_Contact
,@U_CNPhone
,@U_CNEmail
,@U_BName
,@U_BStreet
,@U_BCity
,@U_BState
,@U_BZip
,@U_BPhone
,@U_BEmail
,@U_SName
,@U_SStreet
,@U_SCity
,@U_SState
,@U_SZip
,@U_SPhone
,@U_SEmail
,@U_WEBID
,@U_NumAtCard
,@U_DiscCode
,@U_CCName
,@U_L4Dig
,@U_AuthNetId
,@U_CCAmnt
,@U_MagentoID
,@U_CCTDate
,@U_CCExpDate
,@U_CCType
,@U_CCZip
,@U_WODate
,@U_WODiscP
,@U_WODiscA
,@U_DPMCreated
,@U_WOSource
,@U_Printed
,@U_SlpCode
,@U_SComp )";
Hashtable hsp = new Hashtable();
hsp.Add("@Code", incrementId);
hsp.Add("@Name", incrementId);
hsp.Add("@U_CardCode", CCode);
hsp.Add("@U_Tel1", CTel1 == null ? "" : CTel1);
hsp.Add("@U_Email", CMail == null ? "" : CMail);
hsp.Add("@U_Contact", Contact);
hsp.Add("@U_CNPhone", CNTel == null ? "" : CNTel);
hsp.Add("@U_CNEmail", CNEmail == null ? "" : CNEmail);
hsp.Add("@U_BName", bName == null ? "" : bName);
hsp.Add("@U_BStreet", bStreet == null ? "" : bStreet);
hsp.Add("@U_BCity", bCity == null ? "" : bCity);
hsp.Add("@U_BState", bState == null ? "" : bState);
hsp.Add("@U_BZip", bZipCode == null ? "" : bZipCode);
hsp.Add("@U_BPhone", bPhone == null ? "" : bPhone);
hsp.Add("@U_BEmail", bEmail == null ? "" : bEmail);
hsp.Add("@U_SName", sName == null ? "" : sName);
hsp.Add("@U_SStreet", sStreet == null ? "" : sStreet);
hsp.Add("@U_SCity", sCity == null ? "" : sCity);
hsp.Add("@U_SState", sState == null ? "" : sState);
hsp.Add("@U_SZip", sZipCode == null ? "" : sZipCode);
hsp.Add("@U_SPhone", sPhone == null ? "" : sPhone);
hsp.Add("@U_SEmail", sEmail == null ? "" : sEmail);
hsp.Add("@U_WEBID", incrementId);
hsp.Add("@U_NumAtCard", incrementId);
hsp.Add("@U_DiscCode", DiscCode == null ? "" : DiscCode);
hsp.Add("@U_CCName", bName == null ? "" : bName);
hsp.Add("@U_L4Dig", l4Digit == null ? "" : l4Digit);
hsp.Add("@U_AuthNetId", authTransId == null ? "" : authTransId);
hsp.Add("@U_CCAmnt", ChargeAmount);
hsp.Add("@U_MagentoID", soe.master_order_id == null ? "" : soe.master_order_id);
hsp.Add("@U_CCTDate", Convert.ToDateTime(TransDate).ToShortDateString());
hsp.Add("@U_CCExpDate", expDate.Date.ToShortDateString());
hsp.Add("@U_CCType", CardType == null ? "" : CardType);
hsp.Add("@U_CCZip", BillingZip == null ? "" : BillingZip);
hsp.Add("@U_WODate", Convert.ToDateTime(WebOrderAt).ToShortDateString());
hsp.Add("@U_WODiscP", WebDiscP);
hsp.Add("@U_WODiscA", WebDiscAmonut);
hsp.Add("@U_DPMCreated", "N");
hsp.Add("@U_WOSource", "W");
hsp.Add("@U_Printed", "Y");
hsp.Add("@U_SlpCode", slpCode);
hsp.Add("@U_SComp", sCompany);
string orderREsult = Program.objHrmsUI.ExecQuery(strInsert, hsp, "addORDR");
int i = 0;
bool shippingApplied = false;
foreach (Mag.salesOrderItemEntity item in soe.items)
{
string stpo = soe.shipping_address.street;
string[] street = soe.shipping_address.street.Split('\n');
string addr1 = "";
string addr2 = "";
if (street.Length > 0)
{
addr1 = street[0].ToString();
}
if (street.Length > 1)
{
addr2 = street[1].ToString();
}
string stpo2 = soe.shipping_address.street;
string strStateCode = StateCode(soe.shipping_address.region);
hsp.Clear();
hsp.Add("@Code", incrementId + "_" + i.ToString());
hsp.Add("@Name", incrementId + "_" + i.ToString());
hsp.Add("@U_ItemCode", item.sku);
hsp.Add("@U_ItemName", item.name);
hsp.Add("@U_Quantity", item.qty_ordered);
hsp.Add("@U_Price", item.price);
hsp.Add("@U_DiscP", item.discount_percent);
hsp.Add("@U_ShipType", soe.shipping_description);
hsp.Add("@U_ShipToName", sName);
hsp.Add("@U_ShiptoImp", sName);
hsp.Add("@U_CmpImp", sCompany);
hsp.Add("@U_Addr1", addr1);
hsp.Add("@U_Addr2", addr2);
hsp.Add("@U_City", soe.shipping_address.city);
hsp.Add("@U_State", strStateCode);
hsp.Add("@U_Zipcode", sZipCode);
hsp.Add("@U_Phone", sPhone);
hsp.Add("@U_Email", sEmail);
hsp.Add("@U_ArrDate", Convert.ToDateTime(DeliveryDate));
hsp.Add("@U_ShipDate", Convert.ToDateTime(shipDate));
hsp.Add("@U_GiftCardMsg", item.gift_message == null ? "" : item.gift_message.ToString());
hsp.Add("@U_ShiptoID", sName);
string Freight1 = "";
string freightA = "";
if (!shippingApplied && Convert.ToDouble(soe.shipping_amount) > 0)
{
Freight1 = shipcharge;
freightA = soe.shipping_amount;
shippingApplied = true;
}
hsp.Add("@U_Freight", Freight1);
hsp.Add("@U_FrAmt", freightA);
hsp.Add("@U_ItemId", item.item_id);
hsp.Add("@U_WEBID", soe.increment_id);
hsp.Add("@U_SComp", sCompany);
i++;
string strRdr1Insert = @" INSERT INTO [@B1_MRDR1]
([Code]
,[Name]
,[U_ItemCode]
,[U_ItemName]
,[U_Quantity]
,[U_Price]
,[U_DiscP]
,[U_ShipType]
,[U_ShipToName]
,[U_ShiptoImp]
,[U_CmpImp]
,[U_Addr1]
,[U_Addr2]
,[U_City]
,[U_State]
,[U_Zipcode]
,[U_Phone]
,[U_Email]
,[U_ArrDate]
,[U_GiftCardMsg]
,[U_ShiptoID]
,[U_Freight]
,[U_FreightAmt]
,[U_SComp]
,[U_ItemId]
,[U_WEBID]
,[U_ShipDate])
VALUES
(@Code
,@Name
,@U_ItemCode
,@U_ItemName
,@U_Quantity
,@U_Price
,@U_DiscP
,@U_ShipType
,@U_ShipToName
,@U_ShiptoImp
,@U_CmpImp
,@U_Addr1
,@U_Addr2
,@U_City
,@U_State
,@U_Zipcode
,@U_Phone
,@U_Email
,@U_ArrDate
,@U_GiftCardMsg
,@U_ShiptoID
,@U_Freight
,@U_FrAmt
,@U_SComp
,@U_ItemId
,@U_WEBID
,@U_ShipDate)";
string detailResult = Program.objHrmsUI.ExecQuery(strRdr1Insert, hsp, "Add Row");
}
}
public override void etAfterCfl(ref SAPbouiCOM.ItemEvent pVal, ref bool BubbleEvent)
{
base.etAfterCfl(ref pVal, ref BubbleEvent);
SAPbouiCOM.IChooseFromListEvent oCFLEvento = (SAPbouiCOM.IChooseFromListEvent)pVal;
SAPbouiCOM.DataTable dtSel = oCFLEvento.SelectedObjects;
if (pVal.ItemUID == "txCode")
{
string CardCode = "";
string CardName = "";
if (dtSel != null && dtSel.Rows.Count > 0)
{
for (int i = 0; i < dtSel.Rows.Count; i++)
{
CardCode = dtSel.GetValue("CardCode", i).ToString();
CardName = dtSel.GetValue("CardName", i).ToString();
}
// mtCus.SetLineData(pVal.Row);
dtHead.Rows.Remove(0);
dtHead.Rows.Add(1);
dtHead.SetValue("CardCode", 0, CardCode);
dtHead.SetValue("CardName", 0, CardName);
AddNewCardSche(CardCode);
getSchedule();
}
}
if (pVal.ItemUID == "txICode")
{
if (dtSel != null && dtSel.Rows.Count > 0)
{
string ItemCode = "", ItemName = "";
for (int i = 0; i < dtSel.Rows.Count; i++)
{
ItemCode = dtSel.GetValue("ItemCode", i).ToString();
ItemName = dtSel.GetValue("ItemName", i).ToString();
}
// mtCus.SetLineData(pVal.Row);
dtHead.SetValue("ItemCode", 0, ItemCode);
dtHead.SetValue("ItemName", 0, ItemName);
}
}
if (pVal.ItemUID == "txOICODE")
{
if (dtSel != null && dtSel.Rows.Count > 0)
{
string ItemCode = "", ItemName = "";
for (int i = 0; i < dtSel.Rows.Count; i++)
{
ItemCode = dtSel.GetValue("ItemCode", i).ToString();
ItemName = dtSel.GetValue("ItemName", i).ToString();
}
// mtCus.SetLineData(pVal.Row);
dtHead.SetValue("OSCNCode", 0, ItemCode);
dtHead.SetValue("OSCNName", 0, ItemName);
}
}
}
