private bool CopyFromForm()
{
using (var ctx = new Entities())
{
try
{
var dataSource = new FIELDGROUP();
if (btnFormButtons.EntityID.HasValue)
{
var id = btnFormButtons.EntityID;
dataSource = ctx.FIELDGROUPs.FirstOrDefault(u => u.ID == id);
PopulateEntity(ref dataSource);
Audit.Log(ctx, AuditType.Edit, this.Page.GetType().FullName,
string.Format("Group Edited. ID: {0}", dataSource.ID), LoggedInUser.ID);
}
else
{
dataSource = new FIELDGROUP {
CREATEDON = DateTime.Now
};
PopulateEntity(ref dataSource);
ctx.AddToFIELDGROUPs(dataSource);
Audit.Log(ctx, AuditType.Add, this.Page.GetType().FullName,
string.Format("Group Added: {0}", dataSource.NAME), LoggedInUser.ID);
}
ctx.SaveChanges();
// delete fields
EntityExtensions.ExecuteProcedure(new EntityConnection(ctx.Connection.ConnectionString),
"Entities.ClearGroupFields", new KeyValuePair <string, object>("GROUP_ID", dataSource.ID));
// save fields
foreach (var item in jsGroupFields.SelectedItems)
{
var groupField = new FIELDGROUPFIELD {
FIELDGROUPID = dataSource.ID, FIELDID = (short)int.Parse(item.Value)
};
ctx.AddToFIELDGROUPFIELDs(groupField);
}
ctx.SaveChanges();
return(true);
}
catch (Exception ex)
{
ExceptionLog.WriteException("Save Group", ex);
ShowMessage(MessageType.Error, "There was an error saving this record");
}
}
return(false);
}
private void PopulateEntity(ref FIELDGROUP entity)
{
entity.NAME = txtName.Text;
entity.MODIFIEDON = DateTime.Now;
}
