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);
}
