/// <summary>
/// Delete
/// </summary>
/// <param name="model"></param>
/// <returns>ResponseStatusCodeHelper</returns>
public ResponseStatusCodeHelper Delete(PostTypeModel model)
{
try
{
using (var context = new TDHEntities())
{
FB_POST_TYPE _md = context.FB_POST_TYPE.FirstOrDefault(m => m.code == model.Code && !m.deleted);
if (_md == null)
{
throw new DataAccessException(FILE_NAME, "Delete", model.CreateBy);
}
_md.deleted = true;
_md.deleted_by = model.DeleteBy;
_md.deleted_date = DateTime.Now;
context.FB_POST_TYPE.Attach(_md);
context.Entry(_md).State = EntityState.Modified;
context.SaveChanges();
}
}
catch (DataAccessException fieldEx)
{
throw fieldEx;
}
catch (Exception ex)
{
throw new ServiceException(FILE_NAME, "Delete", model.CreateBy, ex);
}
Notifier.Notification(model.CreateBy, Message.DeleteSuccess, Notifier.TYPE.Success);
return(ResponseStatusCodeHelper.Success);
}
/// <summary>
/// Get item
/// </summary>
/// <param name="model"></param>
/// <returns>PostTypeModel. Throw exception if not found or get some error</returns>
public PostTypeModel GetItemByID(PostTypeModel model)
{
try
{
using (var context = new TDHEntities())
{
FB_POST_TYPE _md = context.FB_POST_TYPE.FirstOrDefault(m => m.code == model.Code && !m.deleted);
if (_md == null)
{
throw new DataAccessException(FILE_NAME, "GetItemByID", model.CreateBy);
}
return(new PostTypeModel()
{
Code = _md.code,
Name = _md.name,
OnFanpage = _md.on_fanpage,
OnProfile = _md.on_profile,
OnGroup = _md.on_group,
Ordering = _md.ordering,
Publish = _md.publish,
Notes = _md.notes
});
}
}
catch (DataAccessException fieldEx)
{
throw fieldEx;
}
catch (Exception ex)
{
throw new ServiceException(FILE_NAME, "GetItemByID", model.CreateBy, ex);
}
}
/// <summary>
/// Save
/// </summary>
/// <param name="model"></param>
/// <returns>ResponseStatusCodeHelper</returns>
public ResponseStatusCodeHelper Save(PostTypeModel model)
{
try
{
using (var context = new TDHEntities())
{
FB_POST_TYPE _md = new FB_POST_TYPE();
if (model.Insert)
{
_md.code = "none";
}
else
{
_md = context.FB_POST_TYPE.FirstOrDefault(m => m.code == model.Code && !m.deleted);
if (_md == null)
{
throw new DataAccessException(FILE_NAME, "Save", model.CreateBy);
}
}
_md.name = model.Name;
_md.on_fanpage = model.OnFanpage;
_md.on_group = model.OnGroup;
_md.on_profile = model.OnProfile;
_md.notes = model.Notes;
_md.publish = model.Publish;
_md.ordering = model.Ordering;
if (model.Insert)
{
_md.created_by = model.CreateBy;
_md.created_date = DateTime.Now;
context.FB_POST_TYPE.Add(_md);
context.Entry(_md).State = EntityState.Added;
}
else
{
_md.updated_by = model.UpdateBy;
_md.updated_date = DateTime.Now;
context.FB_POST_TYPE.Attach(_md);
context.Entry(_md).State = EntityState.Modified;
}
context.SaveChanges();
}
}
catch (DataAccessException fieldEx)
{
throw fieldEx;
}
catch (Exception ex)
{
throw new ServiceException(FILE_NAME, "Save", model.CreateBy, ex);
}
if (model.Insert)
{
Notifier.Notification(model.CreateBy, Message.InsertSuccess, Notifier.TYPE.Success);
}
else
{
Notifier.Notification(model.CreateBy, Message.UpdateSuccess, Notifier.TYPE.Success);
}
return(ResponseStatusCodeHelper.Success);
}
