/// <summary> /// Insert new record into database. /// </summary> /// <param name="database"></param> /// <param name="data"></param> /// <returns></returns> public int AddNew(Database database, ScreenDTO data) { Database db = UseDatabase(database); StringBuilder sb = new StringBuilder(); #region SQL Statement sb.AppendLine(" INSERT INTO " + data.TableName + "("); sb.AppendLine(" " + ScreenDTO.eColumns.SCREEN_CD); sb.AppendLine(" ," + ScreenDTO.eColumns.SCREEN_NAME); sb.AppendLine(" ," + ScreenDTO.eColumns.IMAGE_CD); sb.AppendLine(" ," + ScreenDTO.eColumns.SCREEN_TYPE); sb.AppendLine(" ," + ScreenDTO.eColumns.SCREEN_ACTION); sb.AppendLine(" ," + ScreenDTO.eColumns.EXT_PROGRAM); sb.AppendLine(" ," + ScreenDTO.eColumns.CRT_BY); sb.AppendLine(" ," + ScreenDTO.eColumns.CRT_DATE); sb.AppendLine(" ," + ScreenDTO.eColumns.CRT_MACHINE); sb.AppendLine(" ," + ScreenDTO.eColumns.UPD_BY); sb.AppendLine(" ," + ScreenDTO.eColumns.UPD_DATE); sb.AppendLine(" ," + ScreenDTO.eColumns.UPD_MACHINE); sb.AppendLine(" ," + ScreenDTO.eColumns.ORIGINAL_TITLE); sb.AppendLine(" ," + ScreenDTO.eColumns.IS_AUTHORIZE); sb.AppendLine(" ," + ScreenDTO.eColumns.IS_USED); sb.AppendLine(") VALUES("); sb.AppendLine(" :SCREEN_CD"); sb.AppendLine(" ,:SCREEN_NAME"); sb.AppendLine(" ,:IMAGE_CD"); sb.AppendLine(" ,:SCREEN_TYPE"); sb.AppendLine(" ,:SCREEN_ACTION"); sb.AppendLine(" ,:EXT_PROGRAM"); sb.AppendLine(" ,:CRT_BY"); sb.AppendLine(" ,GETDATE()"); sb.AppendLine(" ,:CRT_MACHINE"); sb.AppendLine(" ,:UPD_BY"); sb.AppendLine(" ,GETDATE()"); sb.AppendLine(" ,:UPD_MACHINE"); sb.AppendLine(" ,:ORIGINAL_TITLE"); sb.AppendLine(" ,1"); sb.AppendLine(" ,1"); sb.AppendLine(" )"); #endregion DataRequest req = new DataRequest(sb.ToString()); #region Parameters req.Parameters.Add("SCREEN_CD", DataType.VarChar, data.SCREEN_CD.Value); req.Parameters.Add("SCREEN_NAME", DataType.NVarChar, data.SCREEN_NAME.Value); req.Parameters.Add("IMAGE_CD", DataType.VarChar, data.IMAGE_CD.Value); req.Parameters.Add("SCREEN_TYPE", DataType.Number, data.SCREEN_TYPE.Value); req.Parameters.Add("SCREEN_ACTION", DataType.Number, data.SCREEN_ACTION.Value); req.Parameters.Add("EXT_PROGRAM", DataType.VarChar, data.EXT_PROGRAM.Value); req.Parameters.Add("CRT_BY", DataType.NVarChar, data.CRT_BY.Value); req.Parameters.Add("CRT_MACHINE", DataType.NVarChar, data.CRT_MACHINE.Value); req.Parameters.Add("UPD_BY", DataType.NVarChar, data.UPD_BY.Value); req.Parameters.Add("UPD_MACHINE", DataType.NVarChar, data.UPD_MACHINE.Value); req.Parameters.Add("ORIGINAL_TITLE", DataType.NVarChar, data.ORIGINAL_TITLE.Value); #endregion return(db.ExecuteNonQuery(req)); }
/// <summary> /// Check exist before manipulate data. If found record will update data. Otherwise insert new data. /// </summary> /// <param name="database"></param> /// <param name="data"></param> /// <returns></returns> public int AddNewOrUpdate(Database database, ScreenDTO data) { Database db = UseDatabase(database); if (Exist(database, data.SCREEN_CD)) { return(UpdateWithoutPK(db, data)); } return(AddNew(db, data)); }
internal int SaveChangeImage(string screenCD, string imageCD) { ScreenBIZ biz = new ScreenBIZ(); ScreenDTO dto = new ScreenDTO(); dto.SCREEN_CD.Value = screenCD; dto.IMAGE_CD.Value = imageCD; dto.UPD_BY.Value = CommonLib.Common.CurrentUserInfomation.UserCD.StrongValue; dto.UPD_DATE.Value = DateTime.Now; dto.UPD_MACHINE.Value = Environment.MachineName; return(biz.UpdateScreenImage(dto)); }
public void UpdateIsUsed(Database database, ScreenDTO argScreenDTO) { Database db = UseDatabase(database); StringBuilder sb = new StringBuilder(); sb.AppendLine(" UPDATE TZ_SCREEN_MS "); sb.AppendLine(" SET IS_USED = 1 "); sb.AppendLine(" WHERE SCREEN_CD = :pSCREEN_CD"); DataRequest req = new DataRequest(sb.ToString()); req.Parameters.Add("@pSCREEN_CD", argScreenDTO.SCREEN_CD.Value); db.ExecuteNonQuery(req); }
internal int UpdateScreenImage(ScreenDTO dto) { CommonLib.Common.CurrentDatabase.KeepConnection = true; CommonLib.Common.CurrentDatabase.BeginTransaction(); try { IScreenDAO dao = DAOFactory.CreateScreenDAO(CommonLib.Common.CurrentDatabase); dao.UpdateScreenImage(null, dto); CommonLib.Common.CurrentDatabase.Commit(); return(1); } catch { CommonLib.Common.CurrentDatabase.Rollback(); throw; } }
public IScreen TakesId(string id) { string halfLink = "http://localhost:4200/viewimage/"; string returnedScreen = $"{halfLink}{id}"; using (Repository repo = new Repository()) { IScreen screenDAO = repo.GetScreenById(id); ScreenDTO screenDTO = new ScreenDTO() { Id = screenDAO.Id, Link = screenDAO.Link, Content = screenDAO.Content }; return(screenDTO); } }
public int AddNew(ScreenDTO dtoScreen) { CommonLib.Common.CurrentDatabase.KeepConnection = true; CommonLib.Common.CurrentDatabase.BeginTransaction(); try { IScreenDAO dao = DAOFactory.CreateScreenDAO(CommonLib.Common.CurrentDatabase); dao.AddNew(null, dtoScreen); CommonLib.Common.CurrentDatabase.Commit(); return(1); } catch { CommonLib.Common.CurrentDatabase.Rollback(); throw; } }
public IScreen UploadImage(ContentDTO contentDTO) { string base64Array = Convert.ToBase64String(contentDTO.Content); LinkGenerator linkGenerator = new LinkGenerator(); string link = linkGenerator.GenerateLink(); using (Repository repo = new Repository()) { IScreen screenDAO = repo.AddScreen(link, base64Array); ScreenDTO screenDTO = new ScreenDTO() { Id = screenDAO.Id, Link = screenDAO.Link, Content = screenDAO.Content }; return(screenDTO); } }
/// <summary> /// Update record by using the table's primary key. /// </summary> /// <param name="database"></param> /// <param name="data">Data which to update.</param> /// <param name="oldSCREEN_CD">Old Key #1</param> /// <returns></returns> public int UpdateWithPK(Database database, ScreenDTO data, NZString oldSCREEN_CD) { Database db = UseDatabase(database); StringBuilder sb = new StringBuilder(); #region SQL Statement sb.AppendLine(" UPDATE " + data.TableName); sb.AppendLine(" SET "); sb.AppendLine(" " + ScreenDTO.eColumns.SCREEN_CD + "=:SCREEN_CD"); sb.AppendLine(" ," + ScreenDTO.eColumns.SCREEN_NAME + "=:SCREEN_NAME"); sb.AppendLine(" ," + ScreenDTO.eColumns.IMAGE_CD + "=:IMAGE_CD"); sb.AppendLine(" ," + ScreenDTO.eColumns.SCREEN_TYPE + "=:SCREEN_TYPE"); sb.AppendLine(" ," + ScreenDTO.eColumns.SCREEN_ACTION + "=:SCREEN_ACTION"); sb.AppendLine(" ," + ScreenDTO.eColumns.EXT_PROGRAM + "=:EXT_PROGRAM"); sb.AppendLine(" ," + ScreenDTO.eColumns.UPD_BY + "=:UPD_BY"); sb.AppendLine(" ," + ScreenDTO.eColumns.UPD_DATE + "=SYSDATE"); sb.AppendLine(" ," + ScreenDTO.eColumns.UPD_MACHINE + "=:UPD_MACHINE"); sb.AppendLine(" ," + ScreenDTO.eColumns.ORIGINAL_TITLE + "=:ORIGINAL_TITLE"); sb.AppendLine(" WHERE "); sb.AppendLine(" " + ScreenDTO.eColumns.SCREEN_CD + "=:oldSCREEN_CD"); #endregion DataRequest req = new DataRequest(sb.ToString()); #region Parameters req.Parameters.Add("SCREEN_CD", DataType.VarChar, data.SCREEN_CD.Value); req.Parameters.Add("SCREEN_NAME", DataType.NVarChar, data.SCREEN_NAME.Value); req.Parameters.Add("IMAGE_CD", DataType.VarChar, data.IMAGE_CD.Value); req.Parameters.Add("SCREEN_TYPE", DataType.Number, data.SCREEN_TYPE.Value); req.Parameters.Add("SCREEN_ACTION", DataType.Number, data.SCREEN_ACTION.Value); req.Parameters.Add("EXT_PROGRAM", DataType.VarChar, data.EXT_PROGRAM.Value); req.Parameters.Add("UPD_BY", DataType.NVarChar, data.UPD_BY.Value); req.Parameters.Add("UPD_MACHINE", DataType.NVarChar, data.UPD_MACHINE.Value); req.Parameters.Add("ORIGINAL_TITLE", DataType.NVarChar, data.ORIGINAL_TITLE.Value); req.Parameters.Add("oldSCREEN_CD", DataType.VarChar, oldSCREEN_CD.Value); #endregion return(db.ExecuteNonQuery(req)); }
public int UpdateScreenImage(Database database, ScreenDTO dto) { Database db = UseDatabase(database); StringBuilder sb = new StringBuilder(); sb.AppendLine(" UPDATE TZ_SCREEN_MS "); sb.AppendLine(" SET IMAGE_CD = :IMAGE_CD, "); sb.AppendLine(" UPD_BY = :UPD_BY, "); sb.AppendLine(" UPD_DATE = :UPD_DATE, "); sb.AppendLine(" UPD_MACHINE = :UPD_MACHINE "); sb.AppendLine(" WHERE SCREEN_CD = :SCREEN_CD "); DataRequest req = new DataRequest(sb.ToString()); req.Parameters.Add("SCREEN_CD", DataType.NVarChar, dto.SCREEN_CD.Value); req.Parameters.Add("IMAGE_CD", DataType.NVarChar, dto.IMAGE_CD.Value); req.Parameters.Add("UPD_BY", DataType.NVarChar, dto.UPD_BY.Value); req.Parameters.Add("UPD_DATE", DataType.DateTime, dto.UPD_DATE.Value); req.Parameters.Add("UPD_MACHINE", DataType.NVarChar, dto.UPD_MACHINE.Value); return(db.ExecuteNonQuery(req)); }
public virtual IEnumerable maintainCustomer(PXCache cache, Customer customer) { string screenName = ""; string errMess = ""; string customerAcctCD; if (customer.AcctCD == null) { return(null); } else { customerAcctCD = customer.AcctCD.Trim(); } ScreenDTO screenReply = new ScreenDTO(); ScreenSubmitRequestDTO submitRequest = new ScreenSubmitRequestDTO(); try { ClientConversation.authenticate(userName, password); ScreenService screenService = new ScreenService() { Timeout = sessionTimeout, Url = $"{urlPrefix(dbName)}ScreenService" }; PLNSC.ScreenService.OperationContext screenContext = new PLNSC.ScreenService.OperationContext() { district = districtCode, position = positionID, maxInstances = 1, returnWarnings = false, trace = false //transaction = transID }; string currencyType = customer.CuryID != null?customer.CuryID.Trim() : "IDR"; screenReply = screenService.executeScreen(screenContext, "MSO500"); screenName = screenReply.mapName; if (screenName != "MSM500A") { screenService.positionToMenu(screenContext); screenReply = screenService.executeScreen(screenContext, "MSO500"); screenName = screenReply.mapName; if (screenName != "MSM500A") { throw new PXException(CustomMessage.NotMSM500A); } } ScreenNameValueDTO[] fields = { new ScreenNameValueDTO(), new ScreenNameValueDTO() }; fields[0].fieldName = "OPTION1I"; fields[0].value = "1"; fields[1].fieldName = "CUST_NO1I"; fields[1].value = customerAcctCD; submitRequest.screenFields = fields; submitRequest.screenKey = "1"; // OK screenReply = screenService.submit(screenContext, submitRequest); screenName = screenReply.mapName; errMess = screenReply.message; if (errMess.Trim() != "" && !errMess.Contains("CUSTOMER CODE ALREADY EXISTS")) { throw new PXException(errMess.Trim()); } else { if (errMess.Contains("CUSTOMER CODE ALREADY EXISTS")) { ScreenNameValueDTO[] fieldsMod = { new ScreenNameValueDTO(), new ScreenNameValueDTO() }; fieldsMod[0].fieldName = "OPTION1I"; fieldsMod[0].value = "2"; fieldsMod[1].fieldName = "CUST_NO1I"; fieldsMod[1].value = customerAcctCD; submitRequest.screenFields = fieldsMod; submitRequest.screenKey = "1"; // OK screenReply = screenService.submit(screenContext, submitRequest); screenName = screenReply.mapName; errMess = screenReply.message; if (errMess.Trim() != "" && !errMess.Contains("CUSTOMER CODE ALREADY EXISTS")) { throw new PXException(errMess.Trim()); } } if (screenName == "MSM500B") { BAccount acctCustomer = PXSelect <BAccount, Where <BAccount.bAccountID, Equal <Required <BAccount.bAccountID> > > > .Select(Base, customer.BAccountID); Address customerAddress = PXSelect <Address, Where <Address.bAccountID, Equal <Required <Address.bAccountID> > > > .Select(Base, customer.BAccountID); Contact contact = PXSelect <Contact, Where <Contact.bAccountID, Equal <Required <Contact.bAccountID> > > > .Select(Base, customer.BAccountID); String customerCountry = ""; String addressLine1 = ""; String addressLine2 = ""; String attn = ""; String email = ""; String phone = ""; if (customerAddress != null) { customerCountry = customerAddress.CountryID.Trim(); addressLine1 = customerAddress.AddressLine1.Trim(); addressLine2 = customerAddress.AddressLine2 != null?customerAddress.AddressLine2.Trim() : " "; } if (contact != null) { attn = contact.Salutation != null?contact.Salutation.Trim() : " "; email = contact.EMail != null?contact.EMail.Trim() : " "; phone = contact.Phone1 != null?contact.Phone1.Trim() : " "; } if (screenName == "MSM500B") { ScreenNameValueDTO[] fields500B = { new ScreenNameValueDTO(), new ScreenNameValueDTO(), new ScreenNameValueDTO(), new ScreenNameValueDTO(), new ScreenNameValueDTO(), new ScreenNameValueDTO(), new ScreenNameValueDTO() }; string customerAcctName = customer.AcctName != null?customer.AcctName.Trim() : " "; fields500B[0].fieldName = "CUST_NAME2I"; fields500B[0].value = customerAcctName; fields500B[1].fieldName = "CURRENCY_TYPE2I"; fields500B[1].value = currencyType; fields500B[2].fieldName = "COUNTRY_CODE2I"; fields500B[2].value = customerCountry; fields500B[3].fieldName = "INV_ADDR_12I"; fields500B[3].value = addressLine1; fields500B[4].fieldName = "INV_ADDR_22I"; fields500B[4].value = addressLine2; fields500B[5].fieldName = "INV_CONTACT2I"; fields500B[5].value = attn; fields500B[6].fieldName = "INV_PHONE2I"; fields500B[6].value = phone; submitRequest.screenFields = fields500B; submitRequest.screenKey = "1"; // OK screenReply = screenService.submit(screenContext, submitRequest); screenName = screenReply.mapName.Trim(); errMess = screenReply.message; if (errMess.Trim() != "" && !errMess.Contains("WARNING: CHECK PRICING CODE CURRENCY IN DISTRICTS")) { throw new PXException(errMess.Trim()); } else { if (errMess.Contains("WARNING: CHECK PRICING CODE CURRENCY IN DISTRICTS")) { submitRequest.screenKey = "1"; // OK screenReply = screenService.submit(screenContext, submitRequest); screenName = screenReply.mapName.Trim(); errMess = screenReply.message; } } if (screenName == "MSM500D") { ScreenNameValueDTO[] fields500D = { new ScreenNameValueDTO() }; fields500D[0].fieldName = "EMAIL_ADDRESS4I1"; fields500D[0].value = email; submitRequest.screenFields = fields500D; submitRequest.screenKey = "1"; // OK screenReply = screenService.submit(screenContext, submitRequest); screenName = screenReply.mapName.Trim(); errMess = screenReply.message; if (errMess.Trim() != "") { throw new PXException(errMess.Trim()); } if (screenReply.functionKeys.Contains("XMIT-Confirm")) { submitRequest.screenKey = "1"; // OK screenReply = screenService.submit(screenContext, submitRequest); } screenName = screenReply.mapName.Trim(); errMess = screenReply.message; if (errMess.Trim() != "") { throw new PXException(errMess.Trim()); } if (screenName == "MSM500C") { ScreenNameValueDTO[] fields500C = new ScreenNameValueDTO[9]; fields500C[0] = new ScreenNameValueDTO() { fieldName = "PMT_METH_IND3I", value = "C" }; fields500C[1] = new ScreenNameValueDTO() { fieldName = "CR_TERMS3I", value = "U" }; fields500C[2] = new ScreenNameValueDTO() { fieldName = "SECURED3I", value = "N" }; fields500C[3] = new ScreenNameValueDTO() { fieldName = "STMT_REQ_SW3I", value = "Y" }; fields500C[4] = new ScreenNameValueDTO() { fieldName = "INV_MEDIUM_IND3I", value = "P" }; fields500C[5] = new ScreenNameValueDTO() { fieldName = "DAYS_GRACE3I", value = "5" }; fields500C[6] = new ScreenNameValueDTO() { fieldName = "DAYS_TO_PAY3I", value = "30" }; string customerClass = customer.CustomerClassID; string acctGrpCode = ""; if (customerClass != null) { customerClass = customerClass.Trim(); switch (customerClass) { case "PLN": acctGrpCode = "0001"; break; case "IP": acctGrpCode = "0002"; break; case "PJB": acctGrpCode = "0003"; break; case "OTHERS": acctGrpCode = "0000"; break; default: acctGrpCode = "0000"; break; } } fields500C[7] = new ScreenNameValueDTO() { fieldName = "ACCT_GRP_CODE3I", value = acctGrpCode }; fields500C[8] = new ScreenNameValueDTO() { fieldName = "STATEMENT_TYPE3I", value = "B" }; submitRequest.screenFields = fields500C; submitRequest.screenKey = "1"; // OK screenReply = screenService.submit(screenContext, submitRequest); screenName = screenReply.mapName.Trim(); errMess = screenReply.message; if (errMess.Trim() != "" && !errMess.Contains("ACCT GROUP CODE ONLY UPDATED IF VALID FOR DISTRICT")) { throw new PXException(errMess.Trim()); } if (screenReply.functionKeys.Contains("XMIT-Confirm")) { submitRequest.screenKey = "1"; // OK screenReply = screenService.submit(screenContext, submitRequest); screenName = screenReply.mapName.Trim(); errMess = screenReply.message; if (errMess.Trim() != "") { throw new PXException(errMess.Trim()); } else { screenService.positionToMenu(screenContext); } } } } } } } } catch (Exception ex) { throw new PXException(ex.Message); } return(null); }
bool reviewPO(POOrder pOOrder) { bool result = false; bool loggedIn = false; string screenName = ""; string errorMessage = ""; PLNSC.ScreenService.OperationContext screenContext = new PLNSC.ScreenService.OperationContext() { district = districtCode, position = positionID, maxInstances = 1 }; ScreenService screenService = new ScreenService() { Timeout = sessionTimeout, Url = $"{urlPrefix(dbName)}ScreenService" }; ScreenDTO screenReply = new ScreenDTO(); ScreenSubmitRequestDTO submitRequest = new ScreenSubmitRequestDTO(); try { ClientConversation.authenticate(userName, password); loggedIn = true; } catch (Exception ex) { loggedIn = false; throw new PXException(ex.Message); } if (loggedIn) { try { ClientConversation.authenticate(userName, password); screenReply = screenService.executeScreen(screenContext, "MSO220"); screenName = screenReply.mapName; if (screenName != "MSM220A") { throw new PXException(CustomMessage.NotMSM221A); } ScreenNameValueDTO[] fields = { new ScreenNameValueDTO(), new ScreenNameValueDTO() }; fields[0].fieldName = "OPTION1I"; fields[0].value = "1"; fields[1].fieldName = "PO_NO1I"; fields[1].value = pOOrder.OrderNbr.Trim(); submitRequest.screenFields = fields; submitRequest.screenKey = "1"; // OK screenReply = screenService.submit(screenContext, submitRequest); screenName = screenReply.mapName; errorMessage = screenReply.message; if (errorMessage.Trim().Contains("PURCHASE ORDER DOES NOT EXIST")) { result = false; } else { result = true; } screenService.positionToMenu(screenContext); } catch (Exception ex) { result = false; throw new PXException(ex.Message); } } return(result); }
public void ImportData(List <ScreenImportUIDM> ScreenImportList, List <ScreenDetailUIDM> UIDMScreenDetailList) { LangBIZ bizLang = new LangBIZ(); LangDTO dtoLang = new LangDTO(); ScreenDetailBIZ bizScreenDetail = new ScreenDetailBIZ(); List <ScreenDTO> screenDTOList = new List <ScreenDTO>(); List <ScreenLangDTO> screenLangDTOList = new List <ScreenLangDTO>(); List <ScreenDetailDTO> screenDetailDTOList = new List <ScreenDetailDTO>(); List <ScreenDetailLangDTO> screenDetailLangDTOList = new List <ScreenDetailLangDTO>(); // count lang detail List <LangDTO> langDTOList = bizLang.LoadAll(); #region Collect Data foreach (ScreenImportUIDM ScreenImport in ScreenImportList) { // check if screen is never been import then import to screen ms if (ScreenImport.ImportStatus.StrongValue.ToUpper() == "NOTIMPORT") { ScreenDTO dtoScreen = new ScreenDTO(); dtoScreen.SCREEN_CD = ScreenImport.ScreenCD; dtoScreen.SCREEN_NAME = ScreenImport.ScreenName; dtoScreen.ORIGINAL_TITLE = ScreenImport.ScreenName; dtoScreen.IMAGE_CD.Value = "DEFAULT"; dtoScreen.SCREEN_TYPE = ScreenImport.ScreenType; dtoScreen.SCREEN_ACTION.Value = 0; dtoScreen.EXT_PROGRAM.Value = string.Empty; dtoScreen.CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dtoScreen.CRT_DATE.Value = DateTime.Now; dtoScreen.CRT_MACHINE.Value = Environment.MachineName; dtoScreen.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dtoScreen.UPD_DATE.Value = DateTime.Now; dtoScreen.UPD_MACHINE.Value = Environment.MachineName; screenDTOList.Add(dtoScreen); if (langDTOList.Count > 0) { foreach (LangDTO langdto in langDTOList) { ScreenLangDTO dtoScreenLang = new ScreenLangDTO(); // add multilang for screen name dtoScreenLang.SCREEN_CD = ScreenImport.ScreenCD; dtoScreenLang.SCREEN_DESC = ScreenImport.ScreenName; dtoScreenLang.CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dtoScreenLang.CRT_DATE.Value = DateTime.Now; dtoScreenLang.CRT_MACHINE.Value = Environment.MachineName; dtoScreenLang.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dtoScreenLang.UPD_DATE.Value = DateTime.Now; dtoScreenLang.UPD_MACHINE.Value = Environment.MachineName; dtoScreenLang.LANG_CD = langdto.LANG_CD; //bizScreenLang.AddNew(dtoScreenLang); screenLangDTOList.Add(dtoScreenLang); } } } } foreach (ScreenDetailUIDM ScreenDetail in UIDMScreenDetailList) { ScreenDetailDTO dtoScreenDetail = new ScreenDetailDTO(); dtoScreenDetail.SCREEN_CD = ScreenDetail.ScreenCD; dtoScreenDetail.CONTROL_TYPE = ScreenDetail.ControlType; dtoScreenDetail.ORIGINAL_TITLE = ScreenDetail.ControlCaption; dtoScreenDetail.CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dtoScreenDetail.CRT_DATE.Value = DateTime.Now; dtoScreenDetail.CRT_MACHINE.Value = Environment.MachineName; dtoScreenDetail.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dtoScreenDetail.UPD_DATE.Value = DateTime.Now; dtoScreenDetail.UPD_MACHINE.Value = Environment.MachineName; dtoScreenDetail.CONTROL_CD = ScreenDetail.ControlCD; screenDetailDTOList.Add(dtoScreenDetail); if (langDTOList.Count > 0) { foreach (LangDTO langdto in langDTOList) { ScreenDetailLangDTO dtoScreenDetailLang = new ScreenDetailLangDTO(); // add spread column to screen detail ms dtoScreenDetailLang.SCREEN_CD = ScreenDetail.ScreenCD; dtoScreenDetailLang.CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dtoScreenDetailLang.CRT_DATE.Value = DateTime.Now; dtoScreenDetailLang.CRT_MACHINE.Value = Environment.MachineName; dtoScreenDetailLang.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dtoScreenDetailLang.UPD_DATE.Value = DateTime.Now; dtoScreenDetailLang.UPD_MACHINE.Value = Environment.MachineName; // add multilang for spread column dtoScreenDetailLang.CONTROL_CD = ScreenDetail.ControlCD; //.Value = fpsspread.Name + ".Column[" + i.ToString() + "]"; dtoScreenDetailLang.CONTROL_CAPTION = ScreenDetail.ControlCaption; //.Value = fpsspread.Sheets[0].Columns[i].Label; dtoScreenDetailLang.LANG_CD = langdto.LANG_CD; screenDetailLangDTOList.Add(dtoScreenDetailLang); } } } #endregion ImportScreenBIZ bizImportScreen = new ImportScreenBIZ(); bizImportScreen.ImportData(screenDTOList, screenLangDTOList, screenDetailDTOList, screenDetailLangDTOList); }
public virtual IEnumerable createPO(POOrder pOOrder, POLine pOLine) { RQRequisitionOrder rQRequisitionOrder = PXSelect <RQRequisitionOrder, Where <RQRequisitionOrder.orderNbr, Equal <Required <RQRequisitionOrder.orderNbr> >, And <RQRequisitionOrder.orderCategory, Equal <RQOrderCategory.po> > > > .Select(Base, pOOrder.OrderNbr); RQRequisition rQRequisition = PXSelect <RQRequisition, Where <RQRequisition.reqNbr, Equal <Required <RQRequisitionOrder.reqNbr> > > > .Select(Base, rQRequisitionOrder.ReqNbr); RQRequisitionExt rQRequisitionExt = rQRequisition.GetExtension <RQRequisitionExt>(); int purchaseMethod = rQRequisition != null ? rQRequisitionExt.UsrPurchMethod ?? 2 : 2; string nonCoreDO = rQRequisition != null ? rQRequisitionExt.UsrDONbr != null?rQRequisitionExt.UsrDONbr.Trim() : string.Empty : string.Empty; string modifyPRResult = string.Empty; if (purchaseMethod != 2) { modifyPRResult = modifyPOCostAlloc(pOOrder, pOLine, purchaseMethod, nonCoreDO); if (!modifyPRResult.Trim().Contains("OK")) { return(modifyPRResult.Trim()); } } PLNSC.ScreenService.OperationContext screenContext = new PLNSC.ScreenService.OperationContext() { district = "SC01", position = "INTPO", maxInstances = 1 }; ScreenService screenService = new ScreenService() { Timeout = sessionTimeout, Url = $"{urlPrefix(dbName)}ScreenService" }; ScreenDTO screenReply = new ScreenDTO(); ScreenSubmitRequestDTO submitRequest = new ScreenSubmitRequestDTO(); bool loggedIn = false; bool modifyFlag = false; string screenName = ""; string errMess = ""; string currentCursor = ""; try { ClientConversation.authenticate(userName, password); loggedIn = true; } catch (Exception ex) { loggedIn = false; throw new PXException(ex.Message); } if (loggedIn) { try { screenReply = screenService.executeScreen(screenContext, "MSO230"); screenName = screenReply.mapName; if (screenName != "MSM230A") { throw new PXException(CustomMessage.NotMSO230); } ScreenNameValueDTO[] fields = { new ScreenNameValueDTO(), new ScreenNameValueDTO(), new ScreenNameValueDTO() }; fields[0].fieldName = "OPTION1I"; fields[0].value = "3"; fields[1].fieldName = "PREQ_NO1I"; fields[1].value = pOLine.RQReqNbr; fields[2].fieldName = "PREQ_ITEM_NO1I"; fields[2].value = pOLine.RQReqLineNbr.ToString(); submitRequest.screenFields = fields; submitRequest.screenKey = "1"; // OK screenReply = screenService.submit(screenContext, submitRequest); screenName = screenReply.mapName; errMess = screenReply.message; if (errMess.Trim() != "") { throw new PXException(errMess.Trim()); } if (screenName == "MSM23EA") { ScreenFieldDTO[] screenFieldDTOs = screenReply.screenFields; foreach (ScreenFieldDTO screenFieldDTO in screenFieldDTOs) { String fieldName = screenFieldDTO.fieldName; String preqItemNo = ""; if (fieldName == "PREQ_ITEM_NO1I") { preqItemNo = screenFieldDTO.value; } } ScreenNameValueDTO[] field23E = new ScreenNameValueDTO[5]; field23E[0] = new ScreenNameValueDTO(); field23E[0].fieldName = "PO_NO1I"; field23E[0].value = pOOrder.OrderNbr.Trim(); field23E[1] = new ScreenNameValueDTO(); field23E[1].fieldName = "PO_ITEM1I"; field23E[1].value = pOLine.LineNbr.ToString(); field23E[2] = new ScreenNameValueDTO(); field23E[2].fieldName = "PROCESS_ITEM1I"; field23E[2].value = "L"; field23E[3] = new ScreenNameValueDTO(); field23E[3].fieldName = "ORDER_DATE1I"; field23E[3].value = DateTime.Now.ToString("yyyyMMdd"); field23E[4] = new ScreenNameValueDTO(); field23E[4].fieldName = "PURCH_OFFICER1I"; field23E[4].value = "ADMIN"; submitRequest.screenFields = field23E; submitRequest.screenKey = "1"; // OK screenReply = screenService.submit(screenContext, submitRequest); if (screenReply.functionKeys.Contains("XMIT-Confirm")) { submitRequest.screenKey = "1"; // OK screenReply = screenService.submit(screenContext, submitRequest); } screenName = screenReply.mapName; errMess = screenReply.message; currentCursor = screenReply.currentCursorFieldName; if (errMess.Trim() != "" && !screenReply.functionKeys.Contains("XMIT-Confirm")) { throw new PXException(errMess.Trim()); } } } catch (Exception e) { throw new PXException(e.Message); } } return(null); }
public virtual IEnumerable modifyPO(POOrder pOOrder, POLine pOLine) { PLNSC.ScreenService.OperationContext screenContext = new PLNSC.ScreenService.OperationContext() { district = "SC01", position = "INTPO", maxInstances = 1 }; ScreenService screenService = new ScreenService() { Timeout = sessionTimeout, Url = $"{urlPrefix(dbName)}ScreenService" }; ScreenDTO screenReply = new ScreenDTO(); ScreenSubmitRequestDTO submitRequest = new ScreenSubmitRequestDTO(); bool loggedIn = false; bool modifyFlag = false; string screenName = ""; string errMess = ""; string currentCursor = ""; try { ClientConversation.authenticate(userName, password); loggedIn = true; } catch (Exception ex) { loggedIn = false; throw new PXException(ex.Message); } if (loggedIn) { try { screenReply = screenService.executeScreen(screenContext, "MSO220"); screenName = screenReply.mapName; if (screenName != "MSM220A") { throw new PXException(CustomMessage.NotMSM220A); } ScreenNameValueDTO[] fields = { new ScreenNameValueDTO(), new ScreenNameValueDTO(), new ScreenNameValueDTO() }; fields[0].fieldName = "OPTION1I"; fields[0].value = "1"; fields[1].fieldName = "PO_NO1I"; fields[1].value = pOOrder.OrderNbr; fields[2].fieldName = "PO_ITEM_NO1I"; fields[2].value = pOLine.LineNbr.ToString(); submitRequest.screenFields = fields; submitRequest.screenKey = "1"; // OK screenReply = screenService.submit(screenContext, submitRequest); screenName = screenReply.mapName; errMess = screenReply.message; if (errMess.Trim() != "") { throw new PXException(errMess.Trim()); } if (screenName == "MSM22CA") { ScreenFieldDTO[] screenFieldDTOs = screenReply.screenFields; ScreenNameValueDTO[] modifyPOFields = new ScreenNameValueDTO[7]; modifyPOFields[0] = new ScreenNameValueDTO(); modifyPOFields[0].fieldName = "GROSS_PR_UOP1I"; if (pOLine.LineType == POLineType.GoodsForDropShip || pOLine.LineType == POLineType.GoodsForInventory || pOLine.LineType == POLineType.GoodsForSalesOrder || pOLine.LineType == POLineType.GoodsForManufacturing || pOLine.LineType == POLineType.GoodsForReplenishment) { modifyPOFields[0].value = Math.Round(pOLine.CuryUnitCost ?? 0, 2).ToString(); } else { modifyPOFields[0].value = Math.Round((pOLine.CuryUnitCost ?? 0) * (pOLine.OrderQty ?? 0), 2).ToString(); } modifyPOFields[1] = new ScreenNameValueDTO(); modifyPOFields[1].fieldName = "UNIT_OF_ISSUE1I"; modifyPOFields[1].value = pOLine.UOM.Trim(); modifyPOFields[2] = new ScreenNameValueDTO(); modifyPOFields[2].fieldName = "CURR_QTY_P1I"; if (pOLine.LineType == POLineType.GoodsForDropShip || pOLine.LineType == POLineType.GoodsForInventory || pOLine.LineType == POLineType.GoodsForSalesOrder || pOLine.LineType == POLineType.GoodsForManufacturing || pOLine.LineType == POLineType.GoodsForReplenishment) { modifyPOFields[2].value = Math.Round(pOLine.OrderQty ?? 0, 2).ToString(); } else { modifyPOFields[2].value = string.Empty; } modifyPOFields[3] = new ScreenNameValueDTO(); modifyPOFields[3].fieldName = "UNIT_OF_PURCH1I"; modifyPOFields[3].value = pOLine.UOM.Trim(); modifyPOFields[4] = new ScreenNameValueDTO(); modifyPOFields[4].fieldName = "PRICE_CODE1I"; modifyPOFields[4].value = pOOrder.TermsID.Trim(); modifyPOFields[5] = new ScreenNameValueDTO(); modifyPOFields[5].fieldName = "DUE_DATE1I"; modifyPOFields[5].value = (pOLine.PromisedDate ?? DateTime.Now).ToString("yyyyMMdd"); modifyPOFields[6] = new ScreenNameValueDTO(); modifyPOFields[6].fieldName = "DUE_SITE1I"; modifyPOFields[6].value = (pOLine.PromisedDate ?? DateTime.Now).ToString("yyyyMMdd"); submitRequest.screenFields = modifyPOFields; submitRequest.screenKey = "1"; // OK screenReply = screenService.submit(screenContext, submitRequest); screenName = screenReply.mapName; errMess = screenReply.message; currentCursor = screenReply.currentCursorFieldName; if (screenReply.functionKeys.Contains("XMIT-Confirm")) { submitRequest.screenKey = "1"; // OK screenReply = screenService.submit(screenContext, submitRequest); } screenName = screenReply.mapName; errMess = screenReply.message; currentCursor = screenReply.currentCursorFieldName; if (errMess.Trim() != "" && !screenReply.functionKeys.Contains("XMIT-Confirm")) { throw new PXException(errMess.Trim()); } } screenService.positionToMenu(screenContext); } catch (Exception e) { screenService.positionToMenu(screenContext); throw new PXException(e.Message); } } return(null); }
string modifyPOCostAlloc(POOrder pOOrder, POLine pOLine, int purchaseMethod, string nonCoreDO) { string result = ""; string projectNo = ""; if (nonCoreDO != string.Empty) { projectNo = nonCoreDO; } else { SOLineSplit sOLineSplit = PXSelect <SOLineSplit, Where <SOLineSplit.pONbr, Equal <Required <SOLineSplit.pONbr> > > > .Select(Base, pOOrder.OrderNbr); if (sOLineSplit != null) { projectNo = sOLineSplit.OrderNbr.Trim(); } else { RQRequisitionOrder rQRequisitionOrder = PXSelect <RQRequisitionOrder, Where <RQRequisitionOrder.orderNbr, Equal <Required <RQRequisitionOrder.orderNbr> >, And <RQRequisitionOrder.orderCategory, Equal <RQOrderCategory.po> > > > .Select(Base, pOOrder.OrderNbr); if (rQRequisitionOrder != null) { string reqNbr = rQRequisitionOrder.ReqNbr; RQRequisitionOrder poReq = PXSelect <RQRequisitionOrder, Where <RQRequisitionOrder.reqNbr, Equal <Required <RQRequisitionOrder.reqNbr> >, And <RQRequisitionOrder.orderCategory, Equal <RQOrderCategory.so>, And <RQRequisitionOrder.orderType, Equal <SOOrderTypeConstants.salesOrder> > > > > .Select(Base, reqNbr); if (poReq != null) { projectNo = poReq.OrderNbr.Trim(); } } } } PLNSC.ScreenService.OperationContext screenContext = new PLNSC.ScreenService.OperationContext() { district = "SC01", position = "INTPO", maxInstances = 1 }; ScreenService screenService = new ScreenService() { Timeout = sessionTimeout, Url = $"{urlPrefix(dbName)}ScreenService" }; ScreenDTO screenReply = new ScreenDTO(); ScreenSubmitRequestDTO submitRequest = new ScreenSubmitRequestDTO(); bool loggedIn = false; bool modifyFlag = false; string screenName = ""; string errMess = ""; string currentCursor = ""; try { ClientConversation.authenticate(userName, password); loggedIn = true; } catch (Exception ex) { loggedIn = false; result = ex.Message.Trim(); throw new PXException(ex.Message); } if (loggedIn) { try { screenReply = screenService.executeScreen(screenContext, "MSO230"); screenName = screenReply.mapName; if (screenName != "MSM230A") { result = CustomMessage.NotMSM220A; throw new PXException(CustomMessage.NotMSM220A); } ScreenNameValueDTO[] fields = { new ScreenNameValueDTO(), new ScreenNameValueDTO() }; fields[0].fieldName = "OPTION1I"; fields[0].value = "5"; fields[1].fieldName = "PREQ_NO1I"; fields[1].value = pOLine.RQReqNbr; submitRequest.screenFields = fields; submitRequest.screenKey = "1"; // OK screenReply = screenService.submit(screenContext, submitRequest); screenName = screenReply.mapName; errMess = screenReply.message; if (errMess.Trim() != "") { result = errMess.Trim(); throw new PXException(errMess.Trim()); } if (screenName == "MSM232A") { ScreenFieldDTO[] screenReplyFields = screenReply.screenFields; foreach (ScreenFieldDTO screenFieldDto in screenReplyFields) { if (screenFieldDto.fieldName == "WO_PROJECT1I1") { if (screenFieldDto.value != null) { if (screenFieldDto.value.Trim() != "") { return("OK"); } } } } ScreenNameValueDTO[] fields232A = { new ScreenNameValueDTO(), new ScreenNameValueDTO() }; fields232A[0].fieldName = "WO_PROJECT1I1"; fields232A[0].value = projectNo; fields232A[1].fieldName = "PROJECT_IND1I1"; fields232A[1].value = "P"; submitRequest.screenFields = fields232A; submitRequest.screenKey = "1"; // OK screenReply = screenService.submit(screenContext, submitRequest); screenName = screenReply.mapName; errMess = screenReply.message; if (errMess.Trim() != "" && !screenReply.functionKeys.Contains("XMIT-Confirm")) { result = errMess.Trim(); throw new PXException(errMess.Trim()); } if (screenReply.functionKeys.Contains("XMIT-Confirm")) { submitRequest.screenKey = "1"; // OK screenReply = screenService.submit(screenContext, submitRequest); } screenName = screenReply.mapName; errMess = screenReply.message; if (errMess.Trim() != "" && !screenReply.functionKeys.Contains("XMIT-Confirm")) { result = errMess.Trim(); throw new PXException(errMess.Trim()); } else { result = "OK"; screenService.positionToMenu(screenContext); } } } catch (Exception ex) { screenService.positionToMenu(screenContext); throw new PXException(ex.Message); } } return(result); }
string cancelPONonGoods(POReceipt pOReceipt, POReceiptLine pOReceiptLine) { string result = ""; PLNSC.ScreenService.OperationContext SSContextClass = new PLNSC.ScreenService.OperationContext() { district = districtCode, position = positionID, maxInstances = maxInstance }; ScreenService screenService = new ScreenService() { Timeout = sessionTimeout, Url = $"{urlPrefix(dbName)}ScreenService" }; ScreenDTO screenReply = new ScreenDTO(); ScreenSubmitRequestDTO submitRequest = new ScreenSubmitRequestDTO(); try { ClientConversation.authenticate(userName, password); screenReply = screenService.executeScreen(SSContextClass, "MSO155"); screenName = screenReply.mapName; if (screenName != "MSM155A") { throw new PXException(CustomMessage.NotMSO155); } ScreenNameValueDTO[] fields = { new ScreenNameValueDTO(), new ScreenNameValueDTO(), new ScreenNameValueDTO(), new ScreenNameValueDTO() }; fields[0].fieldName = "OPTION1I"; fields[0].value = "3"; fields[1].fieldName = "PO_NO1I"; fields[1].value = pOReceiptLine.PONbr; fields[2].fieldName = "PO_ITEM1I"; fields[2].value = pOReceiptLine.POLineNbr.ToString(); fields[3].fieldName = "AUTH_BY1I"; fields[3].value = "ADMIN"; submitRequest.screenFields = fields; submitRequest.screenKey = "1"; // OK screenReply = screenService.submit(SSContextClass, submitRequest); screenName = screenReply.mapName; errorMsg = screenReply.message; if (errorMsg.Trim() != "" && !screenReply.functionKeys.Contains("XMIT-Confirm")) { throw new PXException(errorMsg.Trim()); } if (screenName != "MSM156A") { throw new PXException(CustomMessage.NotMSM156A); } ScreenNameValueDTO[] fields156 = { new ScreenNameValueDTO(), new ScreenNameValueDTO(), new ScreenNameValueDTO(), new ScreenNameValueDTO() }; string receiptRef = pOReceipt.ReceiptNbr != null ? pOReceipt.ReceiptNbr.Trim() : " "; string cancelValue = Math.Round((pOReceiptLine.CuryExtCost * -1) ?? 0, 2).ToString().Trim(); fields156[0].fieldName = "VALUE_RECVD1I"; fields156[0].value = cancelValue; fields156[1].fieldName = "RECEIPT_REF1I"; fields156[1].value = "S-" + receiptRef + "RT"; fields156[2].fieldName = "RECEIPT_DATE1I"; fields156[2].value = DateTime.Now.ToString("yyyyMMdd"); fields156[3].fieldName = "ANSWER1I"; fields156[3].value = "N"; submitRequest.screenFields = fields156; submitRequest.screenKey = "1"; // OK screenReply = screenService.submit(SSContextClass, submitRequest); screenName = screenReply.mapName; errorMsg = screenReply.message; if (screenReply.functionKeys.Contains("XMIT-Confirm")) { submitRequest.screenKey = "1"; // OK screenReply = screenService.submit(SSContextClass, submitRequest); screenName = screenReply.mapName; errorMsg = screenReply.message; } screenService.positionToMenu(SSContextClass); result = "OK"; } catch (Exception ex) { result = ex.Message; throw new PXException(ex.Message); } return result; }
///// <summary> ///// Get or set Type reference of Screen for reflection process. ///// </summary> //public Type ClassType //{ // get { return m_internalScreen.ClassType; } // set { m_internalScreen.ClassType = value; } //} ///// <summary> ///// Get or set screen ID ///// </summary> //public string ScreenCD //{ // get { return m_databaseScreen.ScreenCD; } // set { m_databaseScreen.ScreenCD = value; } //} ///// <summary> ///// Get or set screen name. ///// </summary> //public string ScreenName //{ // get { return m_databaseScreen.ScreenName; } // set { m_databaseScreen.ScreenName = value; } //} ///// <summary> ///// Get or set screen description. ///// </summary> //public string ScreenDescription //{ // get { return m_databaseScreen.ScreenDescription; } // set { m_databaseScreen.ScreenDescription = value; } //} ///// <summary> ///// Get or set ScreenKind. ///// Window or Popup ///// </summary> //public eShowAction ShowAction //{ // get { return m_databaseScreen.ShowAction; } // set { m_databaseScreen.ShowAction = value; } //} ///// <summary> ///// Get or set external program. ///// </summary> //public string ExternalProgram //{ // get { return m_databaseScreen.ExternalProgram; } // set { m_databaseScreen.ExternalProgram = value; } //} ///// <summary> ///// Get or set Image index. ///// </summary> //public string ImageCD //{ // get { return m_databaseScreen.ImageCD; } // set { m_databaseScreen.ImageCD = value; } //} //public eScreenType ScreenType //{ // get { return m_databaseScreen.ScreenType; } // set { m_databaseScreen.ScreenType = value; } //} #endregion #region Public method public bool CheckFoundScreen(ScreenDTO data) { return(true); }
public virtual IEnumerable maintainVendor(PXCache cache, Vendor vendor) { string screenName = ""; string errMess = ""; if (vendor.AcctCD == null) { return(null); } string vendorAcctCD = vendor.AcctCD.Trim(); string currencyType = vendor.CuryID != null?vendor.CuryID.Trim() : "IDR"; string vendorAcctName = vendor.AcctName != null?vendor.AcctName.Trim() : " "; ScreenDTO screenReply = new ScreenDTO(); ScreenSubmitRequestDTO submitRequest = new ScreenSubmitRequestDTO(); try { ClientConversation.authenticate(userName, password); ScreenService screenService = new ScreenService() { Timeout = sessionTimeout, Url = $"{urlPrefix(dbName)}ScreenService" }; OperationContext screenContext = new OperationContext() { district = districtCode, position = positionID, maxInstances = 1, returnWarnings = false, trace = false }; screenReply = screenService.executeScreen(screenContext, "MSO200"); screenName = screenReply.mapName; if (screenName != "MSM200A") { screenService.positionToMenu(screenContext); screenReply = screenService.executeScreen(screenContext, "MSO200"); screenName = screenReply.mapName; if (screenName != "MSM200A") { throw new PXException(CustomMessage.NotMSM200A); } } ScreenNameValueDTO[] fields = { new ScreenNameValueDTO(), new ScreenNameValueDTO(), new ScreenNameValueDTO() }; fields[0].fieldName = "OPTION1I"; fields[0].value = "1"; fields[1].fieldName = "SUPPLIER_NO1I"; fields[1].value = vendorAcctCD; fields[2].fieldName = "SUP_STATUS1I"; fields[2].value = "N"; submitRequest.screenFields = fields; submitRequest.screenKey = "1"; screenReply = screenService.submit(screenContext, submitRequest); screenName = screenReply.mapName; errMess = screenReply.message; if (errMess.Trim() != "" && !errMess.Contains("SUPPLIER CODE ALREADY EXISTS")) { screenService.positionToMenu(screenContext); throw new PXException(errMess.Trim()); } else { if (errMess.Contains("SUPPLIER CODE ALREADY EXISTS")) { ScreenNameValueDTO[] fieldsMod = { new ScreenNameValueDTO(), new ScreenNameValueDTO(), new ScreenNameValueDTO() }; fieldsMod[0].fieldName = "OPTION1I"; fieldsMod[0].value = "2"; fieldsMod[1].fieldName = "SUPPLIER_NO1I"; fieldsMod[1].value = vendorAcctCD; fieldsMod[2].fieldName = "SUP_STATUS1I"; fieldsMod[2].value = string.Empty; submitRequest.screenFields = fieldsMod; submitRequest.screenKey = "1"; // OK screenReply = screenService.submit(screenContext, submitRequest); screenName = screenReply.mapName; errMess = screenReply.message; if (errMess.Trim() != "" && !errMess.Contains("SUPPLIER CODE ALREADY EXISTS")) { screenService.positionToMenu(screenContext); throw new PXException(errMess.Trim()); } } if (screenName == "MSM200B") { BAccount acctVendor = PXSelect <BAccount, Where <BAccount.bAccountID, Equal <Required <BAccount.bAccountID> > > > .Select(Base, vendor.BAccountID); Address vendorAddress = PXSelect <Address, Where <Address.bAccountID, Equal <Required <Address.bAccountID> > > > .Select(Base, vendor.BAccountID); Contact contact = PXSelect <Contact, Where <Contact.bAccountID, Equal <Required <Contact.bAccountID> > > > .Select(Base, vendor.BAccountID); String vendorCountry = ""; String addressLine1 = ""; String addressLine2 = ""; String addressLine3 = ""; string kota = string.Empty; string zipCode = string.Empty; String attn = ""; String email = ""; String phone = ""; if (vendorAddress != null) { vendorCountry = vendorAddress.CountryID.Trim(); addressLine1 = vendorAddress.AddressLine1.Trim(); addressLine2 = vendorAddress.AddressLine2 != null?vendorAddress.AddressLine2.Trim() : string.Empty; addressLine3 = vendorAddress.AddressLine3 != null?vendorAddress.AddressLine3.Trim() : string.Empty; kota = vendorAddress != null ? vendorAddress.City : string.Empty; zipCode = vendorAddress.PostalCode != null?vendorAddress.PostalCode.Trim() : string.Empty; } if (contact != null) { attn = contact.Salutation != null?contact.Salutation.Trim() : " "; email = contact.EMail != null?contact.EMail.Trim() : " "; phone = contact.Phone1 != null?contact.Phone1.Trim() : " "; } if (screenName == "MSM200B") { ScreenNameValueDTO[] fields200B = { new ScreenNameValueDTO(), new ScreenNameValueDTO(), new ScreenNameValueDTO(), new ScreenNameValueDTO(), new ScreenNameValueDTO(), new ScreenNameValueDTO(), new ScreenNameValueDTO(), new ScreenNameValueDTO(), new ScreenNameValueDTO() }; fields200B[0].fieldName = "SUPPLIER_NAME2I"; fields200B[0].value = vendorAcctName; fields200B[1].fieldName = "COUNTRY_CODE2I"; fields200B[1].value = vendorCountry; fields200B[2].fieldName = "ORDER_ADDR_12I"; fields200B[2].value = addressLine1; fields200B[3].fieldName = "ORDER_ADDR_22I"; fields200B[3].value = addressLine2; fields200B[4].fieldName = "ORDER_ADDR_32I"; fields200B[4].value = kota; fields200B[5].fieldName = "ORDER_CONTACT2I"; fields200B[5].value = attn; fields200B[6].fieldName = "ORDER_ZIP2I"; fields200B[6].value = zipCode; fields200B[7].fieldName = "ORDER_PHONE2I"; fields200B[7].value = phone; fields200B[8].fieldName = "ORDER_EMAIL_L12I"; fields200B[8].value = email; submitRequest.screenFields = fields200B; submitRequest.screenKey = "1"; // OK screenReply = screenService.submit(screenContext, submitRequest); screenName = screenReply.mapName.Trim(); errMess = screenReply.message; if (screenName == "MSM200F") { ScreenNameValueDTO[] fields200F = { new ScreenNameValueDTO(), new ScreenNameValueDTO(), new ScreenNameValueDTO(), new ScreenNameValueDTO(), new ScreenNameValueDTO(), new ScreenNameValueDTO(), new ScreenNameValueDTO() }; fields200F[0].fieldName = "PAYMENT_NAME6I"; fields200F[0].value = vendorAcctName; fields200F[1].fieldName = "PAYMENT_ADDR_16I"; fields200F[1].value = addressLine1; fields200F[2].fieldName = "PAYMENT_ADDR_26I"; fields200F[2].value = addressLine2; fields200F[3].fieldName = "PAYMENT_ADDR_36I"; fields200F[3].value = addressLine3; fields200F[4].fieldName = "PAYMENT_CTACT6I"; fields200F[4].value = attn; fields200F[5].fieldName = "PAYMENT_PHONE6I"; fields200F[5].value = phone; fields200F[6].fieldName = "PAYMENT_EMAIL_L16I"; fields200F[6].value = email; submitRequest.screenFields = fields200F; submitRequest.screenKey = "1"; // OK screenReply = screenService.submit(screenContext, submitRequest); screenName = screenReply.mapName.Trim(); errMess = screenReply.message; if (errMess.Trim() != "") { screenService.positionToMenu(screenContext); throw new PXException(errMess.Trim()); } } if (screenName == "MSM200D") { ScreenNameValueDTO[] fields200D = { new ScreenNameValueDTO(), new ScreenNameValueDTO(), new ScreenNameValueDTO(), new ScreenNameValueDTO(), new ScreenNameValueDTO(), new ScreenNameValueDTO(), new ScreenNameValueDTO() }; fields200D[0].fieldName = "RETURNS_NAME4I"; fields200D[0].value = vendorAcctName; fields200D[1].fieldName = "RETURNS_ADDR_14I"; fields200D[1].value = addressLine1; fields200D[2].fieldName = "RETURNS_ADDR_24I"; fields200D[2].value = addressLine2; fields200D[3].fieldName = "RETURNS_ADDR_34I"; fields200D[3].value = addressLine3; fields200D[4].fieldName = "RETURNS_CTACT4I"; fields200D[4].value = attn; fields200D[5].fieldName = "RETURNS_PHONE4I"; fields200D[5].value = phone; fields200D[6].fieldName = "RETURNS_EMAIL_L14I"; fields200D[6].value = email; submitRequest.screenFields = fields200D; submitRequest.screenKey = "1"; // OK screenReply = screenService.submit(screenContext, submitRequest); screenName = screenReply.mapName.Trim(); errMess = screenReply.message; if (errMess.Trim() != "") { screenService.positionToMenu(screenContext); throw new PXException(errMess.Trim()); } } if (screenName == "MSM20EA") { ScreenNameValueDTO[] fields20EA = { new ScreenNameValueDTO() }; fields20EA[0].fieldName = "COY_NAME1I"; fields20EA[0].value = ""; submitRequest.screenFields = fields20EA; submitRequest.screenKey = "1"; // OK screenReply = screenService.submit(screenContext, submitRequest); screenName = screenReply.mapName.Trim(); errMess = screenReply.message; if (errMess.Trim() != "") { screenService.positionToMenu(screenContext); throw new PXException(errMess.Trim()); } } if (screenName == "MSM200C") { ScreenNameValueDTO[] fields200C = { new ScreenNameValueDTO(), new ScreenNameValueDTO(), new ScreenNameValueDTO() }; fields200C[0].fieldName = "CLOSE_XMAS3I"; fields200C[0].value = "N"; fields200C[1].fieldName = "CURRENCY_TYPE3I"; fields200C[1].value = currencyType; fields200C[2].fieldName = "NO_ITEM_ORDER3I"; fields200C[2].value = "M"; submitRequest.screenFields = fields200C; submitRequest.screenKey = "1"; // OK screenReply = screenService.submit(screenContext, submitRequest); screenName = screenReply.mapName.Trim(); errMess = screenReply.message; if (errMess.Trim() != "") { screenService.positionToMenu(screenContext); throw new PXException(errMess.Trim()); } } if (screenName == "MSM200E") { ScreenNameValueDTO[] fields200E = { new ScreenNameValueDTO() }; fields200E[0].fieldName = "LEGAL_NAME_15I"; fields200E[0].value = ""; submitRequest.screenFields = fields200E; submitRequest.screenKey = "1"; // OK screenReply = screenService.submit(screenContext, submitRequest); screenName = screenReply.mapName.Trim(); errMess = screenReply.message; if (errMess.Trim() != "") { screenService.positionToMenu(screenContext); throw new PXException(errMess.Trim()); } } if (screenName == "MSM20DA") { ScreenNameValueDTO[] fields20DA = { new ScreenNameValueDTO(), new ScreenNameValueDTO(), new ScreenNameValueDTO(), new ScreenNameValueDTO(), new ScreenNameValueDTO(), new ScreenNameValueDTO(), new ScreenNameValueDTO() }; fields20DA[0].fieldName = "INV_STMT_IND1I"; fields20DA[0].value = "L"; fields20DA[1].fieldName = "NO_OF_DAYS_PAY1I"; fields20DA[1].value = "30"; fields20DA[2].fieldName = "ORDS_ALLOWED1I"; fields20DA[2].value = "Y"; fields20DA[3].fieldName = "MAX_ORD_ITEMS1I"; fields20DA[3].value = "999"; fields20DA[4].fieldName = "PAYMNT_ALLOWED1I"; fields20DA[4].value = "Y"; fields20DA[5].fieldName = "PAYMENT_METH1I"; fields20DA[5].value = "C"; fields20DA[6].fieldName = "RECON_REQUIRED1I"; fields20DA[6].value = "Y"; submitRequest.screenFields = fields20DA; submitRequest.screenKey = "1"; // OK screenReply = screenService.submit(screenContext, submitRequest); screenName = screenReply.mapName.Trim(); errMess = screenReply.message; if (errMess.Trim() != "") { screenService.positionToMenu(screenContext); throw new PXException(errMess.Trim()); } else { if (screenReply.functionKeys.Contains("XMIT-Confirm")) { submitRequest.screenKey = "1"; // OK screenReply = screenService.submit(screenContext, submitRequest); screenName = screenReply.mapName.Trim(); errMess = screenReply.message; if (errMess.Trim() != "") { screenService.positionToMenu(screenContext); throw new PXException(errMess.Trim()); } } } } if (screenName == "MSM20DB") { ScreenNameValueDTO[] fields20DB = { new ScreenNameValueDTO() }; fields20DB[0].fieldName = "ORDER_MEDIUM2I"; fields20DB[0].value = ""; submitRequest.screenFields = fields20DB; submitRequest.screenKey = "1"; // OK screenReply = screenService.submit(screenContext, submitRequest); screenName = screenReply.mapName.Trim(); errMess = screenReply.message; if (errMess.Trim() != "") { screenService.positionToMenu(screenContext); throw new PXException(errMess.Trim()); } } if (screenName == "MSM205A") { ScreenNameValueDTO[] fields205A = { new ScreenNameValueDTO() }; fields205A[0].fieldName = "DSTRCT_CODE1I"; fields205A[0].value = ""; submitRequest.screenFields = fields205A; submitRequest.screenKey = "1"; // OK screenReply = screenService.submit(screenContext, submitRequest); screenName = screenReply.mapName.Trim(); errMess = screenReply.message; if (errMess.Trim() != "") { screenService.positionToMenu(screenContext); throw new PXException(errMess.Trim()); } } if (screenName == "MSM205B") { ScreenNameValueDTO[] fields205B = { new ScreenNameValueDTO() }; fields205B[0].fieldName = "DSTRCT_CODE2I"; fields205B[0].value = ""; submitRequest.screenFields = fields205B; submitRequest.screenKey = "1"; // OK screenReply = screenService.submit(screenContext, submitRequest); screenName = screenReply.mapName.Trim(); errMess = screenReply.message; if (errMess.Trim() != "") { screenService.positionToMenu(screenContext); throw new PXException(errMess.Trim()); } } if (screenName == "MSM200A") { screenService.positionToMenu(screenContext); } } } } } catch (Exception ex) { throw new PXException(ex.Message); } return(null); }