/// <summary>
/// Get item
/// </summary>
/// <param name="model">model</param>
/// <returns>MoneyEducationModel</returns>
public EducationModel GetItemByID(EducationModel model)
{
try
{
using (var _context = new TDHEntities())
{
PN_EDUCATION _md = _context.PN_EDUCATION.FirstOrDefault(m => m.id == model.ID && !m.deleted && m.created_by == model.CreateBy);
if (_md == null)
{
throw new DataAccessException(FILE_NAME, "GetItemByID", model.CreateBy);
}
return(new EducationModel()
{
ID = _md.id,
Name = _md.name,
School = _md.school,
Duration = _md.duration,
Date = _md.date,
DateString = _md.date.DateToString(),
Description = _md.description,
Content = _md.content,
TypeCode = _md.education_type,
IsPlan = _md.is_plan,
IsFinish = _md.is_finish,
IsCancel = _md.is_cancel,
Ordering = _md.ordering,
Publish = _md.publish
});
}
}
catch (DataAccessException fieldEx)
{
throw fieldEx;
}
catch (Exception ex)
{
throw new ServiceException(FILE_NAME, "GetItemByID", model.CreateBy, ex);
}
}
/// <summary>
/// Save
/// </summary>
/// <param name="model">model</param>
/// <returns>ResponseStatusCodeHelper</returns>
public ResponseStatusCodeHelper Save(EducationModel model)
{
try
{
using (var _context = new TDHEntities())
{
PN_EDUCATION _md = new PN_EDUCATION();
if (model.Insert)
{
_md.id = Guid.NewGuid();
}
else
{
_md = _context.PN_EDUCATION.FirstOrDefault(m => m.id == model.ID && !m.deleted && m.created_by == model.CreateBy);
if (_md == null)
{
throw new DataAccessException(FILE_NAME, "Save", model.CreateBy);
}
}
_md.name = model.Name;
_md.school = model.School;
_md.duration = model.Duration;
_md.description = model.Description;
_md.content = model.Content;
_md.date = model.Date;
_md.is_plan = model.IsPlan;
_md.is_finish = model.IsFinish;
_md.is_cancel = model.IsCancel;
_md.education_type = model.TypeCode;
_md.ordering = model.Ordering;
_md.publish = model.Publish;
//Setting value don't allow change when create or edit
if (model.Insert)
{
_md.created_by = model.CreateBy;
_md.created_date = DateTime.Now;
_context.PN_EDUCATION.Add(_md);
_context.Entry(_md).State = EntityState.Added;
}
else
{
_md.updated_by = model.UpdateBy;
_md.updated_date = DateTime.Now;
_context.PN_EDUCATION.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);
}
