public static bool InsertUpdateEFT(Models.EFTInfoDto eftInfo) { try { bool success = false; if (VendorEFTExists(eftInfo.Vendorid, eftInfo.Adrscode)) { success = UpdateEFT(eftInfo); } else { success = InsertEFT(eftInfo); } return(success); } catch (Exception ex) { throw ex; } }
public static bool UpdateEFT(Models.EFTInfoDto eftInfo) { string commandText = "UPDATE SY06000 SET "; commandText += "EFTUseMasterID = @EFTUseMasterID, EFTBankType = @EFTBankType, FRGNBANK = @FRGNBANK, "; commandText += "INACTIVE = @INACTIVE, BANKNAME = @BANKNAME, EFTBankAcct = @EFTBankAcct, EFTBankBranch = @EFTBankBranch, "; commandText += "GIROPostType = @GIROPostType, EFTBankCode = @EFTBankCode, EFTBankBranchCode = @EFTBankBranchCode, "; commandText += "EFTBankCheckDigit = @EFTBankCheckDigit, BSROLLNO = @BSROLLNO, IntlBankAcctNum = @IntlBankAcctNum, "; commandText += "SWIFTADDR = @SWIFTADDR, CustVendCountryCode = @CustVendCountryCode, DeliveryCountryCode = @DeliveryCountryCode, "; commandText += "BNKCTRCD = @BNKCTRCD, CBANKCD = @CBANKCD, ADDRESS1 = @ADDRESS1, ADDRESS2 = @ADDRESS2, ADDRESS3 = @ADDRESS3, "; commandText += "ADDRESS4 = @ADDRESS4, RegCode1 = @RegCode1, RegCode2 = @RegCode2, BankInfo7 = @BankInfo7, "; commandText += "EFTTransitRoutingNo = @EFTTransitRoutingNo, CURNCYID = @CURNCYID, EFTTransferMethod = @EFTTransferMethod, "; commandText += "EFTAccountType = @EFTAccountType "; // EFTPrenoteDate = @EFTPrenoteDate, EFTTerminationDate = @EFTTerminationDate "; commandText += "WHERE SERIES = 4 AND VENDORID = @VENDORID AND ADRSCODE = @ADRSCODE"; SqlParameter[] sqlParameters = new SqlParameter[31]; sqlParameters[0] = new SqlParameter("@VENDORID", SqlDbType.VarChar, 15); sqlParameters[0].Value = eftInfo.Vendorid; sqlParameters[1] = new SqlParameter("@ADRSCODE", SqlDbType.VarChar, 15); sqlParameters[1].Value = eftInfo.Adrscode; sqlParameters[2] = new SqlParameter("@EFTUseMasterID", SqlDbType.SmallInt); sqlParameters[2].Value = eftInfo.EftuseMasterId; sqlParameters[3] = new SqlParameter("@EFTBankType", SqlDbType.SmallInt); sqlParameters[3].Value = eftInfo.EftbankType; sqlParameters[4] = new SqlParameter("@FRGNBANK", SqlDbType.TinyInt); sqlParameters[4].Value = eftInfo.Frgnbank; sqlParameters[5] = new SqlParameter("@INACTIVE", SqlDbType.TinyInt); sqlParameters[5].Value = eftInfo.Inactive; sqlParameters[6] = new SqlParameter("@BANKNAME", SqlDbType.VarChar, 31); sqlParameters[6].Value = eftInfo.Bankname; sqlParameters[7] = new SqlParameter("@EFTBankAcct", SqlDbType.VarChar, 35); sqlParameters[7].Value = eftInfo.EftbankAcct; sqlParameters[8] = new SqlParameter("@EFTBankBranch", SqlDbType.VarChar, 15); sqlParameters[8].Value = eftInfo.EftbankBranch; sqlParameters[9] = new SqlParameter("@GIROPostType", SqlDbType.SmallInt); sqlParameters[9].Value = eftInfo.GiropostType; sqlParameters[10] = new SqlParameter("@EFTBankCode", SqlDbType.VarChar, 15); sqlParameters[10].Value = eftInfo.EftbankCode; sqlParameters[11] = new SqlParameter("@EFTBankBranchCode", SqlDbType.VarChar, 5); sqlParameters[11].Value = eftInfo.EftbankBranchCode; sqlParameters[12] = new SqlParameter("@EFTBankCheckDigit", SqlDbType.VarChar, 3); sqlParameters[12].Value = eftInfo.EftbankCheckDigit; sqlParameters[13] = new SqlParameter("@BSROLLNO", SqlDbType.VarChar, 31); sqlParameters[13].Value = eftInfo.Bsrollno; sqlParameters[14] = new SqlParameter("@IntlBankAcctNum", SqlDbType.VarChar, 35); sqlParameters[14].Value = eftInfo.IntlBankAcctNum; sqlParameters[15] = new SqlParameter("@SWIFTADDR", SqlDbType.VarChar, 11); sqlParameters[15].Value = eftInfo.Swiftaddr; sqlParameters[16] = new SqlParameter("@CustVendCountryCode", SqlDbType.VarChar, 3); sqlParameters[16].Value = eftInfo.CustVendCountryCode; sqlParameters[17] = new SqlParameter("@DeliveryCountryCode", SqlDbType.VarChar, 3); sqlParameters[17].Value = eftInfo.DeliveryCountryCode; sqlParameters[18] = new SqlParameter("@BNKCTRCD", SqlDbType.VarChar, 3); sqlParameters[18].Value = eftInfo.Bnkctrcd; sqlParameters[19] = new SqlParameter("@CBANKCD", SqlDbType.VarChar, 9); sqlParameters[19].Value = eftInfo.Cbankcd; sqlParameters[20] = new SqlParameter("@ADDRESS1", SqlDbType.VarChar, 61); sqlParameters[20].Value = eftInfo.Address1; sqlParameters[21] = new SqlParameter("@ADDRESS2", SqlDbType.VarChar, 61); sqlParameters[21].Value = eftInfo.Address2; sqlParameters[22] = new SqlParameter("@ADDRESS3", SqlDbType.VarChar, 61); sqlParameters[22].Value = eftInfo.Address3; sqlParameters[23] = new SqlParameter("@ADDRESS4", SqlDbType.VarChar, 61); sqlParameters[23].Value = eftInfo.Address4; sqlParameters[24] = new SqlParameter("@RegCode1", SqlDbType.VarChar, 31); sqlParameters[24].Value = eftInfo.RegCode1; sqlParameters[25] = new SqlParameter("@RegCode2", SqlDbType.VarChar, 31); sqlParameters[25].Value = eftInfo.RegCode2; sqlParameters[26] = new SqlParameter("@BankInfo7", SqlDbType.SmallInt); sqlParameters[26].Value = eftInfo.BankInfo7; sqlParameters[27] = new SqlParameter("@EFTTransitRoutingNo", SqlDbType.VarChar, 11); sqlParameters[27].Value = eftInfo.EfttransitRoutingNo; sqlParameters[28] = new SqlParameter("@CURNCYID", SqlDbType.VarChar, 15); sqlParameters[28].Value = eftInfo.Curncyid; sqlParameters[29] = new SqlParameter("@EFTTransferMethod", SqlDbType.SmallInt); sqlParameters[29].Value = eftInfo.EfttransferMethod; sqlParameters[30] = new SqlParameter("@EFTAccountType", SqlDbType.SmallInt); sqlParameters[30].Value = eftInfo.EftaccountType; //sqlParameters[31] = new SqlParameter("@EFTPrenoteDate", SqlDbType.DateTime); //sqlParameters[31].Value = eftInfo.EftprenoteDate; //sqlParameters[32] = new SqlParameter("@EFTTerminationDate", SqlDbType.DateTime); //sqlParameters[32].Value = eftInfo.EftterminationDate; int records = DataAccess.ExecuteNonQuery(APIController.Instance.APIModel.APIConfig.GPCompanyDB, CommandType.Text, commandText, sqlParameters); if (records == 1) { return(true); } else { return(false); } }
public static bool InsertEFT(Models.EFTInfoDto eftInfo) { string commandText = "zDP_SY06000SI"; SqlParameter[] sqlParameters = new SqlParameter[37]; sqlParameters[0] = new SqlParameter("@SERIES", SqlDbType.SmallInt); sqlParameters[0].Value = eftInfo.Series; sqlParameters[1] = new SqlParameter("@CustomerVendor_ID", SqlDbType.VarChar, 15); sqlParameters[1].Value = eftInfo.CustomerVendorId; sqlParameters[2] = new SqlParameter("@ADRSCODE", SqlDbType.VarChar, 15); sqlParameters[2].Value = eftInfo.Adrscode; sqlParameters[3] = new SqlParameter("@VENDORID", SqlDbType.VarChar, 15); sqlParameters[3].Value = eftInfo.Vendorid; sqlParameters[4] = new SqlParameter("@CUSTNMBR", SqlDbType.VarChar, 15); sqlParameters[4].Value = eftInfo.Custnmbr; sqlParameters[5] = new SqlParameter("@EFTUseMasterID", SqlDbType.SmallInt); sqlParameters[5].Value = eftInfo.EftuseMasterId; sqlParameters[6] = new SqlParameter("@EFTBankType", SqlDbType.SmallInt); sqlParameters[6].Value = eftInfo.EftbankType; sqlParameters[7] = new SqlParameter("@FRGNBANK", SqlDbType.TinyInt); sqlParameters[7].Value = eftInfo.Frgnbank; sqlParameters[8] = new SqlParameter("@INACTIVE", SqlDbType.TinyInt); sqlParameters[8].Value = eftInfo.Inactive; sqlParameters[9] = new SqlParameter("@BANKNAME", SqlDbType.VarChar, 31); sqlParameters[9].Value = eftInfo.Bankname; sqlParameters[10] = new SqlParameter("@EFTBankAcct", SqlDbType.VarChar, 35); sqlParameters[10].Value = eftInfo.EftbankAcct; sqlParameters[11] = new SqlParameter("@EFTBankBranch", SqlDbType.VarChar, 15); sqlParameters[11].Value = eftInfo.EftbankBranch; sqlParameters[12] = new SqlParameter("@GIROPostType", SqlDbType.SmallInt); sqlParameters[12].Value = eftInfo.GiropostType; sqlParameters[13] = new SqlParameter("@EFTBankCode", SqlDbType.VarChar, 15); sqlParameters[13].Value = eftInfo.EftbankCode; sqlParameters[14] = new SqlParameter("@EFTBankBranchCode", SqlDbType.VarChar, 5); sqlParameters[14].Value = eftInfo.EftbankBranchCode; sqlParameters[15] = new SqlParameter("@EFTBankCheckDigit", SqlDbType.VarChar, 3); sqlParameters[15].Value = eftInfo.EftbankCheckDigit; sqlParameters[16] = new SqlParameter("@BSROLLNO", SqlDbType.VarChar, 31); sqlParameters[16].Value = eftInfo.Bsrollno; sqlParameters[17] = new SqlParameter("@IntlBankAcctNum", SqlDbType.VarChar, 35); sqlParameters[17].Value = eftInfo.IntlBankAcctNum; sqlParameters[18] = new SqlParameter("@SWIFTADDR", SqlDbType.VarChar, 11); sqlParameters[18].Value = eftInfo.Swiftaddr; sqlParameters[19] = new SqlParameter("@CustVendCountryCode", SqlDbType.VarChar, 3); sqlParameters[19].Value = eftInfo.CustVendCountryCode; sqlParameters[20] = new SqlParameter("@DeliveryCountryCode", SqlDbType.VarChar, 3); sqlParameters[20].Value = eftInfo.DeliveryCountryCode; sqlParameters[21] = new SqlParameter("@BNKCTRCD", SqlDbType.VarChar, 3); sqlParameters[21].Value = eftInfo.Bnkctrcd; sqlParameters[22] = new SqlParameter("@CBANKCD", SqlDbType.VarChar, 9); sqlParameters[22].Value = eftInfo.Cbankcd; sqlParameters[23] = new SqlParameter("@ADDRESS1", SqlDbType.VarChar, 61); sqlParameters[23].Value = eftInfo.Address1; sqlParameters[24] = new SqlParameter("@ADDRESS2", SqlDbType.VarChar, 61); sqlParameters[24].Value = eftInfo.Address2; sqlParameters[25] = new SqlParameter("@ADDRESS3", SqlDbType.VarChar, 61); sqlParameters[25].Value = eftInfo.Address3; sqlParameters[26] = new SqlParameter("@ADDRESS4", SqlDbType.VarChar, 61); sqlParameters[26].Value = eftInfo.Address4; sqlParameters[27] = new SqlParameter("@RegCode1", SqlDbType.VarChar, 31); sqlParameters[27].Value = eftInfo.RegCode1; sqlParameters[28] = new SqlParameter("@RegCode2", SqlDbType.VarChar, 31); sqlParameters[28].Value = eftInfo.RegCode2; sqlParameters[29] = new SqlParameter("@BankInfo7", SqlDbType.SmallInt); sqlParameters[29].Value = eftInfo.BankInfo7; sqlParameters[30] = new SqlParameter("@EFTTransitRoutingNo", SqlDbType.VarChar, 11); sqlParameters[30].Value = eftInfo.EfttransitRoutingNo; sqlParameters[31] = new SqlParameter("@CURNCYID", SqlDbType.VarChar, 15); sqlParameters[31].Value = eftInfo.Curncyid; sqlParameters[32] = new SqlParameter("@EFTTransferMethod", SqlDbType.SmallInt); sqlParameters[32].Value = eftInfo.EfttransferMethod; sqlParameters[33] = new SqlParameter("@EFTAccountType", SqlDbType.SmallInt); sqlParameters[33].Value = eftInfo.EftaccountType; sqlParameters[34] = new SqlParameter("@EFTPrenoteDate", SqlDbType.DateTime); sqlParameters[34].Value = Convert.ToDateTime("1900-01-01"); sqlParameters[35] = new SqlParameter("@EFTTerminationDate", SqlDbType.DateTime); sqlParameters[35].Value = Convert.ToDateTime("1900-01-01"); sqlParameters[36] = new SqlParameter("@DEX_ROW_ID", SqlDbType.Int); sqlParameters[36].Direction = ParameterDirection.InputOutput; sqlParameters[36].Value = 0; // eftInfo.DexRowId; var paramsToReturn = new List <int>(); paramsToReturn.Add(36); List <string> returnParams = DataAccess.ExecuteProcWithOutput(APIController.Instance.APIModel.APIConfig.GPCompanyDB, CommandType.StoredProcedure, commandText, sqlParameters, paramsToReturn); if (Convert.ToInt32(returnParams[0]) > 0) { return(true); } else { return(false); } }