public int Post(Models.Favorite value)
{
try
{
Data.TrnFavorite NewFavorite = new Data.TrnFavorite();
var userId = (from d in db.MstUsers where d.UserName.Equals(value.User) select d).FirstOrDefault().Id;
var symbolId = (from d in db.MstSymbols where d.Symbol.Equals(value.Symbol) select d).FirstOrDefault().Id;
bool isShared = false;
var data = from d in db.TrnFavorites
where d.UserId == userId && d.Remarks.Equals(value.Remarks)
select d;
if (data.Any())
{
isShared = data.First().IsShared;
}
DateTime dt = Convert.ToDateTime(value.EncodedDate);
SqlDateTime EncodedDate = new SqlDateTime(new DateTime(dt.Year, dt.Month, dt.Day));
NewFavorite.SymbolId = symbolId;
NewFavorite.Symbol = value.Symbol;
NewFavorite.Remarks = value.Remarks;
NewFavorite.EncodedDate = EncodedDate.Value;
NewFavorite.Trend = value.Trend;
NewFavorite.UserId = userId;
NewFavorite.IsShared = isShared;
db.TrnFavorites.InsertOnSubmit(NewFavorite);
db.SubmitChanges();
return(NewFavorite.Id);
}
catch
{
return(0);
}
}
public HttpResponseMessage Delete(int Id)
{
Data.TrnFavorite DeleteFavorite = db.TrnFavorites.Where(d => d.Id == Id).First();
if (DeleteFavorite != null)
{
db.TrnFavorites.DeleteOnSubmit(DeleteFavorite);
try
{
db.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
catch
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
}
public long GetUploadFavorites([FromUri] List <String> Symbols)
{
string currentUserName = User.Identity.Name;
int userId = 0;
long returnId = 0;
try
{
userId = (from d in db.MstUsers where d.UserName.Equals(currentUserName) select d).FirstOrDefault().Id;
var countFavorites = (from d in db.TrnFavorites where d.UserId == userId select d).Count();
DateTime now = DateTime.Now;
string uploadDate = now.ToString("yyyy-MM-dd");
bool isShared = false;
var data = from d in db.TrnFavorites
where d.UserId == userId && d.Remarks.Equals("UPLOADED-" + uploadDate)
select d;
if (data.Any())
{
isShared = data.First().IsShared;
}
for (int i = 0; i < Symbols.Count; i++)
{
Data.TrnFavorite NewFavorite = new Data.TrnFavorite();
var symbolId = from d in db.MstSymbols where d.Symbol.Equals(Symbols[i].Trim()) select d;
if (symbolId.Any())
{
DateTime d = DateTime.Now;
SqlDateTime EncodedDate = new SqlDateTime(new DateTime(d.Year, d.Month, d.Day));
NewFavorite.SymbolId = symbolId.FirstOrDefault().Id;
NewFavorite.Symbol = Symbols[i].ToUpper();
NewFavorite.Remarks = "UPLOADED-" + uploadDate;
NewFavorite.EncodedDate = EncodedDate.Value;
NewFavorite.Trend = "SIDEWAYS";
NewFavorite.UserId = userId;
NewFavorite.IsShared = isShared;
db.TrnFavorites.InsertOnSubmit(NewFavorite);
db.SubmitChanges();
returnId = NewFavorite.Id;
}
if (currentUserName.ToUpper() != "DPILGER")
{
if (i > 450 - countFavorites)
{
break;
}
}
}
}
catch
{
}
return(returnId);
}