public Note(t_note entity)
{
NoteId = entity.note_id;
SiteId = entity.site_id;
ActivityId = entity.activity_id;
Subject = entity.subject;
NoteText = entity.note_text;
CreatedByUserId = entity.createdby_userid;
CreatedOn = entity.created_date;
UpdatedByUserId = entity.updatedby_userid;
UpdatedOn = entity.updated_date;
}
public JsonResult Add(Note model)
{
if (ModelState.IsValid)
{
using (Entity db = new Entity())
{
try
{
if (model.ActivityId.HasValue)
{
t_activity activity = db.t_activity.Find(model.ActivityId);
if (activity == null)
{
throw new ArgumentException("Invalid activityId: " + model.ActivityId.ToString());
}
}
if (model.SiteId.HasValue)
{
t_site site = db.t_site.Find(model.SiteId);
if (site == null)
{
throw new ArgumentException("Invalid siteId: " + model.SiteId.ToString());
}
}
t_note note = new t_note();
note.site_id = model.SiteId;
note.activity_id = model.ActivityId;
note.subject = model.Subject;
note.note_text = model.NoteText;
note.createdby_userid = CurrentUser.Id;
note.created_date = DateTime.Now;
db.t_note.Add(note);
db.SaveChanges();
db.Entry(note).Reference(n => n.createdby).Load();
return(GetJsonResult(note));
}
catch (Exception ex)
{
return(GetJsonResult(false, "An error occurred: " + ex.ToString()));
}
}
}
else
{
return(GetJsonResult(false, "Model is invalid."));
}
}
private JsonResult GetJsonResult(t_note note)
{
return(Json(new
{
success = true,
NoteId = note.note_id,
SiteId = note.site_id,
ActivityId = note.activity_id,
Subject = note.subject,
NoteText = note.note_text,
CreatedBy = note.createdby.full_name,
CreatedOn = note.created_date.ToString("d"),
UpdatedBy = note.updatedby?.full_name,
UpdatedOn = note.updated_date?.ToString("d")
}));
}
public JsonResult Delete(int id)
{
using (Entity db = new Entity())
{
try
{
t_note note = db.t_note.Find(id);
db.t_note.Remove(note);
db.SaveChanges();
return(GetJsonResult(true, null));
}
catch (Exception ex)
{
return(GetJsonResult(false, "An error occurred: " + ex.ToString()));
}
}
}
public JsonResult Edit(Note model)
{
if (ModelState.IsValid)
{
using (Entity db = new Entity())
{
try
{
t_note note = db.t_note.Find(model.NoteId);
if (note == null)
{
throw new ArgumentException("Invalid noteId: " + model.NoteId.ToString());
}
note.subject = model.Subject;
note.note_text = model.NoteText;
note.updatedby_userid = CurrentUser.Id;
note.updated_date = DateTime.Now;
db.Entry(note).Property(n => n.site_id).IsModified = false;
db.Entry(note).Property(n => n.activity_id).IsModified = false;
db.Entry(note).Property(n => n.createdby_userid).IsModified = false;
db.Entry(note).Property(n => n.created_date).IsModified = false;
db.SaveChanges();
db.Entry(note).Reference(n => n.updatedby).Load();
return(GetJsonResult(note));
}
catch (Exception ex)
{
return(GetJsonResult(false, "An error occurred: " + ex.ToString()));
}
}
}
else
{
return(GetJsonResult(false, "Model is invalid."));
}
}
