public ActionResult UpdateGroupMemberCount(int grpid, int?orgid)
{
try
{
// get group count
var grpmembcount = db.RegisteredUsersGroups.Where(x => x.OrgGroupId == grpid).Where(x => x.RegUserOrgId == orgid).Count();
// locate recently updated group
var orggroup = db.OrgGroups.AsNoTracking().Where(x => x.OrgId == orgid && x.OrgGroupId == grpid).FirstOrDefault();
var updategroup = new OrgGroup
{
OrgGroupId = orggroup.OrgGroupId,
OrgId = orggroup.OrgId,
GroupName = orggroup.GroupName,
CreationDate = orggroup.CreationDate,
GroupTypeId = orggroup.GroupTypeId,
GroupOrgTypeId = orggroup.GroupOrgTypeId,
GroupRefNumb = orggroup.GroupRefNumb,
IsSelected = orggroup.IsSelected,
Group_members_count = grpmembcount,
};
orggroup = updategroup;
db.Entry(orggroup).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch (Exception e)
{
Console.WriteLine(e);
return(Redirect("~/ErrorHandler.html"));
}
}
// POST: OrgGroups/Delete/5
public ActionResult DeleteConfirmed(int id)
{
try
{
if (Session["OrgId"] == null)
{
return(RedirectToAction("Signin", "Access"));
}
OrgGroup orgGroup = db.OrgGroups.Find(id);
db.OrgGroups.Remove(orgGroup);
db.SaveChanges();
// UPON DELETING A GROUP - LOG THE EVENT
var orgeventlog = new Org_Events_Log()
{
Org_Event_SubjectId = id.ToString(),
Org_Event_SubjectName = orgGroup.GroupName,
Org_Event_TriggeredbyId = Session["RegisteredUserId"].ToString(),
Org_Event_TriggeredbyName = Session["FullName"].ToString(),
Org_Event_Time = DateTime.Now,
OrgId = Session["OrgId"].ToString(),
Org_Events_Types = Org_Events_Types.Deleted_Group
};
db.Org_Events_Logs.Add(orgeventlog);
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch (Exception e)
{
Console.WriteLine(e);
return(Redirect("~/ErrorHandler.html"));
}
}
public ActionResult Edit(OrgGroup orgGroup)
{
try
{
if (ModelState.IsValid)
{
db.Entry(orgGroup).State = EntityState.Modified;
db.SaveChanges();
// UPON CREATING A GROUP - LOG THE EVENT
var orgeventlog = new Org_Events_Log()
{
Org_Event_SubjectId = orgGroup.OrgGroupId.ToString(),
Org_Event_SubjectName = orgGroup.GroupName,
Org_Event_TriggeredbyId = Session["RegisteredUserId"].ToString(),
Org_Event_TriggeredbyName = Session["FullName"].ToString(),
Org_Event_Time = DateTime.Now,
OrgId = Session["OrgId"].ToString(),
Org_Events_Types = Org_Events_Types.Edited_Group
};
db.Org_Events_Logs.Add(orgeventlog);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.GroupTypeId = new SelectList(db.GroupTypes, "GroupTypeId", "GroupTypeName", orgGroup.GroupTypeId);
ViewBag.OrgId = new SelectList(db.Orgs, "OrgId", "OrgName", orgGroup.OrgId);
return(View(orgGroup));
}
catch (Exception e)
{
Console.WriteLine(e);
return(Redirect("~/ErrorHandler.html"));
}
}
public ActionResult EditCustomGroup(int Id)
{
try
{
if (Id != 0)
{
var edtcusmgrp = db.OrgGroups.Where(x => x.OrgGroupId == Id).FirstOrDefault();
var edtcusmgrp1 = new OrgGroup
{
OrgGroupId = edtcusmgrp.OrgGroupId,
OrgId = edtcusmgrp.OrgId,
GroupName = edtcusmgrp.GroupName,
CreationDate = edtcusmgrp.CreationDate,
GroupOrgTypeId = edtcusmgrp.GroupOrgTypeId,
GroupTypeId = edtcusmgrp.GroupTypeId,
GroupRefNumb = edtcusmgrp.GroupRefNumb,
IsSelected = edtcusmgrp.IsSelected,
Group_members_count = edtcusmgrp.Group_members_count
};
return(PartialView("~/Views/Shared/PartialViewsForms/_EditCustomGroup.cshtml", edtcusmgrp1));
}
}
catch (Exception e)
{
Console.WriteLine(e);
return(Redirect("~/ErrorHandler.html"));
}
return(new HttpStatusCodeResult(204));
}
/// <summary>
/// Set OrgGroup Properties for insertion
/// </summary>
private void SetOrgGroupProperties(OrgGroup requestOrgGroup)
{
requestOrgGroup.RecCreatedBy =
requestOrgGroup.RecLastUpdatedBy = organizationGroupRepository.LoggedInUserIdentity;
requestOrgGroup.RecCreatedDt = requestOrgGroup.RecLastUpdatedDt = DateTime.Now;
requestOrgGroup.RowVersion = 0;
requestOrgGroup.UserDomainKey = 1;
}
/// <summary>
/// UpdateOrgGroupProperties for updation
/// </summary>
private void UpdateOrgGroupProperties(OrgGroup requestOrgGroup, OrgGroup dbVersion)
{
requestOrgGroup.RecLastUpdatedBy = organizationGroupRepository.LoggedInUserIdentity;
requestOrgGroup.RecLastUpdatedDt = DateTime.Now;
requestOrgGroup.RowVersion = dbVersion.RowVersion + 1;
requestOrgGroup.RecCreatedBy = dbVersion.RecCreatedBy;
requestOrgGroup.RecCreatedDt = dbVersion.RecCreatedDt;
}
public OrgGroup Post(OrgGroup orgGroup)
{
if (!ModelState.IsValid)
{
throw new HttpException((int)HttpStatusCode.BadRequest, "Invalid Request");
}
return(orgGroupService.AddUpdateOrgGroup((orgGroup).CreateFrom()).CreateFromm());
}
/// <summary>
/// Create From Domain Model
/// </summary>
public static ApiModel.OrgGroupDropDown CreateFrom(this OrgGroup source)
{
return(new ApiModel.OrgGroupDropDown
{
OrgGroupId = source.OrgGroupId,
OrgGroupCode = source.OrgGroupCode,
OrgGroupName = source.OrgGroupName
});
}
public Boolean Delete(OrgGroup orgGroup)
{
if (!ModelState.IsValid)
{
throw new HttpException((int)HttpStatusCode.BadRequest, "Invalid Request");
}
orgGroupService.DeleteOrgGroup(orgGroup.OrgGroupId);
return(false);
}
public static IEnumerable <object[]> ValidateOrgGroupOrderData()
{
var g1 = new OrgGroup()
{
GroupName = "g1", Id = Guid.NewGuid(), ParentId = Guid.NewGuid()
};
var g2 = new OrgGroup()
{
GroupName = "g2", Id = g1.ParentId.Value, ParentId = Guid.NewGuid()
};
var g3 = new OrgGroup()
{
GroupName = "g3", Id = g2.ParentId.Value, ParentId = Guid.NewGuid()
};
yield return(new object[] { new List <OrgGroup> {
g3, g2, g1
}, OrgGroupService.SortedBy.Either, true });
yield return(new object[] { new List <OrgGroup> {
g3, g2, g1
}, OrgGroupService.SortedBy.ParentFirst, true });
yield return(new object[] { new List <OrgGroup> {
g3, g2, g1
}, OrgGroupService.SortedBy.ChildFirst, false });
foreach (var sortedBy in Enum.GetValues(typeof(OrgGroupService.SortedBy))
.OfType <OrgGroupService.SortedBy>())
{
yield return(new object[] { new List <OrgGroup> {
g2, g3, g1
}, sortedBy, false });
yield return(new object[] { new List <OrgGroup> {
g1, g3, g2
}, sortedBy, false });
yield return(new object[] { new List <OrgGroup>(), sortedBy, true });
yield return(new object[] { new List <OrgGroup> {
g1
}, sortedBy, true });
}
yield return(new object[] { new List <OrgGroup> {
g1, g2, g3
}, OrgGroupService.SortedBy.Either, true });
yield return(new object[] { new List <OrgGroup> {
g1, g2, g3
}, OrgGroupService.SortedBy.ParentFirst, false });
yield return(new object[] { new List <OrgGroup> {
g1, g2, g3
}, OrgGroupService.SortedBy.ChildFirst, true });
}
/// <summary>
/// Create From Domain model
/// </summary>
public static ApiModel.OrgGroup CreateFromm(this OrgGroup source)
{
return(new ApiModel.OrgGroup
{
OrgGroupId = source.OrgGroupId,
OrgGroupCode = source.OrgGroupCode,
OrgGroupName = source.OrgGroupName,
OrgGroupDescription = source.OrgGroupDescription
});
}
private void SetupContribute()
{
if (IsManager)
{
item = (ItemID == 0) ? new OrgGroup() : new OrgGroup(ItemID);
}
else
{
Response.Redirect(string.Format("{0}/{1}?code={2}", SPContext.Current.Web.Url, Message.URL_USERMESSAGE, Message.Code.MngrAccessReq), false);
}
}
public static bool IsOrgGroupSortedByHierarchy <T>(ICollection <T> orgGroups, SortedBy sortedBy = SortedBy.Either)
where T : OrgGroup
{
if (orgGroups.Count <= 1)
{
return(true);
}
bool ParentInList(OrgGroup group)
{
return(orgGroups.Any(orgGroup => orgGroup.Id == @group.ParentId));
}
var groupWithoutParent = orgGroups.FirstOrDefault(group => !ParentInList(@group));
var startsWithChild = orgGroups.First() != groupWithoutParent;
switch (sortedBy)
{
case SortedBy.ChildFirst:
if (!startsWithChild)
{
return(false);
}
break;
case SortedBy.ParentFirst:
if (startsWithChild)
{
return(false);
}
break;
}
OrgGroup previous = null;
foreach (var current in startsWithChild ? orgGroups.Reverse() : orgGroups)
{
if (previous != null && current.ParentId != previous.Id)
{
return(false);
}
previous = current;
}
return(true);
}
public void ShouldFailGracefullyWithLoops()
{
var g1Id = Guid.NewGuid();
var g2Id = Guid.NewGuid();
var g3Id = Guid.NewGuid();
var g1 = new OrgGroup {
Id = g1Id, ParentId = g2Id
};
var g2 = new OrgGroup {
Id = g2Id, ParentId = g3Id
};
var g3 = new OrgGroup {
Id = g3Id, ParentId = g1Id
};
var sortedGroups = OrgGroupService
.SortOrgGroupByHierarchy(new[] { g1, g2, g3 }, OrgGroupService.SortedBy.ChildFirst).ToList();
}
private void FillOrgGroups()
{
try {
DataSet ds = OrgGroup.Items();
DataView dv = new DataView(ds.Tables[0]);
dv.Sort = "Name";
ddlOrganizations.DataSource = dv;
ddlOrganizations.DataTextField = "Name";
ddlOrganizations.DataValueField = "ID";
ddlOrganizations.DataBind();
ddlOrganizations.Items.Insert(0, new ListItem("-- Select --", "0"));
} catch (Exception ex) {
SPA.Error.WriteError(ex);
if (ShowDebug)
{
lblErrorMessage.Text = ex.ToString();
}
}
}
private void FillOrgGroups()
{
try {
lbxOrgGroups.Items.Clear();
DataSet ds = OrgGroup.Items();
DataView dv = new DataView(ds.Tables[0]);
dv.Sort = "Name";
lbxOrgGroups.DataSource = dv;
lbxOrgGroups.DataTextField = "Name";
lbxOrgGroups.DataValueField = "ID";
lbxOrgGroups.DataBind();
} catch (Exception ex) {
SPA.Error.WriteError(ex);
if (ShowDebug)
{
lblErrorMessage.Text = ex.ToString();
}
}
}
/// <summary>
/// Add/Update Organization Group
/// </summary>
public OrgGroup AddUpdateOrgGroup(OrgGroup requestOrgGroup)
{
OrgGroup dbVersion = organizationGroupRepository.Find(requestOrgGroup.OrgGroupId);
if (!organizationGroupRepository.IsOrgGroupCodeExists(requestOrgGroup))
{
if (dbVersion != null)
{
UpdateOrgGroupProperties(requestOrgGroup, dbVersion);
}
else
{
SetOrgGroupProperties(requestOrgGroup);
}
organizationGroupRepository.Update(requestOrgGroup);
organizationGroupRepository.SaveChanges();
return(organizationGroupRepository.Find(requestOrgGroup.OrgGroupId));
}
throw new CaresException(Resources.Organization.OrganizationGroup.OrganizationGroupWithSameCodeAlreadyExists);
}
/// <summary>
/// Delete Organization Group
/// </summary>
public void DeleteOrgGroup(long orgGroupId)
{
OrgGroup dbVersion = organizationGroupRepository.Find(orgGroupId);
if (!companyRepository.IsOrgGroupContainCompany(orgGroupId))
{
if (dbVersion != null)
{
organizationGroupRepository.Delete(dbVersion);
organizationGroupRepository.SaveChanges();
}
else
{
throw new InvalidOperationException(string.Format(CultureInfo.InvariantCulture,
"OrgGroup with Id {0} not found!", orgGroupId));
}
}
else
{
throw new CaresException(Resources.Organization.OrganizationGroup.OrganizationGroupIsAssociatedWithCompanyError);
}
}
private bool SaveItem()
{
bool success = false;
try {
bool isUpdate = (IView == ItemView.Edit);
item = (isUpdate) ? new SPA.OrgGroup(ItemID) : new SPA.OrgGroup();
item.Name = txtName.Text.Trim();
item.Description = txtDescription.Text.Trim();
item.TrackTraining = ckbxTrackTraining.Checked;
item.Inherit = ckbxInherit.Checked;
item.ModifiedBy = CurrentUser.DisplayName;
if (!isUpdate)
{
item.CreatedBy = item.ModifiedBy;
if (item.Insert())
{
success = true;
}
}
else
{
if (item.Update())
{
success = true;
}
}
ItemID = (success) ? item.ID : 0;
} catch (Exception ex) {
SPA.Error.WriteError(ex);
if (ShowDebug)
{
lblErrorMessage.Text = ex.ToString();
}
}
return(success);
}
public ActionResult Create(OrgGroup orgGroup)
{
try
{
var rr = Session["OrgId"].ToString();
int i = Convert.ToInt32(rr);
orgGroup.OrgId = i;
orgGroup.GroupName = orgGroup.GroupName;
orgGroup.CreationDate = DateTime.Now;
orgGroup.GroupTypeId = 18;
orgGroup.Group_members_count = 0;
db.OrgGroups.Add(orgGroup);
db.SaveChanges();
// UPON CREATING A GROUP - LOG THE EVENT
var orgeventlog = new Org_Events_Log()
{
Org_Event_SubjectId = orgGroup.OrgGroupId.ToString(),
Org_Event_SubjectName = orgGroup.GroupName,
Org_Event_TriggeredbyId = Session["RegisteredUserId"].ToString(),
Org_Event_TriggeredbyName = Session["FullName"].ToString(),
Org_Event_Time = DateTime.Now,
OrgId = Session["OrgId"].ToString(),
Org_Events_Types = Org_Events_Types.Created_Group
};
db.Org_Events_Logs.Add(orgeventlog);
db.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
return(View(orgGroup));
}
return(new HttpStatusCodeResult(204));
}
public OrgGroupTests(ServicesFixture sf)
{
_sf = sf;
_groupService = _sf.Get <OrgGroupService>();
_groupRepository = _sf.Get <OrgGroupRepository>();
_transaction = _sf.DbConnection.BeginTransaction();
var orgRootId = Guid.NewGuid();
org1Super = _sf.InsertPerson();
org1 = _sf.InsertOrgGroup(orgRootId, org1Super.Id, name: "org1", approvesLeave: true);
org2Super = _sf.InsertPerson();
org2 = _sf.InsertOrgGroup(orgRootId, org2Super.Id, name: "org2", approvesLeave: true);
org2a = _sf.InsertOrgGroup(org2.Id, name: "org2a");
org1aSuper = _sf.InsertPerson();
org1a = _sf.InsertOrgGroup(org1.Id, org1aSuper.Id, name: "org1a");
orgRoot = _sf.InsertOrgGroup(action: group => group.Id = orgRootId, name: "orgRoot");
org2aStaff = _sf.InsertStaff(org2a.Id);
org1Staff = _sf.InsertStaff(org1.Id);
org1aStaff = _sf.InsertStaff(org1a.Id);
}
public void Save(OrgGroup orgGroup)
{
_entityService.Save(orgGroup);
}
public ActionResult Create(Org org)
{
try
{
var rud = Session["Email"];
var loggedinuser = db.RegisteredUsers.Where(x => x.Email == rud.ToString()).Select(x => x.Email).FirstOrDefault();
var orgredirect = db.RegisteredUserOrganisations.Where(x => x.Email == rud.ToString()).Select(x => x.OrgId).FirstOrDefault();
if (rud.ToString() != loggedinuser)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
if (ModelState.IsValid)
{
org.CreatedBy = Session["RegisteredUserId"].ToString();
org.CreationDate = DateTime.Now;
db.Orgs.Add(org);
db.SaveChanges();
var orgOrgType = new OrgOrgType()
{
OrgId = org.OrgId,
OrgName = org.OrgName,
OrgTypeId = (int)org.OrgTypeId
};
db.OrgOrgTypes.Add(orgOrgType);
db.SaveChanges();
// list of groups
var groups = db.GroupTypes.Where(x => (x.GroupOrgTypeId == org.OrgTypeId) || x.GroupOrgTypeId == null).Select(g => g.GroupTypeId).ToList();
var grouptypeid = new List <int>(groups);
foreach (var newgrp in groups)
{
var groupname = db.GroupTypes.Where(x => x.GroupTypeId == newgrp).Select(s => s.GroupTypeName).FirstOrDefault();
var grouporgtypeid = db.GroupTypes.Where(x => x.GroupTypeId == newgrp).Select(s => s.GroupOrgTypeId).FirstOrDefault();
var grouprefnumb = db.GroupTypes.Where(x => x.GroupTypeId == newgrp).Select(s => s.GroupRefNumb).FirstOrDefault();
var orggroup = new OrgGroup()
{
OrgId = org.OrgId,
GroupName = groupname,
CreationDate = DateTime.Now,
GroupTypeId = newgrp,
GroupOrgTypeId = grouporgtypeid,
GroupRefNumb = grouprefnumb
};
db.OrgGroups.Add(orggroup);
db.SaveChanges();
}
//return RedirectToAction("SystemAdminIndex", "Orgs", new { id = orgredirect });
return(RedirectToAction("SystemAdminIndex"));
}
ViewBag.DomainId = new SelectList(db.Domains, "DomainId", "DomainName", org.DomainId);
ViewBag.OrgBrandId = new SelectList(db.OrgBrands, "OrgBrandId", "OrgBrandName", org.OrgBrandId);
ViewBag.OrgTypeId = new SelectList(db.OrgTypes, "OrgTypeId", "OrgTypeName", org.OrgTypeId);
return(View(org));
}
catch (Exception e)
{
Console.WriteLine(e);
return(View(org));
}
}
//protected void TrngOrgAdminSummary() {
// try {
// if (IsTrngAdmin || IsAdmin || TrngOrgAdmin.IsAdmin(CurrentUser.ID)) {
// // Define Table
// jsActionTrngRecord = string.Format("window.location.replace('{0}/{1}'); return false;", SPContext.Current.Web.Url, OrgTrngDashboard.PAGE_URL);
// Table tblCourse = new Table();
// tblCourse.Attributes.Add("onmouseover", "this.originalstyle = this.style.backgroundColor; this.style.backgroundColor = 'rgba( 156,206,240,0.5 )'; this.style.color = 'black'");
// tblCourse.Attributes.Add("onmouseout", "this.style.backgroundColor=this.originalstyle;this.style.color=this.originalstyle;");
// tblCourse.Attributes.Add("onclick", jsActionTrngRecord);
// tblCourse.Attributes.Add("border-collapse", "separate");
// tblCourse.Attributes.Add("border-spacing", "0px 0px");
// tblCourse.BorderStyle = BorderStyle.Solid;
// tblCourse.BorderWidth = Unit.Pixel(1);
// tblCourse.BorderColor = System.Drawing.Color.Gainsboro;
// tblCourse.BackColor = System.Drawing.Color.Gainsboro;
// tblCourse.Width = Unit.Pixel(250);
// tblCourse.Height = Unit.Pixel(5);
// // define header
// TableRow trHeader = new TableRow();
// TableCell tdHeader = new TableCell();
// tdHeader.VerticalAlign = VerticalAlign.Middle;
// tdHeader.HorizontalAlign = HorizontalAlign.Left;
// tdHeader.Style.Add("padding-left", "10px");
// tdHeader.Style.Add("padding-right", "10px");
// tdHeader.Style.Add("padding-top", "2px");
// tdHeader.Style.Add("padding-bottom", "2px");
// tdHeader.Style.Add("border-top-left-radius", "4px");
// tdHeader.Style.Add("border-top-right-radius", "4px");
// trHeader.BackColor = System.Drawing.Color.FromArgb(136, 117, 52);
// // define header link
// HyperLink hlHeader = new HyperLink();
// hlHeader.Text = "Organizational Training Manager for";
// hlHeader.NavigateUrl = OrgTrngDashboard.PAGE_URL;
// hlHeader.ForeColor = System.Drawing.Color.White;
// hlHeader.Font.Size = FontUnit.Point(9);
// hlHeader.Font.Bold = true;
// hlHeader.Font.Underline = false;
// // add header controls
// tdHeader.Controls.Add(hlHeader);
// trHeader.Controls.Add(tdHeader);
// // define body
// TableRow trBody = new TableRow();
// TableCell tdBody = new TableCell();
// tdBody.VerticalAlign = VerticalAlign.Top;
// tdBody.HorizontalAlign = HorizontalAlign.Left;
// tdBody.Style.Add("padding-left", "10px");
// tdBody.Style.Add("padding-right", "10px");
// tdBody.Style.Add("padding-top", "2px");
// tdBody.Style.Add("padding-bottom", "2px");
// trBody.BackColor = System.Drawing.Color.White;
// Label lblBody = new Label();
// DataView dv = new DataView();
// if (IsTrngAdmin || IsAdmin) {
// dv = new DataView(SPA.OrgGroup.Items().Tables[0]);
// } else {
// dv = new DataView(SPA.TrngOrgAdmin.Memberships(CurrentUser.ID, false).Tables[0]);
// }
// foreach (DataRowView drv in dv) {
// lblBody.Text += string.Format("<img src='/_layouts/15/images/BCCUR.GIF' /> {0}<br>", drv["Name"].ToString());
// }
// lblBody.ForeColor = System.Drawing.Color.Black;
// // add body controls
// tdBody.Controls.Add(lblBody);
// trBody.Controls.Add(tdBody);
// // define footer
// TableRow trFooter = new TableRow();
// TableCell tdFooter = new TableCell();
// tdFooter.VerticalAlign = VerticalAlign.Middle;
// tdFooter.HorizontalAlign = HorizontalAlign.Left;
// tdFooter.Style.Add("padding-left", "10px");
// tdFooter.Style.Add("padding-right", "10px");
// tdFooter.Style.Add("padding-top", "2px");
// tdFooter.Style.Add("padding-bottom", "2px");
// trFooter.BackColor = System.Drawing.Color.White;
// Label lblFooter = new Label();
// lblFooter.Text += "Click to manage organizational training";
// lblFooter.ForeColor = System.Drawing.Color.Black;
// // add footer controls
// tdFooter.Controls.Add(lblFooter);
// trFooter.Controls.Add(tdFooter);
// // add rows to table and table to placeholder
// tblCourse.Controls.Add(trHeader);
// tblCourse.Controls.Add(trBody);
// tblCourse.Controls.Add(trFooter);
// phTrngOrgSummary.Controls.Add(tblCourse);
// }
// } catch (Exception ex) {
// SPA.Error.WriteError(ex);
// if (ShowDebug)
// lblErrorMessage.Text = ex.ToString();
// }
//}
protected void OrgTrainingSummary()
{
try {
// Define Table
jsActionTrngRecord = string.Format("window.location.replace('{0}/{1}'); return false;", SPContext.Current.Web.Url, OrgTrngDashboard.PAGE_URL);
Table tbl = new Table();
tbl.Attributes.Add("onmouseover", "this.originalstyle = this.style.backgroundColor; this.style.backgroundColor = 'rgba( 156,206,240,0.5 )'; this.style.color = 'black'");
tbl.Attributes.Add("onmouseout", "this.style.backgroundColor=this.originalstyle;this.style.color=this.originalstyle;");
tbl.Attributes.Add("onclick", jsActionTrngRecord);
tbl.Attributes.Add("border-collapse", "separate");
tbl.Attributes.Add("border-spacing", "0px 0px");
tbl.BorderStyle = BorderStyle.Solid;
tbl.BorderWidth = Unit.Pixel(1);
tbl.BorderColor = System.Drawing.Color.Gainsboro;
tbl.BackColor = System.Drawing.Color.Gainsboro;
tbl.Width = Unit.Pixel(250);
tbl.Height = Unit.Pixel(5);
// define header
TableRow trHeader = new TableRow();
TableCell tdHeader = new TableCell();
tdHeader.VerticalAlign = VerticalAlign.Middle;
tdHeader.HorizontalAlign = HorizontalAlign.Left;
tdHeader.Style.Add("padding-left", "10px");
tdHeader.Style.Add("padding-right", "10px");
tdHeader.Style.Add("padding-top", "2px");
tdHeader.Style.Add("padding-bottom", "2px");
tdHeader.Style.Add("border-top-left-radius", "4px");
tdHeader.Style.Add("border-top-right-radius", "4px");
trHeader.BackColor = System.Drawing.Color.FromArgb(136, 117, 52);
// define header link
HyperLink hlHeader = new HyperLink();
hlHeader.Text = "Organizationl Training Summary (Inwork)";
hlHeader.NavigateUrl = OrgTrngDashboard.PAGE_URL;
hlHeader.ForeColor = System.Drawing.Color.White;
hlHeader.Font.Size = FontUnit.Point(9);
hlHeader.Font.Bold = true;
hlHeader.Font.Underline = false;
// add header controls
tdHeader.Controls.Add(hlHeader);
trHeader.Controls.Add(tdHeader);
// define body
TableRow trBody = new TableRow();
TableCell tdBody = new TableCell();
tdBody.VerticalAlign = VerticalAlign.Top;
tdBody.HorizontalAlign = HorizontalAlign.Left;
tdBody.Style.Add("padding-left", "10px");
tdBody.Style.Add("padding-right", "10px");
tdBody.Style.Add("padding-top", "2px");
tdBody.Style.Add("padding-bottom", "2px");
trBody.BackColor = System.Drawing.Color.White;
Label lblBody = new Label();
DataView dv = new DataView();
if (CurrentUser.InRole("TrngAdmin") || CurrentUser.InRole("TrngAuditor"))
{
dv = new DataView(SPA.OrgGroup.Items().Tables[0]);
}
else
{
dv = new DataView(SPA.User.OrgGroupAdminMemberships(CurrentUser.ID, false).Tables[0]);
}
foreach (DataRowView drv in dv)
{
lblBody.Text += string.Format("<img src='/_layouts/15/images/BCCUR.GIF' /> {0}<br>", drv["Name"].ToString());
int OrgGroupID = Int32.Parse(drv["OrgID"].ToString());
int userCount = OrgGroup.UserCount(OrgGroupID);
int currentCount = 0;
int dueCount = TrngRecord.DueByOrgGroupCount(OrgGroupID);
int awactCount = 0;
lblBody.Text += string.Format(" <img src='/_layouts/15/images/greybullet.gif' /> Users: {0}<br>", userCount);
lblBody.Text += string.Format(" <img src='/_layouts/15/images/greybullet.gif' /> Current: {0}<br>", currentCount);
lblBody.Text += string.Format(" <img src='/_layouts/15/images/greybullet.gif' /> Due/Overdue: {0}<br>", dueCount);
lblBody.Text += string.Format(" <img src='/_layouts/15/images/greybullet.gif' /> Awaiting Action: {0}<br>", awactCount);
}
lblBody.ForeColor = System.Drawing.Color.Black;
Image img = new Image();
img.ImageUrl = "/_layouts/15/images/spa/Upcoming_learning_event.png";
// add body controls
//tdBody.Controls.Add(img);
tdBody.Controls.Add(lblBody);
trBody.Controls.Add(tdBody);
// define footer
TableRow trFooter = new TableRow();
TableCell tdFooter = new TableCell();
tdFooter.VerticalAlign = VerticalAlign.Middle;
tdFooter.HorizontalAlign = HorizontalAlign.Left;
tdFooter.Style.Add("padding-left", "10px");
tdFooter.Style.Add("padding-right", "10px");
tdFooter.Style.Add("padding-top", "2px");
tdFooter.Style.Add("padding-bottom", "2px");
trFooter.BackColor = System.Drawing.Color.White;
Label lblFooter = new Label();
lblFooter.Text += "Click to view trends";
lblFooter.ForeColor = System.Drawing.Color.Black;
// add footer controls
tdFooter.Controls.Add(lblFooter);
trFooter.Controls.Add(tdFooter);
// add rows to table and table to placeholder
tbl.Controls.Add(trHeader);
tbl.Controls.Add(trBody);
tbl.Controls.Add(trFooter);
phOrgTrngSummary.Controls.Add(tbl);
} catch (Exception ex) {
SPA.Error.WriteError(ex);
if (ShowDebug)
{
lblErrorMessage.Text = ex.ToString();
}
}
}
public OrgGroup Save([FromBody] OrgGroup orgGroup)
{
_orgGroupService.Save(orgGroup);
return(orgGroup);
}
