/// <summary>
/// Get item
/// </summary>
/// <param name="model">Dream model</param>
/// <returns>DreamModel</returns>
public DreamModel GetItemByID(DreamModel model)
{
try
{
using (var context = new TDHEntities())
{
PN_DREAM _md = context.PN_DREAM.FirstOrDefault(m => m.id == model.ID && m.created_by == model.CreateBy && !m.deleted);
if (_md == null)
{
throw new DataAccessException(FILE_NAME, "GetItemByID", model.CreateBy);
}
return(new DreamModel()
{
ID = _md.id,
Title = _md.title,
Finish = _md.finish,
FinishTime = _md.finish_time,
FinishTimeString = _md.finish_time.HasValue ? _md.finish_time.Value.DateToString("dd/MM/yyyy") : "",
Notes = _md.notes
});
}
}
catch (DataAccessException fieldEx)
{
throw fieldEx;
}
catch (Exception ex)
{
throw new ServiceException(FILE_NAME, "GetItemByID", model.CreateBy, ex);
}
}
/// <summary>
/// Delete
/// </summary>
/// <param name="model"></param>
/// <returns>ResponseStatusCodeHelper</returns>
public ResponseStatusCodeHelper Delete(DreamModel model)
{
try
{
using (var context = new TDHEntities())
{
PN_DREAM _md = context.PN_DREAM.FirstOrDefault(m => m.id == model.ID && m.created_by == model.CreateBy && !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.PN_DREAM.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);
}
public JsonResult Delete(DreamModel model)
{
try
{
#region " [ Declaration ] "
DreamService _service = new DreamService();
#endregion
#region " [ Main process ] "
model.CreateBy = UserID;
model.DeleteBy = UserID;
model.DeleteDate = DateTime.Now;
#endregion
//Call to service
return(this.Json(_service.Delete(model), JsonRequestBehavior.AllowGet));
}
catch (ServiceException serviceEx)
{
throw serviceEx;
}
catch (DataAccessException accessEx)
{
throw accessEx;
}
catch (Exception ex)
{
throw new ControllerException(FILE_NAME, "Delete", UserID, ex);
}
}
public ActionResult Edit(string id)
{
try
{
#region " [ Declaration ] "
DreamService _service = new DreamService();
//
ViewBag.id = id;
#endregion
// Call to service
DreamModel model = _service.GetItemByID(new DreamModel()
{
ID = new Guid(id), CreateBy = UserID, Insert = false
});
return(View(model));
}
catch (ServiceException serviceEx)
{
throw serviceEx;
}
catch (DataAccessException accessEx)
{
throw accessEx;
}
catch (Exception ex)
{
throw new ControllerException(FILE_NAME, "Edit", UserID, ex);
}
}
public ActionResult Create()
{
try
{
#region " [ Declaration ] "
DreamModel model = new DreamModel()
{
ID = Guid.NewGuid(),
CreateBy = UserID,
Insert = true
};
#endregion
return(View(model));
}
catch (ServiceException serviceEx)
{
throw serviceEx;
}
catch (DataAccessException accessEx)
{
throw accessEx;
}
catch (Exception ex)
{
throw new ControllerException(FILE_NAME, "Create", UserID, ex);
}
}
/// <summary>
/// Save
/// </summary>
/// <param name="model">Dream model</param>
/// <returns>ResponseStatusCodeHelper</returns>
public ResponseStatusCodeHelper Save(DreamModel model)
{
try
{
using (var context = new TDHEntities())
{
PN_DREAM _md = new PN_DREAM();
if (model.Insert)
{
_md.id = Guid.NewGuid();
}
else
{
_md = context.PN_DREAM.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.title = model.Title;
_md.finish = model.Finish;
_md.finish_time = model.FinishTime;
_md.notes = model.Notes;
_md.ordering = model.Ordering;
if (model.Insert)
{
_md.created_by = model.CreateBy;
_md.created_date = DateTime.Now;
context.PN_DREAM.Add(_md);
context.Entry(_md).State = EntityState.Added;
}
else
{
_md.updated_by = model.UpdateBy;
_md.updated_date = DateTime.Now;
context.PN_DREAM.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);
}
public JsonResult Edit(DreamModel model)
{
try
{
#region " [ Declaration ] "
DreamService _service = new DreamService();
#endregion
#region " [ Main processing ] "
if (model.FinishTimeString.Length > 0)
{
string[] tmp = model.FinishTimeString.Split('/');
model.FinishTime = new DateTime(int.Parse(tmp[2]), int.Parse(tmp[1]), int.Parse(tmp[0]));
}
model.CreateBy = UserID;
model.UpdateBy = UserID;
model.CreateDate = DateTime.Now;
model.UpdateDate = DateTime.Now;
#endregion
// Call to service
return(this.Json(_service.Save(model), JsonRequestBehavior.AllowGet));
}
catch (ServiceException serviceEx)
{
throw serviceEx;
}
catch (DataAccessException accessEx)
{
throw accessEx;
}
catch (Exception ex)
{
throw new ControllerException(FILE_NAME, "Edit", UserID, ex);
}
}
public DreamEditPage(DreamModel dreamModel)
{
InitializeComponent();
BindingContext = dreamModel;
}
