public void authorizationFail2()
{
User test1 = new User();
test1.Email = "*****@*****.**";
test1.Password = "******";
test1.Type = UserType.standard;
User test2 = new User();
test2.Email = "*****@*****.**";
test2.Password = "******";
test2.Type = UserType.standard;
using (ShimsContext.Create())
{
ShimServiceClient.AllInstances.GetUserByEmailString = (a, b) => test1;
ShimServiceClient.AllInstances.UpdateUserUser = (a, b) => { };
Controller.LogIn("*****@*****.**", "test1");
try
{
Controller.UpdateUser(test2);
}
catch (InsufficientRightsException e)
{
//Everything is good.
}
}
}
protected void Unnamed_Click(object sender, EventArgs e)
{
string email = Iemail.Text;
string pass = Ipass.Text;
User u = new User();
List<string> lst = new List<string>();
lst = u.UserLogin(email, pass);
if(lst[0].ToString().Equals("True"))
{
if(lst[3].ToString().Equals("1") || lst[3].ToString().Equals("4"))
{
Application.Add("username", lst[2]);
Application.Add("UserNumber", lst[1]);
Application.Add("UserSecRole", lst[3]);
Response.Redirect("./default");
}
if (lst[3].ToString().Equals("2") || lst[3].ToString().Equals("3"))
{
Application.Add("username", lst[2]);
Application.Add("UserNumber", lst[1]);
Application.Add("UserSecRole", lst[3]);
Response.Redirect("./manager/default");
}
}
else
{
email = "";
pass = "";
failed.Visible = true;
}
}
public void authorizationFail()
{
User testAdmin = new User();
testAdmin.Email = "*****@*****.**";
testAdmin.Password = "******";
testAdmin.Type = UserType.admin;
Item testItem = new Item();
testItem.Id = 011;
testItem.Name = "test";
testItem.OwnerEmail = "*****@*****.**";
using (ShimsContext.Create())
{
ShimServiceClient.AllInstances.GetUserByEmailString = (a, b) => testAdmin;
ShimServiceClient.AllInstances.GetFileInfoByIdInt32 = (a, b) => { return new FileInfo(); };
Controller.LogIn("*****@*****.**", "ta123");
Controller.LogOut();
try
{
Controller.DownloadFileById(011);
}
catch (NotLoggedInException e)
{
// everything is ok!
}
}
}
protected void Unnamed_Click(object sender, EventArgs e)
{
string date = default_datetimepicker.Text;
if(String.IsNullOrEmpty(date))
{
date = "10/10/2010";
}
string[] words = date.Split('/');
DateTime dt = new DateTime(Convert.ToInt32(words[2]), Convert.ToInt32(words[1]), Convert.ToInt32(words[0]));
string gender = "";
string address = "";
if (Password.Text.Equals(ConfirmPassword.Text) && dt < DateTime.Now)
{
string firstName = FName.Text;
string surname = Surname.Text;
string email = Email.Text;
string contactNumber = ContactNumber.Text;
address = PhysicalAddress.Text;
string password = Password.Text;
int securityRoleNumber = 1;
int cityNumber = Convert.ToInt32(CityDDL.SelectedIndex)+1;
Boolean active = true;
User newuser = new User(0, firstName, surname, email, contactNumber, address, password, securityRoleNumber, cityNumber, dt, gender, active);
int newUserNumber = 0;
string test = newuser.InsertNewUser(newuser);
foreach (string s in newuser.LastUserNumber())
{
newUserNumber = Convert.ToInt32(s);
}
Client newClient = new Client();
newClient.InsertNewClient(newUserNumber, "Client", true);
Application.Add("username", firstName);
Application.Add("UserNumber", newUserNumber);
Application.Add("UserSecRole", "1");
Response.Redirect("./default");
}
else if ( dt > DateTime.Now)
{
errorbirth.Visible = true;
errorbirth.Text = "Please Select a Valid Birth Date";
}
else if (!Password.Text.Equals(ConfirmPassword.Text))
{
errorbirth.Visible = true;
errorbirth.Text = "The password fields did not match";
}
}
protected void SqlDataSource1_Init(object sender, EventArgs e)
{
object session = Session[Constants.LOGGED_IN_SESSION];
if (session != null)
{
if (this.user == null)
{
this.user = ((User)session);
this.SqlDataSource1.SelectParameters["userId"].DefaultValue = this.user.Id.ToString();
}
}
}
protected void test_Click(object sender, EventArgs e)
{
User u = new User();
if (u.SendUserPassword(Iemail.Text).Length == 0)
{
Label lblMasterStatus = (Label)Master.FindControl("message");
lblMasterStatus.Visible = true;
lblMasterStatus.Text = "We could not retrieve your password, please check that you have entered a correct email address and try again.";
}
else if ((u.SendUserPassword(Iemail.Text).Length > 0))
{
Email sendPass = new Email();
sendPass.SendPassword(Iemail.Text);
Response.Redirect("/login");
}
}
/// <summary>
/// Handles the Load event of the Page control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param>
protected void Page_Load(object sender, EventArgs e)
{
object session = Session[Constants.LOGGED_IN_SESSION];
if (session != null)
{
if (this.user == null)
{
this.user = (User)session;
if (this.user.CurrentChat == null)
{
this.user.CurrentChat = new Chat(1, "Main Chat");
}
this.Label1.Text = this.user.CurrentChat.Name + " - " + this.user.Name;
}
}
else
{
Response.Redirect(Constants.LOGIN_PAGE, true); // Dit moet true zijn.
}
}
/// <summary>Attempts to log in as the User that identifies itself with the given email and password.</summary>
/// <param name="email">The email that identifies the user.</param>
/// <param name="password">The password that authorizes the user.</param>
public static void LogIn(string email, string password)
{
if (_sessionUser != null)
throw new NotLoggedOutException();
using (var client = new ServiceClient())
{
var temp = client.GetUserByEmail(email);
if (temp == null)
throw new NoSuchUserException();
if (!temp.Password.Equals(password))
throw new IncorrectPasswordException();
_sessionUser = temp;
}
}
private void NoName()
{
TableRow HEADER = new TableRow();
TableHeaderCell HEADERNAME = new TableHeaderCell();
HEADERNAME.Text = "Namn";
HEADER.Cells.Add(HEADERNAME);
Table2.Rows.Add(HEADER);
DirectoryInfo d = new DirectoryInfo(MapPath("/tests"));
foreach (FileInfo file in d.GetFiles("*.xml"))
{
NpgsqlConnection conn = new NpgsqlConnection(WebConfigurationManager.ConnectionStrings["JE-banken"].ConnectionString);
string employeenumber = Path.GetFileNameWithoutExtension(file.Name);
string sql = "SELECT * FROM employees WHERE employeenumber="+employeenumber;
NpgsqlCommand cmd = new NpgsqlCommand(sql, conn);
conn.Open();
NpgsqlDataReader dr = cmd.ExecuteReader();
User u = new User();
while (dr.Read())
{
u.fullname = dr["fullname"].ToString();
}
conn.Close();
int fragaNumber = 0;
XmlDocument doc = new XmlDocument();
doc.Load(file.FullName);
XmlNodeList nodeList = doc.SelectNodes("/formular/fraga");
TableRow row = new TableRow();
TableCell name = new TableCell();
name.Text = u.fullname;
name.Style.Add(HtmlTextWriterStyle.BackgroundColor, "rgb(153, 208, 231)");
name.Style.Add(HtmlTextWriterStyle.BorderWidth, "1px");
name.Style.Add(HtmlTextWriterStyle.BorderColor, "#000");
name.Style.Add(HtmlTextWriterStyle.BorderStyle, "solid");
name.Style.Add(HtmlTextWriterStyle.FontWeight, "bold");
row.Cells.Add(name);
foreach (XmlNode fraga in nodeList)
{
fragaNumber++;
int svarAntalRatt = 0;
int antalSvaradeRatt = 0;
TableCell cell = new TableCell();
cell.Text = "Fråga: "+fragaNumber.ToString();
cell.ForeColor = Color.Red;
foreach (XmlNode svar in fraga["svar"].ChildNodes)
{
if (Convert.ToInt32(svar.Attributes["ratt"].Value) == 1)
{
svarAntalRatt++;
}
if (Convert.ToInt32(svar.Attributes["ratt"].Value) == 1 && Convert.ToInt32(svar.Attributes["gissat"].Value) == 1)
{
antalSvaradeRatt++;
}
}
if (svarAntalRatt == antalSvaradeRatt)
{
cell.ForeColor = Color.Green;
}
row.Cells.Add(cell);
}
Table2.Rows.Add(row);
}
}
/// <summary>
/// Creates a new friend.
/// </summary>
/// <param name="username">The username.</param>
/// <returns></returns>
public static User NewFriend(string username)
{
User friend = null;
try
{
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
{
connection.Open();
SqlCommand command = new SqlCommand("SELECT id, email FROM [User] WHERE username = @username", connection);
command.Parameters.AddWithValue("@username", username);
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
friend = new User(Convert.ToInt32(reader["id"]), username, reader["email"].ToString());
}
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
return friend;
}
public List<Contact> GetAllContactsForUser(User objUser) {
return _Container.Contacts.Where(contact => contact.UserId == objUser.Id).ToList();
}
/// <summary>
/// Deprecated Method for adding a new object to the User EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToUser(User user)
{
base.AddObject("User", user);
}
/// <summary>
/// Create a new User object.
/// </summary>
/// <param name="id">Initial value of the Id property.</param>
/// <param name="name">Initial value of the Name property.</param>
/// <param name="password">Initial value of the Password property.</param>
/// <param name="loginName">Initial value of the LoginName property.</param>
public static User CreateUser(global::System.Int32 id, global::System.String name, global::System.String password, global::System.String loginName)
{
User user = new User();
user.Id = id;
user.Name = name;
user.Password = password;
user.LoginName = loginName;
return user;
}
/// <summary>Updates the details of an existing User whose Email property matches the Email property of the one given.</summary>
/// <param name="updatedUser">The User object which contains the updated details.</param>
public static void UpdateUser(User updatedUser)
{
if (_sessionUser == null)
throw new NotLoggedInException();
if (_sessionUser.Type != UserType.admin
&& !(_sessionUser.Email.Equals(updatedUser.Email) && _sessionUser.Type == updatedUser.Type))
throw new InsufficientRightsException();
if (updatedUser == null
|| updatedUser.Email == null
|| updatedUser.Password == null)
throw new InadequateObjectException();
if (!UserExists(updatedUser.Email))
throw new OriginalNotFoundException();
using (var client = new ServiceClient())
{
client.UpdateUser(updatedUser);
}
}
/// <summary>Logs out the active user.</summary>
public static void LogOut()
{
if (_sessionUser == null)
throw new NotLoggedInException();
_sessionUser = null;
}
private void vilketprov(User u)
{
NpgsqlConnection conn = new NpgsqlConnection(WebConfigurationManager.ConnectionStrings["JE-banken"].ConnectionString);
if (u.licensed == true) //Ladda ÅKU kunskapstest på 15 Frågor
{
string sql = "SELECT EXISTS(SELECT 1 FROM knowledgetest WHERE employeenumber=" + u.employeenumber + ")";
NpgsqlCommand cmd = new NpgsqlCommand(sql, conn);
conn.Open();
bool exists = Convert.ToBoolean(cmd.ExecuteScalar());
conn.Close();
if (exists)
{
string sql2 = "SELECT * FROM knowledgetest WHERE employeenumber=" + u.employeenumber;
NpgsqlCommand cmd2 = new NpgsqlCommand(sql2, conn);
conn.Open();
NpgsqlDataReader dr2 = cmd2.ExecuteReader();
bool passed;
DateTime dt;
DateTime today = DateTime.Today;
while (dr2.Read())
{
dt = Convert.ToDateTime(dr2["date"]);
passed = Convert.ToBoolean(dr2["passed"]);
if (passed)
{
if ((today - dt).Days > 365)
{
loadForm(true); //Ladda ÅKU kunskapstest på 15 Frågor
}
else
{
Session["date"] = dt.AddYears(1);
Response.Redirect("~/passed.aspx");
}
}
if (!passed)
{
if ((today - dt).Days > 7)
{
loadForm(true); //Ladda ÅKU kunskapstest på 15 Frågor
}
else
{
Session["date"] = dt.AddDays(7);
Response.Redirect("~/passed.aspx");
}
}
}
conn.Close();
}
if (!exists)
{
string sql3 = "SELECT * FROM licensetest WHERE employeenumber=" + u.employeenumber;
NpgsqlCommand cmd3 = new NpgsqlCommand(sql3, conn);
conn.Open();
NpgsqlDataReader dr3 = cmd3.ExecuteReader();
bool passed;
DateTime dt;
DateTime today = DateTime.Today;
while (dr3.Read())
{
dt = Convert.ToDateTime(dr3["date"]);
passed = Convert.ToBoolean(dr3["passed"]);
if (passed)
{
if ((today - dt).Days > 365)
{
loadForm(true); //Ladda ÅKU
}
else
{
Session["date"] = dt.AddYears(1);
Response.Redirect("~/passed.aspx");
}
}
}
conn.Close();
}
}
if (u.licensed == false) //Ladda Licensetest på 25 Frågor
{
string sql = "SELECT * FROM licensetest WHERE employeenumber=" + u.employeenumber;
NpgsqlCommand cmd = new NpgsqlCommand(sql, conn);
conn.Open();
NpgsqlDataReader dr = cmd.ExecuteReader();
bool passed;
DateTime dt;
DateTime today = DateTime.Today;
while (dr.Read())
{
dt = Convert.ToDateTime(dr["date"]);
passed = Convert.ToBoolean(dr["passed"]);
if (!passed)
{
if ((today - dt).Days > 7)
{
loadForm(false); //Ladda Licensetest på 25 Frågor
}
else
{
Session["date"] = dt.AddDays(7);
Response.Redirect("~/passed.aspx");
}
}
}
conn.Close();
}
if(u.licensed == null)
{
loadForm(false);
}
}
private void LogIn()
{
if (Text1.Value != "")
{
if (Text2.Value != "")
{
User u = new User();
List<string> listOfUsers = new List<string>();
string connectionString = WebConfigurationManager.ConnectionStrings["JE-Banken"].ConnectionString;
NpgsqlConnection conn = new NpgsqlConnection(connectionString);
string sql = "SELECT username FROM employees";
NpgsqlCommand cmd = new NpgsqlCommand(sql, conn);
conn.Open();
NpgsqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
listOfUsers.Add(dr["username"].ToString());
}
conn.Close();
if (listOfUsers.Contains(Text1.Value))
{
string sql2 = "SELECT * FROM employees WHERE username='******'";
NpgsqlCommand cmd2 = new NpgsqlCommand(sql2, conn);
conn.Open();
NpgsqlDataReader dr2 = cmd2.ExecuteReader();
while (dr2.Read())
{
u.password = dr2["password"].ToString();
u.employeenumber = Convert.ToInt32(dr2["employeenumber"]);
if (Convert.ToString(dr2["licensed"]) == "")
{
u.licensed = null;
}
else
{
u.licensed = Convert.ToBoolean(dr2["licensed"]);
}
}
if (u.password == Text2.Value)
{
u.password = Text2.Value;
u.username = Text1.Value;
Session["user"] = u;
if(u.username == "Admin")
{
Response.Redirect("~/Admin.aspx");
}
else
{
Response.Redirect("~/Formular.aspx");
}
}
else
{
Label1.Text = "Fel lösenord.";
}
}
else
{
Label1.Text = "Fel användarnamn.";
}
}
else
{
Label1.Text = "Ange lösenord.";
}
}
else
{
Label1.Text = "Ange användarnamn.";
}
}
public void CreateUserTest()
{
User testuserA = new User();
testuserA.Email = "*****@*****.**";
testuserA.Password = "******";
testuserA.Type = UserType.admin;
User testuserS = new User();
testuserS.Email = "*****@*****.**";
testuserS.Password = "******";
testuserS.Type = UserType.standard;
using (ShimsContext.Create())
{
ShimServiceClient.AllInstances.GetUserByEmailString = (a, b) => testuserA;
ShimServiceClient.AllInstances.CreateUserUser = (a, b) => { };
Controller.LogIn("*****@*****.**", "101");
Controller.CreateUser(testuserS);
}
// Controller.LogOut(); <- No need to log out after each test, it's done automatically :)
}
public void AddContact(User objUser, Contact objContact) {
User tempUser = _Container.Users.FirstOrDefault(user => user.Id == objUser.Id);
tempUser.Contacts.Add(objContact);
_Container.SaveChanges();
}
public void deletingUser()
{
User testAdmin = new User();
testAdmin.Email = "*****@*****.**";
testAdmin.Password = "******";
testAdmin.Type = UserType.admin;
User testuser = new User();
testuser.Email = "*****@*****.**";
testuser.Password = "******";
testuser.Type = UserType.standard;
using (ShimsContext.Create())
{
ShimServiceClient.AllInstances.GetUserByEmailString = (a, b) =>
{
if (b.Equals(testAdmin.Email)) { return testAdmin; } else { return testuser; }
};
ShimServiceClient.AllInstances.CreateUserUser = (a, b) => { };
ShimServiceClient.AllInstances.DeleteUserByEmailString = (a, b) => { };
Controller.LogIn("*****@*****.**", "ta123");
try
{
Controller.CreateUser(testuser);
}
catch (Exception e)
{
//User not created. Something is wrong
}
Controller.DeleteUserByEmail("*****@*****.**");
}
}
/// <summary>
/// Loads the user.
/// </summary>
/// <param name="username">The username.</param>
/// <param name="pass">The pass.</param>
/// <returns></returns>
public static User LoadUser(string email, string pass)
{
User user = null;
try
{
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
{
connection.Open();
SqlCommand command = new SqlCommand("SELECT id, username FROM [User] WHERE email = @mail AND password = @pass", connection);
command.Parameters.AddWithValue("@mail", email);
command.Parameters.AddWithValue("@pass", pass);
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
user = new User(Convert.ToInt32(reader["id"]), reader["username"].ToString(), email);
}
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
return user;
}
public void LoginTest()
{
User testuser = new User();
testuser.Email = "*****@*****.**";
testuser.Password = "******";
testuser.Type = UserType.standard;
using (ShimsContext.Create())
{
ShimServiceClient.AllInstances.GetUserByEmailString = (a, b) => testuser;
Controller.LogIn("*****@*****.**", "123");
}
}
private void loadusers()
{
NpgsqlConnection conn = new NpgsqlConnection(WebConfigurationManager.ConnectionStrings["JE-banken"].ConnectionString);
string sql = "SELECT * FROM employees";
NpgsqlCommand cmd = new NpgsqlCommand(sql, conn);
conn.Open();
NpgsqlDataReader dr = cmd.ExecuteReader();
List<User> userlist = new List<User>();
while (dr.Read())
{
User u = new User();
u.fullname = Convert.ToString(dr["fullname"]);
u.employeenumber = Convert.ToInt16(dr["employeenumber"]);
u.username = Convert.ToString(dr["username"]);
if(Convert.ToString(dr["licensed"]) != "")
{
u.licensed = Convert.ToBoolean(dr["licensed"]);
}
userlist.Add(u);
}
conn.Close();
DropDownList1.Items.Add("---");
foreach (User user in userlist.OfType<User>())
{
DropDownList1.Items.Add(new ListItem(user.fullname, user.employeenumber.ToString()));
}
}
public void sessioning1()
{
User test = new User();
test.Email = "*****@*****.**";
test.Password = "******";
test.Type = UserType.admin;
Package p = new Package();
p.Id = 1001;
p.Name = "p1001";
p.OwnerEmail = "*****@*****.**";
p.FileIds = new int[] {092};
FileInfo fi = new FileInfo();
fi.Id = 092;
fi.Name = "testItem";
fi.OwnerEmail = "*****@*****.**";
fi.Type = FileType.text;
FileInfo fiu = new FileInfo();
fiu.Id = 092;
fiu.Name = "UpdatedtestItem";
fiu.OwnerEmail = "*****@*****.**";
fiu.Type = FileType.text;
Right r = new Right();
r.ItemId = 092;
r.Type = RightType.edit;
r.Until = DateTime.Now.AddDays(1);
r.UserEmail = "*****@*****.**";
using (ShimsContext.Create())
{
ShimServiceClient.AllInstances.GetUserByEmailString = (a, b) => test;
ShimServiceClient.AllInstances.CreatePackagePackage = (a, b) => {return 1;};
ShimServiceClient.AllInstances.GetPackageByIdInt32 = (a, b) => {return p;};
ShimServiceClient.AllInstances.AddToPackageInt32ArrayInt32 = (a, b, c) => {};
ShimServiceClient.AllInstances.GetFileInfoByIdInt32 = (a, b) => {return fi;};
ShimServiceClient.AllInstances.AddTagStringInt32 = (a, b, c) => { };
ShimServiceClient.AllInstances.DeleteFileByIdInt32 = (a, b) => { };
ShimServiceClient.AllInstances.GetRightStringInt32 = (a, b, c) => {return r;};
ShimServiceClient.AllInstances.UpdateFileInfoFileInfo = (a, b) => { };
Controller.LogIn("*****@*****.**", "test");
Controller.CreatePackage(p);
Controller.AddToPackage(new int[]{092},1001);
Controller.AddTag("tag1", 092);
Controller.DeleteFileById(092);
try
{
Controller.UpdateFileInfo(fiu);
} catch(OriginalNotFoundException e){
//This should be thrown
}
}
}
private void usersToTable()
{
NpgsqlConnection conn = new NpgsqlConnection(WebConfigurationManager.ConnectionStrings["JE-banken"].ConnectionString);
string sql = "SELECT * FROM employees";
NpgsqlCommand cmd = new NpgsqlCommand(sql, conn);
conn.Open();
NpgsqlDataReader dr = cmd.ExecuteReader();
List<User> userlist = new List<User>();
while (dr.Read())
{
User u = new User();
u.fullname = Convert.ToString(dr["fullname"]);
u.employeenumber = Convert.ToInt16(dr["employeenumber"]);
u.username = Convert.ToString(dr["username"]);
if(Convert.ToString(dr["licensed"]) == "")
{
u.licensed = null;
}
else
{
u.licensed = Convert.ToBoolean(dr["licensed"]);
}
u.lastTest = "";
u.lastTestScore = "";
DateTime today = DateTime.Today;
u.nextTest = today.ToShortDateString();
userlist.Add(u);
}
conn.Close();
foreach (User u in userlist)
{
string sql2 = "SELECT * FROM licensetest";
u.lastTestType = "licensetest";
if (u.licensed == true)
{
string sql3 = "SELECT EXISTS(SELECT * FROM knowledgetest WHERE employeenumber=" + u.employeenumber+")";
NpgsqlCommand cmd3 = new NpgsqlCommand(sql3, conn);
conn.Open();
bool exists = Convert.ToBoolean(cmd3.ExecuteScalar());
conn.Close();
if (exists)
{
sql2 = "SELECT * FROM knowledgetest";
u.lastTestType = "ÅKU";
}
else
{
sql2 = "SELECT * FROM licensetest";
u.lastTestType = "licensetest";
}
}
if(u.licensed == null)
{
u.lastTestType = "";
}
NpgsqlCommand cmd2 = new NpgsqlCommand(sql2, conn);
conn.Open();
NpgsqlDataReader dr2 = cmd2.ExecuteReader();
while (dr2.Read())
{
if (Convert.ToInt32(u.employeenumber) == Convert.ToInt32(dr2["employeenumber"]))
{
DateTime lastTest = Convert.ToDateTime(dr2["date"]);
u.lastTest = lastTest.ToShortDateString();
u.lastTestScore = Convert.ToString(dr2["score"]);
if(dr2["passed"] != null)
{
u.pasedlastest = Convert.ToBoolean(dr2["passed"]);
if (Convert.ToBoolean(dr2["passed"]))
{
DateTime nextTest = lastTest.AddYears(1);
u.nextTest = nextTest.ToShortDateString();
}
if (!Convert.ToBoolean(dr2["passed"]))
{
DateTime nextTest = lastTest.AddDays(7);
u.nextTest = nextTest.ToShortDateString();
}
}
}
}
conn.Close();
}
TableHeaderRow HEADER = new TableHeaderRow();
Table1.Rows.Add(HEADER);
TableHeaderCell cellName = new TableHeaderCell();
cellName.Text = "Namn";
HEADER.Cells.Add(cellName);
TableHeaderCell cellEmployeenumber= new TableHeaderCell();
cellEmployeenumber.Text = "Anställningsnummer";
HEADER.Cells.Add(cellEmployeenumber);
TableHeaderCell cellLatestTest = new TableHeaderCell();
cellLatestTest.Text = "Senaste prov";
HEADER.Cells.Add(cellLatestTest);
TableHeaderCell cellLatestTestType = new TableHeaderCell();
cellLatestTestType.Text = "License/ÅKU";
HEADER.Cells.Add(cellLatestTestType);
TableHeaderCell cellLatestScore = new TableHeaderCell();
cellLatestScore.Text = "Senaste resultat";
HEADER.Cells.Add(cellLatestScore);
TableHeaderCell cellNextTest = new TableHeaderCell();
cellNextTest.Text = "Nästa prov";
HEADER.Cells.Add(cellNextTest);
foreach (User u in userlist)
{
TableRow row = new TableRow();
Table1.Rows.Add(row);
TableCell name = new TableCell();
name.Text = u.fullname;
row.Cells.Add(name);
TableCell employeenumber = new TableCell();
employeenumber.Text = u.employeenumber.ToString() ;
row.Cells.Add(employeenumber);
TableCell latestTest = new TableCell();
latestTest.Text = u.lastTest.ToString() ;
row.Cells.Add(latestTest);
TableCell latestTestType = new TableCell();
latestTestType.Text = u.lastTestType;
row.Cells.Add(latestTestType);
TableCell latestScore = new TableCell();
latestScore.Text = u.lastTestScore;
if(latestScore.Text != "")
{
if (u.pasedlastest)
{
latestScore.ForeColor = Color.Green;
}
if (!u.pasedlastest)
{
latestScore.ForeColor = Color.Red;
}
}
row.Cells.Add(latestScore);
TableCell NextTest = new TableCell();
NextTest.Text = u.nextTest.ToString();
if(Convert.ToDateTime(u.nextTest) < DateTime.Today)
{
NextTest.Text = DateTime.Today.ToShortDateString();
}
row.Cells.Add(NextTest);
}
}
public void StandardCreateUser()
{
User testuserS1 = new User();
User testuser = new User();
testuserS1.Email = "*****@*****.**";
testuserS1.Password = "******";
testuserS1.Type = UserType.standard;
testuser.Email = "*****@*****.**";
testuser.Password = "******";
testuser.Type = UserType.standard;
using (ShimsContext.Create())
{
ShimServiceClient.AllInstances.GetUserByEmailString = (a, b) => testuserS1;
Controller.LogIn("*****@*****.**", "201");
try
{
Controller.CreateUser(testuser); //this should fail
}
catch (Exception e)
{
//User not created. All is good.
}
}
// Controller.LogOut(); <- No need to log out after each test, it's done automatically :)
}
public void SetCurrentUser(User CurrUser)
{
CurrentUser = CurrUser;
}
/// <summary>Create a new User on the service.</summary>
/// <param name="newUser">The User object that should be created on the service.</param>
public static void CreateUser(User newUser)
{
if (_sessionUser == null)
throw new NotLoggedInException();
if (_sessionUser.Type != UserType.admin)
throw new InsufficientRightsException();
if (newUser == null
|| newUser.Email == null
|| newUser.Password == null)
throw new InadequateObjectException();
if (UserExists(newUser.Email))
throw new KeyOccupiedException();
using (var client = new ServiceClient())
{
client.CreateUser(newUser);
}
}
