private void BindGrid()
{
gList.Visible = true;
RockContext rockContext = new RockContext();
NoteTemplateService noteTemplateService = new NoteTemplateService(rockContext);
var qry = noteTemplateService.Queryable().AsNoTracking().OrderBy(nt => nt.Order);
var list = qry.ToList();
gList.DataSource = list;
gList.DataBind();
}
/// <summary>
/// Handles the GridReorder event of the gList control
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void gList_GridReorder(object sender, GridReorderEventArgs e)
{
using (var rockContext = new RockContext())
{
NoteTemplateService noteTemplateService = new NoteTemplateService(rockContext);
var noteTemplates = noteTemplateService.Queryable().OrderBy(nt => nt.Order).ToList();
noteTemplateService.Reorder(noteTemplates, e.OldIndex, e.NewIndex);
rockContext.SaveChanges();
}
BindGrid();
}
/// <summary>
/// Adds the New Worker
/// </summary>
private bool AddNote(int noteTemplateId)
{
if (Page.IsValid)
{
RockContext rockContext = new RockContext();
NoteTemplateService noteTemplateService = new NoteTemplateService(rockContext);
NoteTemplate noteTemplate = null;
if (!noteTemplateId.Equals(0))
{
noteTemplate = noteTemplateService.Get(noteTemplateId);
}
if (noteTemplate == null)
{
noteTemplate = new NoteTemplate {
Id = 0
};
}
noteTemplate.Icon = tbIcon.Text;
noteTemplate.Note = tbNote.Text;
noteTemplate.IsActive = cbActive.Checked;
NoteTemplate lastNoteTemplate = noteTemplateService.Queryable().OrderByDescending(b => b.Order).FirstOrDefault();
if (lastNoteTemplate != null)
{
noteTemplate.Order = lastNoteTemplate.Order + 1;
}
else
{
noteTemplate.Order = 0;
}
if (noteTemplate.IsValid)
{
if (noteTemplate.Id.Equals(0))
{
noteTemplateService.Add(noteTemplate);
}
// get attributes
noteTemplate.LoadAttributes();
Helper.GetEditValues(phAttributes, noteTemplate);
rockContext.WrapTransaction(() =>
{
rockContext.SaveChanges();
noteTemplate.SaveAttributeValues(rockContext);
});
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}