public static int EditExternalUserAndUserGroupMapping(ExternalUserLogin_UserGroup_Mapping mappingToEdit) { //create DBContext object using (var smsDB = new SMSEntities()) { ExternalUserLogin_UserGroup_Mapping userMapping = smsDB.ExternalUserLogin_UserGroup_Mapping.Find(mappingToEdit.ExternalUserLogin_UserGroup_ID); userMapping.ExternalUserLoginID = mappingToEdit.ExternalUserLoginID; userMapping.UserGroupId = mappingToEdit.UserGroupId; return(smsDB.SaveChanges()); } }
public static int AddExternalUserAndUserGroupMapping(ExternalUserLogin_UserGroup_Mapping mappingToAdd) { //create DBContext object using (var smsDB = new SMSEntities()) { //Add Student object into Students DBset smsDB.ExternalUserLogin_UserGroup_Mapping.Add(mappingToAdd); // call SaveChanges method to save student into database return(smsDB.SaveChanges()); } }
public static bool CheckExternalUserGroupTypeIsAdmin(int?externalUserInfoId) { bool result = false; using (var smsDB = new SMSEntities()) { ExternalUserLogin externalUserLogin = smsDB.ExternalUserLogins.SingleOrDefault(m => m.ExternalUserInfoID == externalUserInfoId); ExternalUserLogin_UserGroup_Mapping userMapping = smsDB.ExternalUserLogin_UserGroup_Mapping.SingleOrDefault(m => m.ExternalUserLoginID == externalUserLogin.ExternalUserLoginID && m.UserGroupId == 1); if (userMapping != null) { result = true; } } return(result); }
public static int DeleteExternalUserAndUserGroupMapping(int?mappingIdToRemove) { using (var smsDB = new SMSEntities()) { ExternalUserLogin_UserGroup_Mapping userMapping = smsDB.ExternalUserLogin_UserGroup_Mapping.Find(mappingIdToRemove); if (userMapping != null) { smsDB.ExternalUserLogin_UserGroup_Mapping.Remove(userMapping); return(smsDB.SaveChanges()); } else { return(0); // no record found } } }
public static int AddSchool(School schoolToInsert) { //create DBContext object using (var smsDB = new SMSEntities()) { //Add Student object into Students DBset schoolToInsert.CreateDate = DateTime.Now; schoolToInsert.IsActive = true; smsDB.Schools.Add(schoolToInsert); // call SaveChanges method to save student into database smsDB.SaveChanges(); // Add Default Admin User into database when school is added. ExternalUserInfo externalUserInfo = new ExternalUserInfo(); externalUserInfo.SchoolID = schoolToInsert.SchoolID; externalUserInfo.EmailID = "Admin@" + externalUserInfo.SchoolID + ".com"; smsDB.ExternalUserInfoes.Add(externalUserInfo); smsDB.SaveChanges(); ExternalUserLogin externalUserLogin = new ExternalUserLogin(); externalUserLogin.ExternalUserInfoID = externalUserInfo.ExternalUserInfoID; externalUserLogin.ExternalUserName = "******" + schoolToInsert.SchoolID; externalUserLogin.Password = "******"; smsDB.ExternalUserLogins.Add(externalUserLogin); smsDB.SaveChanges(); ExternalUserLogin_UserGroup_Mapping userMapping = new ExternalUserLogin_UserGroup_Mapping(); userMapping.ExternalUserLoginID = externalUserLogin.ExternalUserLoginID; userMapping.UserGroupId = 1; smsDB.ExternalUserLogin_UserGroup_Mapping.Add(userMapping); return(smsDB.SaveChanges()); } }