public JsonResult SaveGroupApprover(GroupApproverModel group)
{
string serverResponse = "";
if (group != null)
{
GroupApproverService.SaveGroup(group, out serverResponse);
}
return(Json(serverResponse));
}
public static void SaveGroup(GroupApproverModel _group, out string message)
{
try
{
message = "";
using (var db = new SLVLOnlineEntities())
{
if (_group.ID == Guid.Empty || _group.ID == null) //NEW
{
ApproverGroup newGroup = new ApproverGroup
{
ID = Guid.NewGuid(),
Name = _group.Name,
FirstApprover = _group.FirstApprover,
SecondApprover = _group.SecondApprover
};
db.Entry(newGroup).State = EntityState.Added;
}
else //UPDATE
{
var group = db.ApproverGroup.FirstOrDefault(r => r.ID == _group.ID);
if (group != null)
{
if (_group.Status == "X")
{
db.Entry(group).State = EntityState.Deleted;
var members = db.ApproverGroupMember.Where(r => r.GroupID == _group.ID);
if (members != null)
{
members.ToList().ForEach(item =>
{
db.Entry(item).State = EntityState.Deleted;
});
}
}
else
{
group.Name = _group.Name;
group.FirstApprover = _group.FirstApprover;
group.SecondApprover = _group.SecondApprover;
db.Entry(group).State = EntityState.Modified;
}
}
}
db.SaveChanges();
}
}
catch (Exception error)
{
message = error.Message;
}
}
