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)); } }