public static void Updatestock_SymbolPermLong(stock_SymbolPermLong stock_SymbolPermLong)
{
try
{
stock_SymbolPermLongDAO stock_SymbolPermLongDAO = new stock_SymbolPermLongDAO();
stock_SymbolPermLongDAO.Updatestock_SymbolPermLong(stock_SymbolPermLong);
}
catch (ApplicationException)
{
throw;
}
catch (Exception ex)
{
// log this exception
log4net.Util.LogLog.Error(ex.Message, ex);
// wrap it and rethrow
throw new ApplicationException(SR.BusinessUpdatestock_SymbolPermLongException, ex);
}
}
public virtual stock_SymbolPermLong Createstock_SymbolPermLongFromReader(IDataReader reader)
{
stock_SymbolPermLong item = new stock_SymbolPermLong();
try
{
if (!reader.IsDBNull(reader.GetOrdinal("SymbolID"))) item.SymbolID = (int)reader["SymbolID"];
if (!reader.IsDBNull(reader.GetOrdinal("PermDate"))) item.PermDate = (DateTime)reader["PermDate"];
if (!reader.IsDBNull(reader.GetOrdinal("PriceOpen"))) item.PriceOpen = (double)reader["PriceOpen"];
if (!reader.IsDBNull(reader.GetOrdinal("PriceClose"))) item.PriceClose = (double)reader["PriceClose"];
if (!reader.IsDBNull(reader.GetOrdinal("PriceHigh"))) item.PriceHigh = (double)reader["PriceHigh"];
if (!reader.IsDBNull(reader.GetOrdinal("PriceLow"))) item.PriceLow = (double)reader["PriceLow"];
if (!reader.IsDBNull(reader.GetOrdinal("PriceAverage"))) item.PriceAverage = (double)reader["PriceAverage"];
if (!reader.IsDBNull(reader.GetOrdinal("PricePreviousClose"))) item.PricePreviousClose = (double)reader["PricePreviousClose"];
if (!reader.IsDBNull(reader.GetOrdinal("Volume"))) item.Volume = (double)reader["Volume"];
if (!reader.IsDBNull(reader.GetOrdinal("TotalTrade"))) item.TotalTrade = (double)reader["TotalTrade"];
if (!reader.IsDBNull(reader.GetOrdinal("TotalValue"))) item.TotalValue = (double)reader["TotalValue"];
if (!reader.IsDBNull(reader.GetOrdinal("AdjRatio"))) item.AdjRatio = (double)reader["AdjRatio"];
if (!reader.IsDBNull(reader.GetOrdinal("LastUpdated"))) item.LastUpdated = (DateTime)reader["LastUpdated"];
if (!reader.IsDBNull(reader.GetOrdinal("CurrentForeignRoom"))) item.CurrentForeignRoom = (double)reader["CurrentForeignRoom"];
if (!reader.IsDBNull(reader.GetOrdinal("BuyCount"))) item.BuyCount = (double)reader["BuyCount"];
if (!reader.IsDBNull(reader.GetOrdinal("BuyQuantity"))) item.BuyQuantity = (double)reader["BuyQuantity"];
if (!reader.IsDBNull(reader.GetOrdinal("SellCount"))) item.SellCount = (double)reader["SellCount"];
if (!reader.IsDBNull(reader.GetOrdinal("SellQuantity"))) item.SellQuantity = (double)reader["SellQuantity"];
if (!reader.IsDBNull(reader.GetOrdinal("BuyForeignCount"))) item.BuyForeignCount = (double)reader["BuyForeignCount"];
if (!reader.IsDBNull(reader.GetOrdinal("BuyForeignQuantity"))) item.BuyForeignQuantity = (double)reader["BuyForeignQuantity"];
if (!reader.IsDBNull(reader.GetOrdinal("BuyForeignValue"))) item.BuyForeignValue = (double)reader["BuyForeignValue"];
if (!reader.IsDBNull(reader.GetOrdinal("SellForeignCount"))) item.SellForeignCount = (double)reader["SellForeignCount"];
if (!reader.IsDBNull(reader.GetOrdinal("SellForeignQuantity"))) item.SellForeignQuantity = (double)reader["SellForeignQuantity"];
if (!reader.IsDBNull(reader.GetOrdinal("SellForeignValue"))) item.SellForeignValue = (double)reader["SellForeignValue"];
}
catch (Exception ex)
{
// log this exception
log4net.Util.LogLog.Error(ex.Message, ex);
// wrap it and rethrow
throw new ApplicationException(SR.DataAccessCreatestock_SymbolPermLongFromReaderException, ex);
}
return item;
}
private void saveSymbol()
{
this.paramater();
this.label1.InnerText = "";
this.label2.InnerText = "";
this.label3.InnerText = "";
this.label4.InnerText = "";
this.label5.InnerText = "";
this.label6.InnerText = "";
this.label7.InnerText = "";
if (this.SelectPermDate.Text == string.Empty)
{
this.label1.InnerText = Resources.UIResource.ErrorInfo;
return;
}
if (this.InputPriceOpen.Value == string.Empty)
{
this.label2.InnerText = Resources.UIResource.ErrorInfo;
return;
}
if (this.InputPriceClose.Value == string.Empty)
{
this.label3.InnerText = Resources.UIResource.ErrorInfo;
return;
}
if (this.InputPriceHight.Value == string.Empty)
{
this.label4.InnerText = Resources.UIResource.ErrorInfo;
return;
}
if (this.InputPriceLow.Value == string.Empty)
{
this.label5.InnerText = Resources.UIResource.ErrorInfo;
return;
}
if (this.InputVolume.Value == string.Empty)
{
this.label6.InnerText = Resources.UIResource.ErrorInfo;
return;
}
if (this.IsNumber(this.InputPriceOpen.Value) == false||
this.IsNumber(this.InputPriceClose.Value) == false||
this.IsNumber(this.InputPriceHight.Value) == false||
this.IsNumber(this.InputPriceLow.Value) == false||
this.IsNumber(this.InputVolume.Value) == false)
{
this.label7.InnerText = Resources.UIResource.TestInfo;
this.label7.Attributes["class"] = "inforError";
return;
}
stock_SymbolPermLong = stock_SymbolPermLongService.Getstock_SymbolPermLong(symbolId, ApplicationHelper.ConvertStringToDate(permDate));
if (stock_SymbolPermLong == null)
{
stock_SymbolPermLong = new stock_SymbolPermLong();
stock_SymbolPermLong = this.getValueSymobl(stock_SymbolPermLong);
stock_SymbolPermLongService.Createstock_SymbolPermLong(stock_SymbolPermLong);
}
else
{
stock_SymbolPermLong = this.getValueSymobl(stock_SymbolPermLong);
stock_SymbolPermLongService.Updatestock_SymbolPermLong(stock_SymbolPermLong);
}
this.label7.InnerText = Resources.UIResource.UpdateSeccess;
this.label7.Attributes["class"] = "inforSeccessful";
}
private stock_SymbolPermLong getValueSymobl(stock_SymbolPermLong sk_SymbolPermLong)
{
sk_SymbolPermLong.SymbolID = Convert.ToInt32(this.DropdownlistSelectSymbol.Value);
sk_SymbolPermLong.PermDate = ApplicationHelper.ConvertStringToDate(this.SelectPermDate.Text);
sk_SymbolPermLong.PriceOpen= Convert.ToInt64(this.InputPriceOpen.Value);
sk_SymbolPermLong.PriceClose = Convert.ToInt64(this.InputPriceClose.Value);
sk_SymbolPermLong.PriceHigh = Convert.ToInt64(this.InputPriceHight.Value);
sk_SymbolPermLong.PriceLow = Convert.ToInt64(this.InputPriceLow.Value);
sk_SymbolPermLong.PriceAverage = this.InputPriceAverage.Value == string.Empty ? 0 : Convert.ToInt64(this.InputPriceAverage.Value);
sk_SymbolPermLong.PricePreviousClose = this.InputPricePreviousClose.Value == string.Empty ? 0 : Convert.ToInt64(this.InputPricePreviousClose.Value);
sk_SymbolPermLong.Volume = Convert.ToInt64(this.InputVolume.Value);
sk_SymbolPermLong.TotalTrade = this.InputTotalTrade.Value == string.Empty ? 0 : Convert.ToInt64(this.InputTotalTrade.Value);
sk_SymbolPermLong.TotalValue = this.InputTotalValue.Value == string.Empty ? 0 : Convert.ToInt64(this.InputTotalValue.Value);
sk_SymbolPermLong.AdjRatio = this.InputAdjRatio.Value == string.Empty ? 0 : Convert.ToDouble(this.InputAdjRatio.Value);
sk_SymbolPermLong.LastUpdated = ApplicationHelper.ConvertStringToDate(this.SelectPermDate.Text);
//sk_SymbolPermLong.AdjRatio = this.InputAdjRatio.Value == string.Empty ? 0 : Convert.ToInt64(this.InputAdjRatio.Value);
sk_SymbolPermLong.CurrentForeignRoom = this.InputCurrentForeignRoom.Value == string.Empty ? 0 : Convert.ToInt64(this.InputCurrentForeignRoom.Value);
sk_SymbolPermLong.BuyCount = this.InputBuyCount.Value == string.Empty ? 0 : Convert.ToInt64(this.InputBuyCount.Value);
sk_SymbolPermLong.BuyQuantity = this.InputBuyQuantity.Value == string.Empty ? 0 : Convert.ToInt64(this.InputBuyQuantity.Value);
sk_SymbolPermLong.SellCount = this.InputSellCount.Value == string.Empty ? 0 : Convert.ToInt64(this.InputSellCount.Value);
sk_SymbolPermLong.SellQuantity = this.InputSellQuantity.Value == string.Empty ? 0 : Convert.ToInt64(this.InputSellQuantity.Value);
sk_SymbolPermLong.BuyForeignCount = this.InputBuyForeignCount.Value == string.Empty ? 0 : Convert.ToInt64(this.InputBuyForeignCount.Value);
sk_SymbolPermLong.BuyForeignQuantity = this.InputBuyForeignQuantity.Value == string.Empty ? 0 : Convert.ToInt64(this.InputBuyForeignQuantity.Value);
sk_SymbolPermLong.BuyForeignValue = this.InputBuyForeignValue.Value == string.Empty ? 0 : Convert.ToInt64(this.InputBuyForeignValue.Value);
sk_SymbolPermLong.SellForeignCount = this.InputSellForeignCount.Value == string.Empty ? 0 : Convert.ToInt64(this.InputSellForeignCount.Value);
sk_SymbolPermLong.SellForeignQuantity = this.InputSellForeignQuantity.Value == string.Empty ? 0 : Convert.ToInt64(this.InputSellForeignQuantity.Value);
sk_SymbolPermLong.SellForeignValue = this.InputSellForeignValue.Value == string.Empty ? 0 : Convert.ToInt64(this.InputSellForeignValue.Value);
return sk_SymbolPermLong;
}
public virtual void Createstock_SymbolPermLong(stock_SymbolPermLong stock_SymbolPermLong)
{
try
{
Database database = DatabaseFactory.CreateDatabase("DestinationConnection");
DbCommand dbCommand = database.GetStoredProcCommand("spstock_SymbolPermLongInsert");
database.AddInParameter(dbCommand, "@SymbolID", DbType.Int32, stock_SymbolPermLong.SymbolID);
database.AddInParameter(dbCommand, "@PermDate", DbType.DateTime, stock_SymbolPermLong.PermDate);
database.AddInParameter(dbCommand, "@PriceOpen", DbType.Double, stock_SymbolPermLong.PriceOpen);
database.AddInParameter(dbCommand, "@PriceClose", DbType.Double, stock_SymbolPermLong.PriceClose);
database.AddInParameter(dbCommand, "@PriceHigh", DbType.Double, stock_SymbolPermLong.PriceHigh);
database.AddInParameter(dbCommand, "@PriceLow", DbType.Double, stock_SymbolPermLong.PriceLow);
database.AddInParameter(dbCommand, "@PriceAverage", DbType.Double, stock_SymbolPermLong.PriceAverage);
database.AddInParameter(dbCommand, "@PricePreviousClose", DbType.Double, stock_SymbolPermLong.PricePreviousClose);
database.AddInParameter(dbCommand, "@Volume", DbType.Double, stock_SymbolPermLong.Volume);
database.AddInParameter(dbCommand, "@TotalTrade", DbType.Double, stock_SymbolPermLong.TotalTrade);
database.AddInParameter(dbCommand, "@TotalValue", DbType.Double, stock_SymbolPermLong.TotalValue);
database.AddInParameter(dbCommand, "@AdjRatio", DbType.Double, stock_SymbolPermLong.AdjRatio);
database.AddInParameter(dbCommand, "@LastUpdated", DbType.DateTime, stock_SymbolPermLong.LastUpdated);
database.AddInParameter(dbCommand, "@CurrentForeignRoom", DbType.Double, stock_SymbolPermLong.CurrentForeignRoom);
database.AddInParameter(dbCommand, "@BuyCount", DbType.Double, stock_SymbolPermLong.BuyCount);
database.AddInParameter(dbCommand, "@BuyQuantity", DbType.Double, stock_SymbolPermLong.BuyQuantity);
database.AddInParameter(dbCommand, "@SellCount", DbType.Double, stock_SymbolPermLong.SellCount);
database.AddInParameter(dbCommand, "@SellQuantity", DbType.Double, stock_SymbolPermLong.SellQuantity);
database.AddInParameter(dbCommand, "@BuyForeignCount", DbType.Double, stock_SymbolPermLong.BuyForeignCount);
database.AddInParameter(dbCommand, "@BuyForeignQuantity", DbType.Double, stock_SymbolPermLong.BuyForeignQuantity);
database.AddInParameter(dbCommand, "@BuyForeignValue", DbType.Double, stock_SymbolPermLong.BuyForeignValue);
database.AddInParameter(dbCommand, "@SellForeignCount", DbType.Double, stock_SymbolPermLong.SellForeignCount);
database.AddInParameter(dbCommand, "@SellForeignQuantity", DbType.Double, stock_SymbolPermLong.SellForeignQuantity);
database.AddInParameter(dbCommand, "@SellForeignValue", DbType.Double, stock_SymbolPermLong.SellForeignValue);
database.ExecuteNonQuery(dbCommand);
}
catch (Exception ex)
{
// log this exception
log4net.Util.LogLog.Error(ex.Message, ex);
// wrap it and rethrow
throw new ApplicationException(SR.DataAccessCreatestock_SymbolPermLongException, ex);
}
}
