static public AP_StaffBroker_Department CreateDept(string Name, string RC, int manager, int?del) { StaffBrokerDataContext d = new StaffBrokerDataContext(); DotNetNuke.Entities.Portals.PortalSettings PS = (DotNetNuke.Entities.Portals.PortalSettings)System.Web.HttpContext.Current.Items["PortalSettings"]; if (del == 0) { del = null; } var q = from c in d.AP_StaffBroker_Departments where c.CostCentre == RC && c.PortalId == PS.PortalId select c; if (q.Count() > 0) { q.First().Name = Name; q.First().CostCentreManager = manager; q.First().CostCentreDelegate = del; d.SubmitChanges(); return(q.First()); } else { AP_StaffBroker_Department insert = new AP_StaffBroker_Department(); insert.PortalId = PS.PortalId; insert.Name = Name; insert.CostCentre = RC; insert.CostCentreManager = manager; insert.CanRmb = true; insert.CanGiveTo = false; insert.CanCharge = false; insert.IsProject = false; insert.Spare1 = "False"; insert.GivingText = ""; insert.GivingShortcut = ""; insert.PayType = ""; insert.CostCentreDelegate = del; d.AP_StaffBroker_Departments.InsertOnSubmit(insert); d.SubmitChanges(); return(insert); } }
static public void AddProfileValue(int PortalId, int staffId, string propertyName, string propertyValue, int Type = 0) { StaffBrokerDataContext d = new StaffBrokerDataContext(); AP_StaffBroker_StaffProfile insert = new AP_StaffBroker_StaffProfile(); var definition = (from c in d.AP_StaffBroker_StaffPropertyDefinitions where c.PropertyName == propertyName && c.PortalId == PortalId select c.StaffPropertyDefinitionId); if (definition.Count() == 0) { AP_StaffBroker_StaffPropertyDefinition newDef = new AP_StaffBroker_StaffPropertyDefinition(); newDef.PortalId = PortalId; newDef.PropertyName = propertyName; newDef.Display = false; newDef.ViewOrder = (short?)((from c in d.AP_StaffBroker_StaffPropertyDefinitions where c.PortalId == PortalId select c.ViewOrder).Max() + 1); newDef.Type = Convert.ToByte(Type); newDef.PropertyHelp = ""; d.AP_StaffBroker_StaffPropertyDefinitions.InsertOnSubmit(newDef); d.SubmitChanges(); insert.StaffPropertyDefinitionId = newDef.StaffPropertyDefinitionId; } else { insert.StaffPropertyDefinitionId = definition.First(); } insert.StaffId = staffId; insert.PropertyValue = propertyValue; var existing = from c in d.AP_StaffBroker_StaffProfiles where c.StaffId == insert.StaffId && c.StaffPropertyDefinitionId == insert.StaffPropertyDefinitionId select c; if (existing.Count() > 0) { existing.First().PropertyValue = propertyValue; } else { d.AP_StaffBroker_StaffProfiles.InsertOnSubmit(insert); } d.SubmitChanges(); }
static public AP_StaffBroker_Staff CreateStaffMember(int PortalId, DotNetNuke.Entities.Users.UserInfo User1in, DotNetNuke.Entities.Users.UserInfo User2in, short staffTypeIn) { //Create Married Staff DotNetNuke.Security.Roles.RoleController rc = new DotNetNuke.Security.Roles.RoleController(); if (rc.GetRoleByName(PortalId, "Staff") == null) { DotNetNuke.Security.Roles.RoleInfo insert = new DotNetNuke.Security.Roles.RoleInfo(); insert.Description = "Staff Members"; insert.RoleName = "Staff"; insert.AutoAssignment = false; insert.IsPublic = false; insert.RoleGroupID = -1; insert.PortalID = PortalId; rc.AddRole(insert); } rc.AddUserRole(PortalId, User1in.UserID, rc.GetRoleByName(PortalId, "Staff").RoleID, DateTime.MaxValue); rc.AddUserRole(PortalId, User2in.UserID, rc.GetRoleByName(PortalId, "Staff").RoleID, DateTime.MaxValue); StaffBrokerDataContext d = new StaffBrokerDataContext(); var searchStaff = from c in d.AP_StaffBroker_Staffs where c.Active && (c.UserId1 == User1in.UserID || c.UserId2 == User1in.UserID || c.UserId1 == User2in.UserID || c.UserId2 == User2in.UserID) select c; if (searchStaff.Count() > 0) { return(searchStaff.First()); } AP_StaffBroker_Staff rtn = new AP_StaffBroker_Staff(); rtn.UserId1 = User1in.UserID; rtn.UserId2 = User2in.UserID; rtn.PortalId = PortalId; rtn.Active = true; rtn.DisplayName = User1in.FirstName + " & " + User2in.FirstName + " " + User1in.LastName; rtn.StaffTypeId = staffTypeIn; rtn.CostCenter = ""; d.AP_StaffBroker_Staffs.InsertOnSubmit(rtn); d.SubmitChanges(); return(rtn); }
static public void SetSetting(string SettingName, string value, int portalId) { StaffBrokerDataContext d = new StaffBrokerDataContext(); var q = from c in d.AP_StaffBroker_Settings where c.SettingName == SettingName && c.PortalId == portalId select c; if (q.Count() == 0) { AP_StaffBroker_Setting insert = new AP_StaffBroker_Setting(); insert.SettingName = SettingName; insert.SettingValue = value; insert.PortalId = portalId; d.AP_StaffBroker_Settings.InsertOnSubmit(insert); } else { q.First().SettingValue = value; } d.SubmitChanges(); }
public static void SetSetting(string SettingName, string value, int portalId) { StaffBrokerDataContext d = new StaffBrokerDataContext(); var q = from c in d.AP_StaffBroker_Settings where c.SettingName == SettingName && c.PortalId == portalId select c; if (q.Count() == 0) { AP_StaffBroker_Setting insert = new AP_StaffBroker_Setting(); insert.SettingName = SettingName; insert.SettingValue = value; insert.PortalId = portalId; d.AP_StaffBroker_Settings.InsertOnSubmit(insert); } else { q.First().SettingValue = value; } d.SubmitChanges(); }
public static AP_StaffBroker_Staff CreateStaffMember(int PortalId, DotNetNuke.Entities.Users.UserInfo User1in, string SpouseName, DateTime SpouseDOB, short staffTypeIn = 1) { DotNetNuke.Security.Roles.RoleController rc = new DotNetNuke.Security.Roles.RoleController(); if (rc.GetRoleByName(PortalId, "Staff") == null) { DotNetNuke.Security.Roles.RoleInfo insert = new DotNetNuke.Security.Roles.RoleInfo(); insert.Description = "Staff Members"; insert.RoleName = "Staff"; insert.AutoAssignment = false; insert.IsPublic = false; insert.RoleGroupID = -1; insert.PortalID = PortalId; rc.AddRole(insert); } rc.AddUserRole(PortalId, User1in.UserID, rc.GetRoleByName(PortalId, "Staff").RoleID, DateTime.MaxValue); StaffBrokerDataContext d = new StaffBrokerDataContext(); var searchStaff = from c in d.AP_StaffBroker_Staffs where c.Active && (c.UserId1 == User1in.UserID || c.UserId2 == User1in.UserID) select c; if (searchStaff.Count() > 0) return searchStaff.First(); //Create Married to Non-Staff AP_StaffBroker_Staff rtn = new AP_StaffBroker_Staff(); rtn.UserId1 = User1in.UserID; rtn.UserId2 = -1; rtn.DisplayName = User1in.FirstName + " " + User1in.LastName; rtn.StaffTypeId = staffTypeIn; rtn.CostCenter = ""; rtn.PortalId = PortalId; rtn.Active = true; d.AP_StaffBroker_Staffs.InsertOnSubmit(rtn); d.SubmitChanges(); //Now add Spouse data AddProfileValue(PortalId, rtn.StaffId, "SpouseDOB", SpouseDOB.ToShortDateString()); AddProfileValue(PortalId, rtn.StaffId, "SpouseName", SpouseName); return rtn; }
public static AP_StaffBroker_Department CreateDept(string Name, string RC, int manager, int? del) { StaffBrokerDataContext d = new StaffBrokerDataContext(); DotNetNuke.Entities.Portals.PortalSettings PS = (DotNetNuke.Entities.Portals.PortalSettings)System.Web.HttpContext.Current.Items["PortalSettings"]; if (del == 0) del = null; var q = from c in d.AP_StaffBroker_Departments where c.CostCentre == RC && c.PortalId == PS.PortalId select c; if (q.Count() > 0) { q.First().Name = Name; q.First().CostCentreManager = manager; q.First().CostCentreDelegate = del; d.SubmitChanges(); return q.First(); } else { AP_StaffBroker_Department insert = new AP_StaffBroker_Department(); insert.PortalId = PS.PortalId; insert.Name = Name; insert.CostCentre = RC; insert.CostCentreManager = manager; insert.CanRmb = true; insert.CanGiveTo = false; insert.CanCharge = false; insert.IsProject = false; insert.Spare1 = "False"; insert.GivingText = ""; insert.GivingShortcut = ""; insert.PayType = ""; insert.CostCentreDelegate = del; d.AP_StaffBroker_Departments.InsertOnSubmit(insert); d.SubmitChanges(); return insert; } }
public static void AddProfileValue(int PortalId, int staffId, string propertyName, string propertyValue, int Type = 0) { StaffBrokerDataContext d = new StaffBrokerDataContext(); AP_StaffBroker_StaffProfile insert = new AP_StaffBroker_StaffProfile(); var definition = (from c in d.AP_StaffBroker_StaffPropertyDefinitions where c.PropertyName == propertyName && c.PortalId == PortalId select c.StaffPropertyDefinitionId); if (definition.Count() == 0) { AP_StaffBroker_StaffPropertyDefinition newDef = new AP_StaffBroker_StaffPropertyDefinition(); newDef.PortalId = PortalId; newDef.PropertyName = propertyName; newDef.Display = false; newDef.ViewOrder = (short?)((from c in d.AP_StaffBroker_StaffPropertyDefinitions where c.PortalId == PortalId select c.ViewOrder).Max() + 1); newDef.Type = Convert.ToByte(Type); newDef.PropertyHelp = ""; d.AP_StaffBroker_StaffPropertyDefinitions.InsertOnSubmit(newDef); d.SubmitChanges(); insert.StaffPropertyDefinitionId = newDef.StaffPropertyDefinitionId; } else insert.StaffPropertyDefinitionId = definition.First(); insert.StaffId = staffId; insert.PropertyValue = propertyValue; var existing = from c in d.AP_StaffBroker_StaffProfiles where c.StaffId == insert.StaffId && c.StaffPropertyDefinitionId == insert.StaffPropertyDefinitionId select c; if (existing.Count() > 0) existing.First().PropertyValue = propertyValue; else d.AP_StaffBroker_StaffProfiles.InsertOnSubmit(insert); d.SubmitChanges(); }