public void Run(string connection, string param) { Dictionary <string, string> dic = GetArgs(param); using (Context ctx = new Context(connection)) { UserDataMapper usrMapper = new UserDataMapper(ctx); SubmissionDataMapper subMapper = new SubmissionDataMapper(ctx); User reviewer = null; Submission sub = null; string id; if (dic.TryGetValue("-ir", out id)) { reviewer = usrMapper.Read(int.Parse(id)); } if (dic.TryGetValue("-is", out id)) { sub = subMapper.Read(int.Parse(id)); } if (reviewer != null && sub != null) { int res = usrMapper.assignReviewerToReview(reviewer, sub); Console.WriteLine(res == 1 ? "successfully assign!" : "couldn't assign the reviewer to the review!"); Console.WriteLine(); } } }
internal List <Submission> LoadAuthors(User usr) { List <Submission> list = new List <Submission>(); SubmissionDataMapper subMapper = new SubmissionDataMapper(context); List <IDataParameter> parameters = new List <IDataParameter> { new SqlParameter("@id", usr.id) }; using (IDataReader reader = ExecuteReader("select idSubmissao from Autor_Submissao where idUtilizador=@id", parameters)) { while (reader.Read()) { int key = reader.GetInt32(0); list.Add(subMapper.Read(key)); } } return(list); }
public void Run(string connection, string param) { Dictionary <string, string> dic = GetArgs(param); Conference conf = null; State accepted = null; using (Context ctx = new Context(connection)) { ConferenceDataMapper confMapper = new ConferenceDataMapper(ctx); StateDataMapper stateMapper = new StateDataMapper(ctx); dic.TryGetValue("-ic", out string id); conf = confMapper.Read(int.Parse(id)); if (dic.TryGetValue("-l", out string limit)) { conf.minGrade = int.Parse(limit); confMapper.Update(conf); } List <State> x = stateMapper.ReadAll(); accepted = x.First(elem => elem.description.Equals("Aceite")); } using (Context ctx = new Context(connection)) { SubmissionDataMapper subMapper = new SubmissionDataMapper(ctx); List <int> submissions = subMapper.ReadAllByGrade(conf.minGrade, conf.id); List <Submission> list = new List <Submission>(); submissions.ForEach(idSub => { Submission sub = subMapper.Read(idSub); sub.state = accepted; list.Add(sub); }); list.ForEach(sub => { Submission entity = subMapper.Update(sub); if (!entity.Equals(sub)) { Console.WriteLine("updated"); } }); } }
public void Run(string connection, string param) { Dictionary <string, string> dic = GetArgs(param); using (Context ctx = new Context(connection)) { SubmissionDataMapper subMapper = new SubmissionDataMapper(ctx); ConferenceDataMapper confMapper = new ConferenceDataMapper(ctx); Conference conf = null; Submission sub = null; if (dic.TryGetValue("-is", out string id)) { sub = subMapper.Read(int.Parse(id)); } if (dic.TryGetValue("-ic", out id)) { conf = confMapper.Read(int.Parse(id)); } if (conf != null && sub != null) { List <User> list = subMapper.LoadCompatibleReviewers(sub, conf); Console.WriteLine(String.Concat("submission: ", sub.id)); Console.WriteLine("Reviewers Availables:"); Console.WriteLine(); list.ForEach(usr => { Console.WriteLine(String.Concat("name: ", usr.name)); Console.WriteLine(String.Concat("id: ", usr.id)); Console.WriteLine(String.Concat("mail: ", usr.mail)); Console.WriteLine(String.Concat("institution: ", usr.institution.name)); Console.WriteLine(); }); return; } Console.WriteLine("error type again!"); } }
public void Run(string connection, string param) { Dictionary <string, string> dic = GetArgs(param); using (Context ctx = new Context(connection)) { SubmissionDataMapper subMapper = new SubmissionDataMapper(ctx); Submission sub = null; if (dic.TryGetValue("-is", out string id)) { sub = subMapper.Read(int.Parse(id)); } if (sub != null) { dic.TryGetValue("-g", out string gradeString); dic.TryGetValue("-t", out string text); Int32.TryParse(gradeString, out int grade); subMapper.RegisterReview(sub, grade, text); Console.WriteLine("Submissio ID : " + sub.id); Console.WriteLine("Submission Grade : " + subMapper.LoadGrade(sub)); Console.WriteLine("Submission Review Text : " + subMapper.LoadText(sub)); } } }