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());
}
}
