Ejemplo n.º 1
0
 protected void Page_Load(object sender, EventArgs e)
 {
     u = (User)Session["User"];
     if (u == null) Response.Redirect("Login.apsx");
     if (!IsPostBack && u != null)
     {
        txtEditUserFirstname.Text = u.Firstname;
        txtEditUserLastname.Text = u.Lastname;
        txtEditUserEmail.Text = u.Email;
     }
 }
Ejemplo n.º 2
0
Archivo: Main.cs Proyecto: hotmike49/PM
 //Methode überprüft Userlogin und gibt ein Userobjekt zurpück wenn der Login erfolgreich war
 public static User checkLogin(string username, string pw)
 {
     string SQL = "select Username, Firstname, Lastname, Email from [User] where Username = @username and Password = @pw";
     SqlCommand cmd = new SqlCommand();
     cmd.CommandText = SQL;
     cmd.Connection = Main.GetConnection();
     cmd.Parameters.Add(new SqlParameter("username", username));
     cmd.Parameters.Add(new SqlParameter("pw", pw));
     SqlDataReader reader = cmd.ExecuteReader();
     User u = new User();
     if (reader.HasRows){
         reader.Read();
         u.Username = reader.GetString(0);
         u.Firstname = reader.GetString(1);
         u.Lastname = reader.GetString(2);
         u.Email = reader.GetString(3);
         return u;
     }
     else return null;
 }
Ejemplo n.º 3
0
Archivo: User.cs Proyecto: hotmike49/PM
        /************************************************************************************************************
        STATISCHE METHODEN
        internal bedeutet, dass sie nur von Klassen aus BOKunden (aus dem eigenem Namespace) aufgerufen werden können
        - also nicht direkt aus dem PL

        Die Methoden sind im BOKunde-Objekt, damit der BO-Programmierer alle SQL-Statements, die Kunden betreffen, an einer Stelle hat
        Der PL-Programmierer sieht diese Implementation aber nicht. Er sieht die Methoden, von wo aus er diese Objekte "bekommt"
        (also entsprechend der Navigability). Man hätte diese Methoden technisch aber problemlos auch in die cMain geben können!
        */
        // Laden aller Tasks die einem User zugeordnet sind
        internal static Users LoadTaskUsers(Task t)
        {
            if (t.ID != "")
            {
                SqlCommand cmd = new SqlCommand("select u.Firstname, u.Lastname, u.Username, u.Email from UserTask as ut inner join User as t on ut.Username = u.Username where TaskID = @tid", Main.GetConnection());
                cmd.Parameters.Add(new SqlParameter("tid", t.ID));
                SqlDataReader reader = cmd.ExecuteReader();
                Users taskUsers = new Users();
                while (reader.Read())
                {
                    User u = new User();
                    u.Firstname = reader.GetString(0);
                    u.Lastname = reader.GetString(1);
                    u.Username = reader.GetString(2);
                    u.Email = reader.GetString(3);
                    taskUsers.Add(u);
                }
                return taskUsers;
            }
            else return null;
        }
Ejemplo n.º 4
0
Archivo: User.cs Proyecto: hotmike49/PM
 internal static Users LoadProjectUsers(Project p)
 {
     if (p.ID != "")
     {
         SqlCommand cmd = new SqlCommand("select u.Firstname, u.Lastname, u.Username, u.Email from UserProject as up inner join [User] as u on up.Username = u.Username where ProjectID = @pid", Main.GetConnection());
         cmd.Parameters.Add(new SqlParameter("pid", p.ID));
         SqlDataReader reader = cmd.ExecuteReader();
         Users projectUsers = new Users();
         while (reader.Read())
         {
             User u = new User();
             u.Firstname = reader.GetString(0);
             u.Lastname = reader.GetString(1);
             u.Username = reader.GetString(2);
             u.Email = reader.GetString(3);
             projectUsers.Add(u);
         }
         return projectUsers;
     }
     else return null;
 }
Ejemplo n.º 5
0
Archivo: User.cs Proyecto: hotmike49/PM
 internal static Users LoadAllUsers()
 {
     SqlCommand cmd = new SqlCommand("select Firstname, Lastname, Username, Email from [User]", Main.GetConnection());
     SqlDataReader reader = cmd.ExecuteReader();
     Users allUsers = new Users();
     while (reader.Read())
     {
         User u = new User();
         u.Firstname = reader.GetString(0);
         u.Lastname = reader.GetString(1);
         u.Username = reader.GetString(2);
         u.Email = reader.GetString(3);
         allUsers.Add(u);
     }
     return allUsers;
 }
Ejemplo n.º 6
0
Archivo: Task.cs Proyecto: hotmike49/PM
        // Laden aller Tasks die einem User zugeordnet sind
        internal static Tasks LoadUserTasks(User u)
        {
            SqlCommand cmd = new SqlCommand("select t.TaskID, t.WorkPackageID, t.Name, t.CreatedDate, t.EndDate, t.Description  from UserTask as ut inner join Task as t on ut.TaskID = t.TaskID where Username = @username and t.status = '0'", Main.GetConnection());
            cmd.Parameters.Add(new SqlParameter("username", u.Username));
            SqlDataReader reader = cmd.ExecuteReader();
            Tasks userTasks = new Tasks();
            while (reader.Read()) {
                Task t = new Task();
                t.ID = reader.GetString(0);
                t.WorkPackageID = reader.GetString(1);
                t.Name = reader.GetString(2);
                t.CreatedDate = Convert.ToDateTime(reader["CreatedDate"]);
                t.EndDate = Convert.ToDateTime(reader["EndDate"]);
                t.Description = reader.GetString(5);

                userTasks.Add(t);
            }
            return userTasks;
        }
Ejemplo n.º 7
0
Archivo: Task.cs Proyecto: hotmike49/PM
 // Laden aller User die einem Task zugeordnet sind
 public Users loadTaskUsers()
 {
     SqlCommand cmd = new SqlCommand("select u.Username, u.Firstname, u.Lastname, u.Email from UserTask as ut inner join [User] as u on ut.Username = u.Username where TaskID = @tid", Main.GetConnection());
     cmd.Parameters.Add(new SqlParameter("tid", mID));
     SqlDataReader reader = cmd.ExecuteReader();
     Users taskUsers = new Users();
     while (reader.Read())
     {
         User u = new User();
         u.Username = reader.GetString(0);
         u.Firstname = reader.GetString(1);
         u.Lastname = reader.GetString(2);
         u.Email = reader.GetString(3);
         taskUsers.Add(u);
     }
     return taskUsers;
 }