public long Post(Models.UserFavoriteSymbol value)
{
try
{
Data.TrnUserFavoritesSymbol newUserFavoriteSymbol = new Data.TrnUserFavoritesSymbol();
var symbols = from d in db.MstSymbols where d.Symbol == value.Symbol.ToUpper() select d;
if (symbols.Any())
{
newUserFavoriteSymbol.UserFavoritesId = value.UserFavoritesId;
newUserFavoriteSymbol.SymbolId = symbols.First().Id;
newUserFavoriteSymbol.Symbol = symbols.First().Symbol;
newUserFavoriteSymbol.Trend = value.Trend == null ? "SIDEWAYS" : value.Trend;
newUserFavoriteSymbol.EncodedDate = Convert.ToDateTime(value.EncodedDate);
db.TrnUserFavoritesSymbols.InsertOnSubmit(newUserFavoriteSymbol);
db.SubmitChanges();
return(newUserFavoriteSymbol.Id);
}
else
{
return(0);
}
}
catch
{
return(0);
}
}
public HttpResponseMessage GetUserFavoriteSymbolUpload(String Id, [FromUri] List <String> Symbols)
{
Id = Id.Replace(",", "");
int userFavoritesId = Convert.ToInt32(Id);
try
{
if (userFavoritesId > 0)
{
for (int i = 0; i < Symbols.Count; i++)
{
Data.TrnUserFavoritesSymbol newUserFavoriteSymbol = new Data.TrnUserFavoritesSymbol();
var symbols = from d in db.MstSymbols where d.Symbol == Symbols[i].ToUpper() select d;
if (symbols.Any())
{
newUserFavoriteSymbol.UserFavoritesId = userFavoritesId;
newUserFavoriteSymbol.SymbolId = symbols.First().Id;
newUserFavoriteSymbol.Symbol = symbols.First().Symbol;
newUserFavoriteSymbol.Trend = "SIDEWAYS";
//DateTime dt = new DateTime();
//SqlDateTime EncodedDate = new SqlDateTime(new DateTime(dt.Year, dt.Month, dt.Day));
//newUserFavoriteSymbol.EncodedDate = EncodedDate.Value;
db.TrnUserFavoritesSymbols.InsertOnSubmit(newUserFavoriteSymbol);
db.SubmitChanges();
}
}
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
}
catch
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
public HttpResponseMessage Delete(int Id)
{
Data.TrnUserFavoritesSymbol deleteUserFavoriteSymbol = db.TrnUserFavoritesSymbols.Where(d => d.Id == Id).First();
if (deleteUserFavoriteSymbol != null)
{
db.TrnUserFavoritesSymbols.DeleteOnSubmit(deleteUserFavoriteSymbol);
try
{
db.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
catch
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
}
