protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Account_Information myaaccinfo = new Account_Information();
txt_EMPGuid.Text = myaaccinfo.ReturnGuidFrom_AD(HttpContext.Current.User.Identity.Name.ToString());
try
{
txt_EMPID.Text = myaaccinfo.Return_EmpID(txt_EMPGuid.Text);
txt_EMPRoleID.Text = myaaccinfo.Return_EmpRoleid(txt_EMPGuid.Text);
}
catch
{
Response.Redirect("access_denied.aspx");
}
myaaccinfo.Dispose();
Site_EventLoggin obj_logevent = new Site_EventLoggin();
obj_logevent.writeLogg(txt_EMPID.Text + " with Guid " + txt_EMPGuid.Text + " has hit the master page at time: " + System.DateTime.Now.ToString());
obj_logevent.Dispose();
/* Check if user is enabled */
SqlConnection myconn = new SqlConnection(WebConfigurationManager.ConnectionStrings["sctcs_Grants"].ConnectionString);
SqlCommand mycomm = new SqlCommand("pr_scs_college_user_status_get", myconn);
mycomm.CommandType = CommandType.StoredProcedure;
mycomm.Parameters.AddWithValue("@key_user_id", txt_EMPID.Text);
if (myconn.State == ConnectionState.Closed)
myconn.Open();
SqlDataReader dr = mycomm.ExecuteReader();
if (dr.HasRows)
while (dr.Read())
{
if (((bool)dr["flg_enabled"]) == false)
Response.Redirect(WebConfigurationManager.AppSettings.Get("AppLocation").ToString() + "/ErrorHandler.aspx?err=104");
}
mycomm.Dispose();
myconn.Dispose();
}
}
public static UserModel MapUserModel(Account account, bool deepLoad, bool loadUserInformation = false)
{
if (account != null)
{
UserModel userModel = new UserModel()
{
Id = account.ID,
FirstName = account.FirstName,
LastName = account.LastName,
Username = account.UserName,
Image = account.Image,
ClubId = account.ClubId,
Gender = (Gender)account.Gender
};
userModel.Club = new ClubModel()
{
Id = account.ClubId,
Name = account.Club.Name,
ShortName = account.Club.ShortName,
Image = account.Club.Image
};
if (deepLoad)
{
Parallel.Invoke(() =>
{
userModel.Token = AccountBLL.GetUserSession(account.ID);
}, () =>
{
foreach (var item in account.AccountAccess)
{
foreach (var right in item.Accessright.Accessright_Right)
{
userModel.AccessRightsRight.Add(new AccessrightRightModel()
{
AccessType = (AccessType)right.AccessType,
AccessTypeRight = (AccessTypeRight)right.AccessTypeRight,
Id = right.Id
});
}
}
}, () =>
{
foreach (var item in account.AccountAccess)
{
userModel.AccessRights.Add(new AccessrightModel()
{
Id = item.Accessright.ID,
Name = item.Accessright.Name,
Description = item.Accessright.Description
});
}
}, () =>
{
Account_Information information = AccountBLL.GetAccountSettings(userModel.Id);
if (information != null)
{
userModel.UserInformation = new UserInformationModel()
{
Email = information.Email,
City = information.City,
Occupation = information.Occupation,
Phone = information.Phone,
Street = information.Street,
Zip = information.Zip,
Birthday = information.Birthday,
Grade = (SW.Core.Enums.Grade)information.Grade,
Weight = information.Weight,
Theme = information.Theme
};
}
}, () =>
{
userModel.AccountAccess = AccountAccessModel.MapAccountAccesses(AccountBLL.GetAccountAccesses(userModel.Id));
}, () =>
{
userModel.GenericValues = AccountInformationGeneric.MapValues(
AccountBLL.GetGenericValues(userModel.Id, userModel.ClubId));
});
}
else if (loadUserInformation)
{
Account_Information information = AccountBLL.GetAccountSettings(userModel.Id);
if (information != null)
{
userModel.UserInformation = new UserInformationModel()
{
Email = information.Email,
City = information.City,
Occupation = information.Occupation,
Phone = information.Phone,
Street = information.Street,
Zip = information.Zip,
Birthday = information.Birthday,
Grade = (SW.Core.Enums.Grade)information.Grade,
Weight = information.Weight,
Theme = information.Theme
};
}
}
return(userModel);
}
return(new UserModel()
{
GenericValues = AccountInformationGeneric.MapValues(
AccountBLL.GetGenericValues(0, 0))
});
}
public static void ImportUsersFromExcel(byte[] data, int clubId, bool sendWelcomeMail,
bool tryToMatchGroupName, List <int> accessrightIds)
{
MemoryStream ms = new MemoryStream(data);
DataTable dt = ExcelHelper.GetDataTableFromXls(ms);
foreach (DataRow row in dt.Rows)
{
Account acc = new Account();
try
{
string password = GenerateRandomPassword(5);
acc = new Account()
{
ClubId = clubId,
FirstName = row["Förnamn"].ToString(),
Gender = row["Kön"].ToString().ToLower() == "man" ? 0 : 1,
LastName = row["Efternamn"].ToString(),
UserName = row["E-post 1"].ToString(),
Password = password,
Image = string.Empty
};
Account_Information info = new Account_Information()
{
AccountId = acc.ID,
City = row["Ort"].ToString(),
Email = row["E-post 1"].ToString(),
Phone = row["Mobiltelefon"].ToString(),
Street = row["Adress"].ToString(),
Zip = row["Postnummer"].ToString(),
Grade = 16,
Birthday = DateTime.Now,
Occupation = "-",
Weight = "-",
Theme = "blue"
};
acc.Account_Information.Add(info);
if (tryToMatchGroupName)
{
TryToMatchGroupName(acc, row["Gruppkoppling"].ToString(), clubId);
}
else
{
foreach (int accessrightId in accessrightIds)
{
DAL.AccountAccess accAccess = new AccountAccess()
{
AccessID = accessrightId,
AccountID = acc.ID
};
acc.AccountAccess.Add(accAccess);
}
}
SaveAccount(acc);
if (sendWelcomeMail)
{
SendWelcomeMail(acc, password);
}
}
catch (Exception ex)
{
LogHelper.LogError(string.Format("Error importing user: {0} {1} - username: {2}",
acc.FirstName, acc.LastName, acc.UserName), ex, clubId);
}
}
}
