public static void trackuser(User user, string connectionstring, string type) { using(OleDbConnection conn = new OleDbConnection(connectionstring)) { using (var command = new OleDbCommand()) { conn.Open(); command.Connection = conn; command.CommandType = System.Data.CommandType.Text; command.CommandText = "INSERT INTO TRACKING ([username], [firstname], [lastname], [email], [course], [group], [type]) VALUES (?,?,?,?,?,?,?)"; command.Parameters.Add("?", OleDbType.VarChar).Value = user.username; command.Parameters.Add("?", OleDbType.VarChar).Value = user.firstname; command.Parameters.Add("?", OleDbType.VarChar).Value = user.lastname; command.Parameters.Add("?", OleDbType.VarChar).Value = user.email; command.Parameters.Add("?", OleDbType.VarChar).Value = user.course1; command.Parameters.Add("?", OleDbType.VarChar).Value = user.group1; command.Parameters.Add("?", OleDbType.Integer).Value = (type.Equals("profesores")) ? 3 : 1; command.ExecuteNonQuery(); } } }
public Extraction getTeachers(string plantel, string connectionstring) { List<object[]> usersq = this.QueryFb(connectionstring, this.getTeacherQuery(plantel)); if (usersq.Count > 0) { Console.WriteLine(string.Format("{0} profesores a subir...", usersq.Count)); string planteldeco = this.plantel[0].ToString().ToUpper() + this.plantel.Substring(1); int cont = 0; foreach (object user in usersq) { User MyUser = new User(); try { MyUser.username = usersq[cont][0].ToString(); MyUser.password = usersq[cont][0].ToString(); MyUser.firstname = "Profesor"; MyUser.lastname = usersq[cont][1].ToString(); MyUser.email = usersq[cont][2].ToString().ToLower(); MyUser.course1 = usersq[cont][4].ToString(); MyUser.group1 = string.Format("{0}-{1}", usersq[cont][3].ToString(), planteldeco); MyUser.type1 = 3; } catch (Exception oe) { Console.WriteLine(oe.ToString()); this.Errors.Add(oe.Message.ToString()); } try { bool isvalid = MyUser.isValid(); if (isvalid) { this.Users.Add(MyUser); Console.WriteLine(string.Format("Se agrega {0} al envio...", MyUser.username)); } } catch (Exception oe) { this.Errors.Add(oe.Message.ToString()); Console.WriteLine(oe.Message.ToString()); } cont++; } } return this; }
public static bool uniqueinscription(User user, string connectionstring, string type) { bool val = false; using (OleDbConnection conn = new OleDbConnection(connectionstring)) { using (var command = new OleDbCommand()) { conn.Open(); command.Connection = conn; command.CommandType = System.Data.CommandType.Text; string sqlcommand = "SELECT [username] FROM TRACKING WHERE [username] = ? AND [course] = ?"; if (type.Equals("profesores")) { sqlcommand = "SELECT [username] FROM TRACKING WHERE [username] = ? AND [course] = ? AND [group] = ?"; } command.CommandText = sqlcommand; command.Parameters.Add("?", OleDbType.VarChar).Value = user.username; command.Parameters.Add("?", OleDbType.VarChar).Value = user.course1; if (type.Equals("profesores")) { command.Parameters.Add("?", OleDbType.VarChar).Value = user.group1; } OleDbDataReader reader = command.ExecuteReader(); val = reader.HasRows; } } if (val) { Console.WriteLine(string.Format("El usuario {0} ya está inscrito en el curso {1}.", user.username, user.course1)); } return val; }
public void toREST() { //Moodle.Instance.token = ConfigurationSettings.AppSettings["token"]; //Moodle.Instance.domain = "elearning.univermilenium.edu.mx"; //obtener id del curso //obtener id del grupo //obtener id del usuari //enrolar idusuario a curso //enrolar idusuario a grupo List<string> groups = new List<string>(); List<string> errors = new List<string>(); /* dummies users */ this.Users = new List<User>(); User dummy = new User(); dummy.username = "******"; dummy.firstname = "crash"; dummy.lastname = "test dummy"; dummy.password = "******"; dummy.email = "*****@*****.**"; dummy.course1 = "PRUEBA"; dummy.group1 = "GRUPODUMMIES"; dummy.type1 = 1; this.Users.Add(dummy); if (this.Users.Count() > 0) { foreach (User user in this.Users) { try { //obtener id del curso. MoodleCourse course = Moodle.Instance.getCourse(user.course1); //crear - obtener grupo if (Moodle.Instance.createGroup(course, user.course1, "Grupo para " + course.name)) { } } catch { this.Errors.Add(user.toString()); } } } }