public int Post(Models.UserFavorite value)
{
try
{
Data.TrnUserFavorite newUserFavorite = new Data.TrnUserFavorite();
var userId = (from d in db.MstUsers where d.UserName.Equals(value.User) select d).FirstOrDefault().Id;
bool isShared = false;
DateTime dt = Convert.ToDateTime(value.EncodedDate);
SqlDateTime EncodedDate = new SqlDateTime(new DateTime(dt.Year, dt.Month, dt.Day));
newUserFavorite.UserId = userId;
newUserFavorite.Description = value.Description;
newUserFavorite.IsShared = isShared;
newUserFavorite.EncodedDate = EncodedDate.Value;
db.TrnUserFavorites.InsertOnSubmit(newUserFavorite);
db.SubmitChanges();
return(newUserFavorite.Id);
}
catch
{
return(0);
}
}
public HttpResponseMessage Delete(int Id)
{
Data.TrnUserFavorite deleteUserFavorite = db.TrnUserFavorites.Where(d => d.Id == Id).First();
if (deleteUserFavorite != null)
{
var userFavoritesSymbols = from d in db.TrnUserFavoritesSymbols where d.UserFavoritesId == deleteUserFavorite.Id select d;
if (userFavoritesSymbols.Any())
{
foreach (Data.TrnUserFavoritesSymbol s in userFavoritesSymbols)
{
db.TrnUserFavoritesSymbols.DeleteOnSubmit(s);
}
try
{
db.SubmitChanges();
}
catch
{
// Do nothing.
}
}
db.TrnUserFavorites.DeleteOnSubmit(deleteUserFavorite);
try
{
db.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
catch
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
}
