public HttpResponseMessage SaveComment(tbCommentaryModelPost id)
{
int result = 0;
try
{
tbCommentary c = new tbCommentary();
c.HerID = id.HerID;
c.Audited = 0;
c.PostTime = DateTime.Now;
c.InforPlatform = id.InforPlatform;
c.UserLocation = System.Data.Entity.Spatial.DbGeography.PointFromText($"Point({id.Longitude} {id.Latitude})", System.Data.Entity.Spatial.DbGeography.DefaultCoordinateSystemId);
c.UserName = id.UserName;
c.Commented = 1;
c.Contents = id.Contents;
dbContext.tbCommentaries.Add(c);
dbContext.SaveChanges();
result = 1;
}
catch (Exception e)
{
result = 0;
}
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
public IHttpActionResult UpdateLang(LanguageModel par)
{
try
{
tbLanguage p = new tbLanguage();
p.Langcode = par.Langcode;
p.LangName = par.LangName;
p.IsDefault = par.IsDefault;
dbContext.tbLanguages.Add(p);
dbContext.SaveChanges();
return(Ok(1));
}
catch
{
return(Ok(1));
}
}
public HttpResponseMessage Viewed(ViewedPost id)
{
int result = 0;
tbViewed c = new tbViewed();
c.HerID = id.HerID;
c.InforPlatform = id.InforPlatform;
c.TimeViewed = DateTime.Now;
c.UserLocation = System.Data.Entity.Spatial.DbGeography.PointFromText(id.UserLocation, System.Data.Entity.Spatial.DbGeography.DefaultCoordinateSystemId);
c.UserName = id.UserName;
c.Viewed = 1;
dbContext.tbVieweds.Add(c);
dbContext.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
public IHttpActionResult DeleteHeritagerInfo(int id)
{
try
{
var student = dbContext.tbHeritagerInfors.Where(x => x.ID == id).FirstOrDefault();
dbContext.tbHeritagerInfors.Attach(student);
dbContext.tbHeritagerInfors.Remove(student);
dbContext.SaveChanges();
return(Ok(1));
}
catch
{
return(Ok(0));
}
}
public IHttpActionResult Liked(LikedPost id)
{
try
{
tbLiked c = new tbLiked();
c.HerID = id.HerID;
c.InforPlatform = id.InforPlatform;
c.LikedTime = DateTime.Now;
c.UserLocation = System.Data.Entity.Spatial.DbGeography.PointFromText($"Point({id.Longitude} {id.Latitude})", System.Data.Entity.Spatial.DbGeography.DefaultCoordinateSystemId);
c.UserName = id.UserName;
c.Liked = 1;
dbContext.tbLikeds.Add(c);
dbContext.SaveChanges();
return(Ok(1));
}
catch
{
return(Ok(0));
}
}
public IHttpActionResult UpdateTag(TagModel par)
{
try
{
if (!dbContext.tbTags.Where(x => x.TagName == par.TagName).Any())
{
tbTag p = new tbTag();
p.TagIDParent = par.TagIDParent;
p.TagName = par.TagName;
p.TagDescription = par.TagDescription;
dbContext.tbTags.Add(p);
dbContext.SaveChanges();
return(Ok(1));
}
return(Ok(0));
}
catch
{
return(BadRequest());
}
}
