// Returns null if no record corresponds to itemID; public static EbaySellerInfoType GetOneSellerInfo(String sellerName) { if (sellerName == null || sellerName.Trim() == "") { return(null); } String sql_getOneSellerInfo = String.Format("select * from [SellerInfo] where SellerName='{0}'", sellerName); DataTable dt = DataFactory.ExecuteSqlReturnTable(sql_getOneSellerInfo); if (dt.Rows.Count == 0) { return(null); } DataRow dr = dt.Rows[0]; EbaySellerInfoType sellerInfo = new EbaySellerInfoType(); sellerInfo.SellerInfoId = StringUtil.GetSafeInt(dr["SellerInfoId"]); sellerInfo.SellerName = sellerName; sellerInfo.AmountLimitRemaining = StringUtil.GetSafeDouble(dr["AmountLimitRemaining"]); sellerInfo.AmountLimitRemainingCurrencyID = StringUtil.GetSafeString(dr["AmountLimitRemainingCurrencyID"]); sellerInfo.AuctionBidCount = StringUtil.GetSafeInt(dr["AuctionBidCount"]); sellerInfo.AuctionSellingCount = StringUtil.GetSafeInt(dr["AuctionSellingCount"]); sellerInfo.QuantityLimitRemaining = StringUtil.GetSafeInt(dr["QuantityLimitRemaining"]); sellerInfo.SoldDurationInDays = StringUtil.GetSafeInt(dr["SoldDurationInDays"]); sellerInfo.TotalSoldCount = StringUtil.GetSafeInt(dr["TotalSoldCount"]); sellerInfo.TotalSoldValue = StringUtil.GetSafeDouble(dr["TotalSoldValue"]); sellerInfo.TotalSoldValueCurrencyID = StringUtil.GetSafeString(dr["TotalSoldValueCurrencyID"]); sellerInfo.AccountState = StringUtil.GetSafeString(dr["AccountState"]); sellerInfo.BankAccountInfo = StringUtil.GetSafeString(dr["BankAccountInfo"]); sellerInfo.CurrentBalance = StringUtil.GetSafeDouble(dr["CurrentBalance"]); sellerInfo.InvoiceBalance = StringUtil.GetSafeDouble(dr["InvoiceBalance"]); sellerInfo.InvoiceNewFee = StringUtil.GetSafeDouble(dr["InvoiceNewFee"]); sellerInfo.InvoicePayment = StringUtil.GetSafeDouble(dr["InvoicePayment"]); sellerInfo.LastAmountPaid = StringUtil.GetSafeDouble(dr["LastAmountPaid"]); return(sellerInfo); } // GetOneSellerInfo
// Returns null if no record corresponds to itemID; public static EbaySellerInfoType GetOneSellerInfo(String sellerName) { if (sellerName == null || sellerName.Trim() == "") return null; String sql_getOneSellerInfo = String.Format("select * from [SellerInfo] where SellerName='{0}'", sellerName); DataTable dt = DataFactory.ExecuteSqlReturnTable(sql_getOneSellerInfo); if (dt.Rows.Count == 0) return null; DataRow dr = dt.Rows[0]; EbaySellerInfoType sellerInfo = new EbaySellerInfoType(); sellerInfo.SellerInfoId = StringUtil.GetSafeInt(dr["SellerInfoId"]); sellerInfo.SellerName = sellerName; sellerInfo.AmountLimitRemaining = StringUtil.GetSafeDouble(dr["AmountLimitRemaining"]); sellerInfo.AmountLimitRemainingCurrencyID = StringUtil.GetSafeString(dr["AmountLimitRemainingCurrencyID"]); sellerInfo.AuctionBidCount = StringUtil.GetSafeInt(dr["AuctionBidCount"]); sellerInfo.AuctionSellingCount = StringUtil.GetSafeInt(dr["AuctionSellingCount"]); sellerInfo.QuantityLimitRemaining = StringUtil.GetSafeInt(dr["QuantityLimitRemaining"]); sellerInfo.SoldDurationInDays = StringUtil.GetSafeInt(dr["SoldDurationInDays"]); sellerInfo.TotalSoldCount = StringUtil.GetSafeInt(dr["TotalSoldCount"]); sellerInfo.TotalSoldValue = StringUtil.GetSafeDouble(dr["TotalSoldValue"]); sellerInfo.TotalSoldValueCurrencyID = StringUtil.GetSafeString(dr["TotalSoldValueCurrencyID"]); sellerInfo.AccountState = StringUtil.GetSafeString(dr["AccountState"]); sellerInfo.BankAccountInfo = StringUtil.GetSafeString(dr["BankAccountInfo"]); sellerInfo.CurrentBalance = StringUtil.GetSafeDouble(dr["CurrentBalance"]); sellerInfo.InvoiceBalance = StringUtil.GetSafeDouble(dr["InvoiceBalance"]); sellerInfo.InvoiceNewFee = StringUtil.GetSafeDouble(dr["InvoiceNewFee"]); sellerInfo.InvoicePayment = StringUtil.GetSafeDouble(dr["InvoicePayment"]); sellerInfo.LastAmountPaid = StringUtil.GetSafeDouble(dr["LastAmountPaid"]); return sellerInfo; }
public static bool InsertOneSellerInfo(EbaySellerInfoType sellerInfo) { EbaySellerInfoType existedSellerInfo = GetOneSellerInfo(sellerInfo.SellerName); if (existedSellerInfo != null) { Logger.WriteSystemLog(string.Format("Seller info with seller name={0} alreay exists.", sellerInfo.SellerName)); return false; } IDbCommand cmd = DataFactory.CreateCommand(null); cmd.CommandText = @"insert into [SellerInfo] (SellerName, AmountLimitRemaining, AmountLimitRemainingCurrencyID," + "AuctionBidCount, AuctionSellingCount, QuantityLimitRemaining, SoldDurationInDays, TotalSoldCount," + "TotalSoldValue, TotalSoldValueCurrencyID, AccountState, BankAccountInfo, CurrentBalance, InvoiceBalance," + "InvoiceNewFee, InvoicePayment, LastAmountPaid) values (" + "@SellerName, @AmountLimitRemaining, @AmountLimitRemainingCurrencyID," + "@AuctionBidCount, @AuctionSellingCount, @QuantityLimitRemaining, @SoldDurationInDays, @TotalSoldCount," + "@TotalSoldValue, @TotalSoldValueCurrencyID, @AccountState, @BankAccountInfo, @CurrentBalance, @InvoiceBalance," + "@InvoiceNewFee, @InvoicePayment, @LastAmountPaid)"; DataFactory.AddCommandParam(cmd, "@SellerName", DbType.String, StringUtil.GetSafeString(sellerInfo.SellerName)); DataFactory.AddCommandParam(cmd, "@AmountLimitRemaining", DbType.Double, StringUtil.GetSafeDouble(sellerInfo.AmountLimitRemaining)); DataFactory.AddCommandParam(cmd, "@AmountLimitRemainingCurrencyID", DbType.String, StringUtil.GetSafeString(sellerInfo.AmountLimitRemainingCurrencyID)); DataFactory.AddCommandParam(cmd, "@AuctionBidCount", DbType.Int32, StringUtil.GetSafeInt(sellerInfo.AuctionBidCount)); DataFactory.AddCommandParam(cmd, "@AuctionSellingCount", DbType.Int32, StringUtil.GetSafeInt(sellerInfo.AuctionSellingCount)); DataFactory.AddCommandParam(cmd, "@QuantityLimitRemaining", DbType.Int32, StringUtil.GetSafeInt(sellerInfo.QuantityLimitRemaining)); DataFactory.AddCommandParam(cmd, "@SoldDurationInDays", DbType.Int32, StringUtil.GetSafeInt(sellerInfo.SoldDurationInDays)); DataFactory.AddCommandParam(cmd, "@TotalSoldCount", DbType.Int32, StringUtil.GetSafeInt(sellerInfo.TotalSoldCount)); DataFactory.AddCommandParam(cmd, "@TotalSoldValue", DbType.Double, StringUtil.GetSafeDouble(sellerInfo.TotalSoldValue)); DataFactory.AddCommandParam(cmd, "@TotalSoldValueCurrencyID", DbType.String, StringUtil.GetSafeString(sellerInfo.TotalSoldValueCurrencyID)); DataFactory.AddCommandParam(cmd, "@AccountState", DbType.String, StringUtil.GetSafeString(sellerInfo.AccountState)); DataFactory.AddCommandParam(cmd, "@BankAccountInfo", DbType.String, StringUtil.GetSafeString(sellerInfo.BankAccountInfo)); DataFactory.AddCommandParam(cmd, "@CurrentBalance", DbType.Double, StringUtil.GetSafeDouble(sellerInfo.CurrentBalance)); DataFactory.AddCommandParam(cmd, "@InvoiceBalance", DbType.Double, StringUtil.GetSafeDouble(sellerInfo.InvoiceBalance)); DataFactory.AddCommandParam(cmd, "@InvoiceNewFee", DbType.Double, StringUtil.GetSafeDouble(sellerInfo.InvoiceNewFee)); DataFactory.AddCommandParam(cmd, "@InvoicePayment", DbType.Double, StringUtil.GetSafeDouble(sellerInfo.InvoicePayment)); DataFactory.AddCommandParam(cmd, "@LastAmountPaid", DbType.Double, StringUtil.GetSafeDouble(sellerInfo.LastAmountPaid)); bool result = false; int newItemId = 0; try { if (DataFactory.DbConnection.State == ConnectionState.Closed) DataFactory.DbConnection.Open(); cmd.ExecuteNonQuery(); IDbCommand cmdNewID = DataFactory.CreateCommand("SELECT @@IDENTITY"); // Retrieve the Auto number and store it in the CategoryID column. object obj = cmdNewID.ExecuteScalar(); Int32.TryParse(obj.ToString(), out newItemId); result = newItemId > 0; } catch (DataException ex) { // Write to log here. Logger.WriteSystemLog(string.Format("Error inserting new seller info, seller name={0}, errorMsg={1}", sellerInfo.SellerName, ex.Message)); result = false; } finally { if (DataFactory.DbConnection.State == ConnectionState.Open) DataFactory.DbConnection.Close(); } return result; }
} // GetOneSellerInfo public static bool InsertOneSellerInfo(EbaySellerInfoType sellerInfo) { EbaySellerInfoType existedSellerInfo = GetOneSellerInfo(sellerInfo.SellerName); if (existedSellerInfo != null) { Logger.WriteSystemLog(string.Format("Seller info with seller name={0} alreay exists.", sellerInfo.SellerName)); return(false); } IDbCommand cmd = DataFactory.CreateCommand(null); cmd.CommandText = @"insert into [SellerInfo] (SellerName, AmountLimitRemaining, AmountLimitRemainingCurrencyID," + "AuctionBidCount, AuctionSellingCount, QuantityLimitRemaining, SoldDurationInDays, TotalSoldCount," + "TotalSoldValue, TotalSoldValueCurrencyID, AccountState, BankAccountInfo, CurrentBalance, InvoiceBalance," + "InvoiceNewFee, InvoicePayment, LastAmountPaid) values (" + "@SellerName, @AmountLimitRemaining, @AmountLimitRemainingCurrencyID," + "@AuctionBidCount, @AuctionSellingCount, @QuantityLimitRemaining, @SoldDurationInDays, @TotalSoldCount," + "@TotalSoldValue, @TotalSoldValueCurrencyID, @AccountState, @BankAccountInfo, @CurrentBalance, @InvoiceBalance," + "@InvoiceNewFee, @InvoicePayment, @LastAmountPaid)"; DataFactory.AddCommandParam(cmd, "@SellerName", DbType.String, StringUtil.GetSafeString(sellerInfo.SellerName)); DataFactory.AddCommandParam(cmd, "@AmountLimitRemaining", DbType.Double, StringUtil.GetSafeDouble(sellerInfo.AmountLimitRemaining)); DataFactory.AddCommandParam(cmd, "@AmountLimitRemainingCurrencyID", DbType.String, StringUtil.GetSafeString(sellerInfo.AmountLimitRemainingCurrencyID)); DataFactory.AddCommandParam(cmd, "@AuctionBidCount", DbType.Int32, StringUtil.GetSafeInt(sellerInfo.AuctionBidCount)); DataFactory.AddCommandParam(cmd, "@AuctionSellingCount", DbType.Int32, StringUtil.GetSafeInt(sellerInfo.AuctionSellingCount)); DataFactory.AddCommandParam(cmd, "@QuantityLimitRemaining", DbType.Int32, StringUtil.GetSafeInt(sellerInfo.QuantityLimitRemaining)); DataFactory.AddCommandParam(cmd, "@SoldDurationInDays", DbType.Int32, StringUtil.GetSafeInt(sellerInfo.SoldDurationInDays)); DataFactory.AddCommandParam(cmd, "@TotalSoldCount", DbType.Int32, StringUtil.GetSafeInt(sellerInfo.TotalSoldCount)); DataFactory.AddCommandParam(cmd, "@TotalSoldValue", DbType.Double, StringUtil.GetSafeDouble(sellerInfo.TotalSoldValue)); DataFactory.AddCommandParam(cmd, "@TotalSoldValueCurrencyID", DbType.String, StringUtil.GetSafeString(sellerInfo.TotalSoldValueCurrencyID)); DataFactory.AddCommandParam(cmd, "@AccountState", DbType.String, StringUtil.GetSafeString(sellerInfo.AccountState)); DataFactory.AddCommandParam(cmd, "@BankAccountInfo", DbType.String, StringUtil.GetSafeString(sellerInfo.BankAccountInfo)); DataFactory.AddCommandParam(cmd, "@CurrentBalance", DbType.Double, StringUtil.GetSafeDouble(sellerInfo.CurrentBalance)); DataFactory.AddCommandParam(cmd, "@InvoiceBalance", DbType.Double, StringUtil.GetSafeDouble(sellerInfo.InvoiceBalance)); DataFactory.AddCommandParam(cmd, "@InvoiceNewFee", DbType.Double, StringUtil.GetSafeDouble(sellerInfo.InvoiceNewFee)); DataFactory.AddCommandParam(cmd, "@InvoicePayment", DbType.Double, StringUtil.GetSafeDouble(sellerInfo.InvoicePayment)); DataFactory.AddCommandParam(cmd, "@LastAmountPaid", DbType.Double, StringUtil.GetSafeDouble(sellerInfo.LastAmountPaid)); bool result = false; int newItemId = 0; try { if (DataFactory.DbConnection.State == ConnectionState.Closed) { DataFactory.DbConnection.Open(); } cmd.ExecuteNonQuery(); IDbCommand cmdNewID = DataFactory.CreateCommand("SELECT @@IDENTITY"); // Retrieve the Auto number and store it in the CategoryID column. object obj = cmdNewID.ExecuteScalar(); Int32.TryParse(obj.ToString(), out newItemId); result = newItemId > 0; } catch (DataException ex) { // Write to log here. Logger.WriteSystemLog(string.Format("Error inserting new seller info, seller name={0}, errorMsg={1}", sellerInfo.SellerName, ex.Message)); result = false; } finally { if (DataFactory.DbConnection.State == ConnectionState.Open) { DataFactory.DbConnection.Close(); } } return(result); } // InsertOneSellerInfo