public static void SetShareValue(int corpID, DateTime date, decimal value) { EMMADataSet.ShareValueHistoryDataTable table = new EMMADataSet.ShareValueHistoryDataTable(); EMMADataSet.ShareValueHistoryRow rowData = null; lock (tableAdapter) { tableAdapter.FillByDate(table, corpID, date); } if (table.Count > 0) { if (date.CompareTo(table[0].DateTime) == 0) { rowData = table[0]; } } if (rowData == null) { rowData = table.NewShareValueHistoryRow(); rowData.PublicCorpID = corpID; rowData.DateTime = date; rowData.ShareValue = 0; table.AddShareValueHistoryRow(rowData); } rowData.ShareValue = value; lock (tableAdapter) { tableAdapter.Update(table); } }
public static EMMADataSet.ShareValueHistoryDataTable GetValueHistory(int corpID) { EMMADataSet.ShareValueHistoryDataTable table = new EMMADataSet.ShareValueHistoryDataTable(); lock (tableAdapter) { tableAdapter.FillByCorp(table, corpID); } return table; }
public static decimal GetShareValue(int corpID, DateTime date) { decimal retVal = 0; EMMADataSet.ShareValueHistoryDataTable table = new EMMADataSet.ShareValueHistoryDataTable(); lock (tableAdapter) { tableAdapter.FillByDate(table, corpID, date); } if (table.Count > 0) { retVal = table[0].ShareValue; } else { retVal = PublicCorps.GetCorp(corpID).ShareValue; } return retVal; }
public static void DeleteEntry(int corpID, DateTime date) { EMMADataSet.ShareValueHistoryDataTable table = new EMMADataSet.ShareValueHistoryDataTable(); lock (tableAdapter) { tableAdapter.FillByDate(table, corpID, date); } if (table.Count > 0) { if (date.CompareTo(table[0].DateTime) == 0) { table[0].Delete(); lock (tableAdapter) { tableAdapter.Update(table); } } } }