// GET: Group
public JsonResult AddGroup(CompetencyGroup Group)
{
using (var context = new SSITrainingEntities())
{
string name = Group.GroupName;
Group.CreateDateTime = DateTime.Now;
Group.CreateUserId = Convert.ToInt32(Session["USERID"]);
context.CompetencyGroups.Add(Group);
context.SaveChanges();
return(Json(new { status = "Group Added Successfully!!" }));
}
}
public void DeleteGroup(CompetencyGroup group)
{
var compGroup = new CompetencyGroup {
CompetencyGroupID = group.CompetencyGroupID
};
using (SSITrainingEntities context = new SSITrainingEntities())
{
context.CompetencyGroups.Attach(compGroup);
context.CompetencyGroups.Remove(compGroup);
context.SaveChanges();
}
}
public JsonResult EditGroup(CompetencyGroup updatedGroup)
{
CompetencyGroup group = new CompetencyGroup();
string status;
using (SSITrainingEntities entity = new SSITrainingEntities())
{
var result = entity.CompetencyGroups.SingleOrDefault(g => g.CompetencyGroupID == updatedGroup.CompetencyGroupID);
if (result != null)
{
result.GroupName = updatedGroup.GroupName;
result.ModifiedUserID = 137;
result.ModifiedDateTime = DateTime.Now;
entity.SaveChanges();
status = "Group Updated";
}
else
{
status = "Cannot update this group b/c it no longer exists.";
}
}
return(Json(new { status }));
}
