public static CmdAdjustScormUserResult OnScormLogin(CmdAdjustScormUser par) { var db = Lib.CreateContext(); par.companyHost = par.companyHost.ToLowerInvariant(); par.login = par.login.ToLowerInvariant(); var login = par.companyHost + "/" + par.login; var usr = db.Users.FirstOrDefault(u => u.Login == login); var comp = db.Companies.Where(c => c.ScormHost == par.companyHost).FirstOrDefault(); CompanyUsers compUser = null; Logger.Log("CmdAdjustScormUserResult Start"); if (usr == null) //adjust user db.Users.Add(usr = new Users() { Created = DateTime.UtcNow, EMail = null, Login = login, FirstName = par.firstName, LastName = par.lastName, LoginEMail = null, OtherId = par.login, OtherType = (short)LMComLib.OtherType.scorm }); else if (comp != null) //comp a user nejsou null => testGlobalAdmin na compuser compUser = db.CompanyUsers.FirstOrDefault(cu => cu.CompanyId == comp.Id && cu.UserId == usr.Id); if (comp == null) //adjust company db.Companies.Add(comp = new Companies() { ScormHost = par.companyHost, Title = par.companyHost, Created = DateTime.UtcNow }); if (compUser == null) //adjust comp user db.CompanyUsers.Add(compUser = new CompanyUsers() { User = usr, Created = DateTime.UtcNow, Company = comp }); else if (par.isNotAttempted) { //compUser existuje a isNotAttempted => vymaz vysledky kurzu Logger.Log("prodId={0}, userId={1}", par.productId, compUser.Id); //foreach (var modData in db.CourseDatas.Where(cd => cd.CourseUser.ProductId == par.productId && cd.CourseUser.email == compUser.compId)) db.CourseDatas.DeleteObject(modData); var crsUser = compUser.CourseUsers.FirstOrDefault(crsUsr => crsUsr.ProductId == par.productId); if (crsUser != null) db.CourseUsers.Remove(crsUser); } Lib.SaveChanges(db); CmdAdjustScormUserResult res = new CmdAdjustScormUserResult() { Cookie = user2cookie(usr), companyId = comp.Id, }; return res; }
public static void setRoleParEx(CompanyUsers self, CompUserRole value) { self.RolePar = value.ToString(); self.Roles = (long)value.Role; }
public static bool adjustCourseUser(Container db, Int64 lmcomUserId, int companyId, string productId, out CourseUsers crsUser, out CompanyUsers compUser) { DateTime startDate = DateTime.UtcNow; crsUser = null; //adjust CompanyUser compUser = db.CompanyUsers.FirstOrDefault(u => u.CompanyId == companyId && u.UserId == lmcomUserId); if (compUser == null) { var allDeps = db.CompanyDepartments.Where(d => d.CompanyId == companyId).Select(cd => cd.Id).ToArray(); db.CompanyUsers.Add(compUser = new CompanyUsers() { UserId = lmcomUserId, CompanyId = companyId, Created = DateTime.UtcNow, DepartmentId = allDeps.Length == 1 ? (int?)allDeps[0] : null, }); } else crsUser = compUser.CourseUsers.FirstOrDefault(cu => cu.ProductId == productId); //adjust CourseUser if (crsUser == null) { db.CourseUsers.Add(crsUser = new CourseUsers() { CompanyUser = compUser, Created = DateTime.UtcNow, ProductId = productId, }); return false; } return true; }
public static CompUserRole getRoleParEx(CompanyUsers self) { if (self.RolePar == null && self.Roles != 0) return new CompUserRole { Role = (CompRole)self.Roles }; else return CompUserRole.FromString(self.RolePar); }
public static void setRolesEx(CompanyUsers self, long value) { var r = CompUserRole.FromString(self.RolePar); r.Role = (CompRole)value; self.RolePar = r.ToString(); self.Roles = value; }
public static long getRolesEx(CompanyUsers self) { return self.RolePar == null ? self.Roles : (long)CompUserRole.FromString(self.RolePar).Role; }
static void lmcomAddAdmin(Container db, string email, string password, string firstName, string lastName) { var user = new Users() { EMail = email, Password = password, Created = DateTime.UtcNow, OtherType = 10, FirstName = firstName, LastName = lastName, Roles = (int)Role.All, }; db.Users.Add(user); var company = new Companies() { Title = "Company " + lastName, Created = DateTime.UtcNow }; db.Companies.Add(company); var dep = new CompanyDepartments() { Title = company.Title, Company = company }; db.CompanyDepartments.Add(dep); var compUser = new CompanyUsers() { Company = company, User = user, Created = DateTime.UtcNow/*, RolesEx = (long)CompRole.All*/, CompanyDepartment = dep }; setRolesEx(compUser, (long)CompRole.All); db.CompanyUsers.Add(compUser); //@PRODID string[] ignoreUserLic = new string[] { "/lm/prods_lm_blcourse_english/", "/lm/prods_lm_blcourse_french/", "/lm/prods_lm_blcourse_german/" }; foreach (var prodId in new string[] { //"/data/xmlsource/simpleenglish/", "/data/xmlsource/simplespanish/", //"/data/xmlsource/docexamples/", "/data/xmlsource/TestProduct/", //"/lm/EnglishE_0_10/", "/lm/English_0_10/", "/lm/German_0_5/", "/lm/Spanish_0_6/", "/lm/French_0_6/", "/lm/Italian_0_6/", "/lm/Russian_0_3/", //"/lm/EnglishE_0_1/", "/lm/Spanish_0_1/", //"/grafia/od1_8/", "/grafia/od1_administrativ/", //"/skrivanek/prods/etestme-std/english/a1/", "/skrivanek/prods/etestme-comp/english/a1/", "/skrivanek/prods/etestme-comp/english/all/", //"/skrivanek/prods/etestme-comp/french/all/", //"/skrivanek/prods/etestme-comp/german/all/","/skrivanek/prods/etestme-comp/russian/all/", //"/skrivanek/prods/etestme-comp/italian/all/","/skrivanek/prods/etestme-comp/spanish/all/", //"/lm/prods/etestme/english/a1/", //"/lm/prods/etestme/english/a1_c2/" //Blended "/lm/blcourse/schoolmanager.product/", "/lm/blcourse/langmastermanager.product/", }.Concat(ignoreUserLic).Select(p => p.ToLower())) { var compLicence = new CompanyLicences() { Company = company, Days = 100, ProductId = prodId, Created = DateTime.UtcNow }; db.CompanyLicences.Add(compLicence); var courseUser = new CourseUsers() { CompanyUser = compUser, Created = DateTime.UtcNow, ProductId = prodId }; db.CourseUsers.Add(courseUser); if (!ignoreUserLic.Contains(prodId)) { var userLicence = new UserLicences() { CompanyLicence = compLicence, CourseUser = courseUser, Started = DateTime.UtcNow, Created = DateTime.UtcNow }; db.UserLicences.Add(userLicence); } } }
static bool humanEvalManagerEvsSave(CmdHumanEvalManagerEvsSave par) { var db = Lib.CreateContext(); CompanyUsers cu; if (par.companyUserId < 0) { cu = db.CompanyUsers.First(c => c.Id == -par.companyUserId); //var ex = cu.RoleParEx; var ex = Lib.getRoleParEx(cu); ex.HumanEvalatorInfos = null; ex.Role &= ~CompRole.HumanEvalator; //cu.RoleParEx = ex; Lib.setRoleParEx(cu, ex); db.SaveChanges(); return true; } else if (par.companyUserId == 0) { par.email = par.email.ToLower(); var u = db.Users.Where(c => c.EMail == par.email).FirstOrDefault(); if (u == null) return false; cu = db.CompanyUsers.Where(c => c.UserId == u.Id && c.CompanyId == par.companyId).FirstOrDefault(); if (cu == null) db.CompanyUsers.Add(cu = new CompanyUsers { CompanyId = par.companyId, UserId = u.Id, Created = DateTime.UtcNow }); } else cu = db.CompanyUsers.First(c => c.Id == par.companyUserId); //CompUserRole rx = cu.RoleParEx; var rx = Lib.getRoleParEx(cu); rx.Role = rx.Role |= CompRole.HumanEvalator; rx.HumanEvalatorInfos = par.evalInfos; //cu.RoleParEx = rx; Lib.setRoleParEx(cu, rx); db.SaveChanges(); return true; }