public ServiceResponse Save(NewsModel model) { try { using (var ts = new TransactionScope(TransactionScopeOption.Required)) { Core_News obj = new Core_News { Title = model.Title.Trim(), URL = model.URL.Trim(), Summary = model.Summary, Description = model.Description, IsPublish = model.IsPublish, CreatedBy = session.AppUserId, CreatedDate = currentDate, }; _ent.AddToCore_News(obj); _ent.SaveChanges(); ts.Complete(); _response = new ServiceResponse("Record successfully created!!", MessageType.Success, true, "Edit"); return(_response); } } catch (SqlException ex) { _response = new ServiceResponse(ServiceResponsesProvider.SqlExceptionMessage(ex), MessageType.SqlException, false); } catch (Exception ex) { _response = new ServiceResponse(ex.Message, MessageType.Exception, false, "Edit"); } return(_response); }
public App_Class.ServiceResponse Delete(int PId) { Core_News result = _ent.Core_News.Where(x => x.NewsId == PId).FirstOrDefault(); try { _ent.DeleteObject(result); _ent.SaveChanges(); _response = new ServiceResponse("Successfully deleted!!", MessageType.Success, true, "Delete"); return(_response); } catch (SqlException ex) { _response = new ServiceResponse(ServiceResponsesProvider.SqlExceptionMessage(ex), MessageType.SqlException, false); } catch (Exception ex) { _response = new ServiceResponse(ex.Message, MessageType.Exception, false, "Delete"); } return(_response); }