public void Update(BOL_EDI_CANDIDATE oEDI_CANDIDATE, string CURRENT_DATETIME, string CURRENT_USER, out String strMsg) { ConnectionMaster oMaster = new ConnectionMaster(strConnectionString, strUpdate); oMaster.crudCommand.Parameters.Add(new SqlParameter("@EDI_ACCOUNT", oEDI_CANDIDATE.EDI_ACCOUNT)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@USED_FLG", oEDI_CANDIDATE.USED_FLG)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@CURRENT_USER", CURRENT_USER)); oMaster.crudCommand.Parameters.Add(new SqlParameter("@CURRENT_DATETIME", CURRENT_DATETIME)); oMaster.ExcuteQuery(2, out strMsg); }
private BOL_EDI_CANDIDATE GetEDI_CANDIDATE(USAGE_INFO_REGISTRATION oUSAGE_INFO_REG) { BOL_EDI_CANDIDATE oEDI_CANDIDATE = new BOL_EDI_CANDIDATE(); oEDI_CANDIDATE.EDI_ACCOUNT = oUSAGE_INFO_REG.EDI_ACCOUNT; oEDI_CANDIDATE.USED_FLG = "*"; oEDI_CANDIDATE.CREATED_BY = oUSAGE_INFO_REG.UPDATED_BY; oEDI_CANDIDATE.UPDATED_BY = oUSAGE_INFO_REG.UPDATED_BY; return(oEDI_CANDIDATE); }
private void HandleInsert(USAGE_INFO_REGISTRATION oUSAGE_INFO_REG, string OPERATION, DataRow row) { string strMsg = ""; //Search in EDI_CANDICATE BOL_EDI_CANDIDATE oEDI_CANDIDATE = new BOL_EDI_CANDIDATE(); EDI_CANDIDATE DAL_EDI_CANDICATE = new EDI_CANDIDATE(con); DataTable dtUseFLG = DAL_EDI_CANDICATE.GetUseFLG(oUSAGE_INFO_REG.EDI_ACCOUNT, out strMsg); using (TransactionScope dbTxn = new TransactionScope()) { //Prepare EDI CANDIDATE oEDI_CANDIDATE = GetEDI_CANDIDATE(oUSAGE_INFO_REG); if (dtUseFLG.Rows.Count == 0) { //Insert AS USED DAL_EDI_CANDICATE.Insert(oEDI_CANDIDATE, CURRENT_DATETIME, CURRENT_USER, out strMsg); } else { if (dtUseFLG.Rows[0]["USED_FLG"].ToString() == "*") //if record is already used { ResponseUtility.ReturnFailMessage(row, Utility.Messages.Jimugo.E000WB013); return; } else { //set used flage oEDI_CANDIDATE.USED_FLG = "*"; //Update as USED DAL_EDI_CANDICATE.Update(oEDI_CANDIDATE, CURRENT_DATETIME, CURRENT_USER, out strMsg); } } EDI_ACCOUNT DAL_EDI_ACCOUNT = new EDI_ACCOUNT(con); BOL_EDI_ACCOUNT oEDI_ACCOUNT = GetEDI_ACCOUNT(oUSAGE_INFO_REG); if (DAL_EDI_ACCOUNT.IsCompanyNoBoxAlreadyRegistered(oEDI_ACCOUNT.COMPANY_NO_BOX, out strMsg)) { ResponseUtility.ReturnFailMessage(row, String.Format(Utility.Messages.Jimugo.E000ZZ038, "会社番号+BOX")); return; } if (DAL_EDI_ACCOUNT.IsEDIAccountAlreadyRegistered(oEDI_ACCOUNT.EDI_ACCOUNT, out strMsg)) { ResponseUtility.ReturnFailMessage(row, String.Format(Utility.Messages.Jimugo.E000ZZ038, "EDIアカウント")); return; } DAL_EDI_ACCOUNT.Insert(oEDI_ACCOUNT, CURRENT_DATETIME, CURRENT_USER, out strMsg); #region ASSIGN_MK_VALUE_AND_MESSAGES if (String.IsNullOrEmpty(strMsg)) //success { dbTxn.Complete(); ResponseUtility.ReturnSuccessMessage(row, UPDATED_AT_DATETIME, CURRENT_DATETIME, CURRENT_USER); } else //failed { ResponseUtility.ReturnFailMessage(row); } } #endregion }