public bool AddScriptData(List <StockCall> calls)
{
using (StockMasterEntities et = new StockMasterEntities())
{
foreach (var call in calls)
{
et.ScriptDatas.Add(new ScriptData
{
Code = call.Stock,
tDate = call.Date,
tOpen = call.Open,
tHigh = call.High,
tLow = call.Low,
tClose = call.Close,
Volume = Convert.ToInt64(call.Volume),
EMA9 = call.EMA9,
EMA21 = call.EMA21,
tCall = call.Call,
tStatus = "Initial",
tEntry = 0,
tExit = 0,
LotSize = 0
});
}
et.SaveChangesAsync();
}
return(true);
}
public List <StockCall> GetScriptCalls(string script)
{
List <StockCall> calls = new List <StockCall>();
using (StockMasterEntities et = new StockMasterEntities())
{
foreach (var call in et.ScriptDatas.Where(s => s.Code == script && (s.tCall == "BUY" || s.tCall == "SELL")).OrderByDescending(t => t.tDate))
{
calls.Add(new StockCall
{
Stock = call.Code,
Date = call.tDate,
Open = call.tOpen,
High = call.tHigh,
Low = call.tLow,
Close = call.tClose,
Volume = Convert.ToDecimal(call.Volume),
EMA9 = call.EMA9,
EMA21 = call.EMA21,
Call = call.tCall,
Status = call.tStatus,
Entry = call.tEntry,
Exit = call.tExit,
LotSize = call.LotSize
});
}
}
return(calls);
}