public int Post(Models.News value) { try { Data.MstNew NewNews = new Data.MstNew(); DateTime myDate = Convert.ToDateTime(value.NewsDate, new CultureInfo("en-US")); SqlDateTime NewsDate = new SqlDateTime(new DateTime(Convert.ToDateTime(myDate).Year, + Convert.ToDateTime(myDate).Month, + Convert.ToDateTime(myDate).Day)); NewNews.NewsDate = NewsDate.Value; NewNews.News = value.NewsDescription; NewNews.Particulars = value.Particulars; db.MstNews.InsertOnSubmit(NewNews); db.SubmitChanges(); return(NewNews.Id); } catch { return(0); } }
public HttpResponseMessage Delete(int Id) { Data.MstNew DeleteNews = db.MstNews.Where(d => d.Id == Id).First(); if (DeleteNews != null) { db.MstNews.DeleteOnSubmit(DeleteNews); try { db.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } catch { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } } else { return(Request.CreateResponse(HttpStatusCode.NotFound)); } }