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();
}
}
}
public void Run(string connection, string param)
{
using (Context ctx = new Context(connection))
{
SubmissionDataMapper subMapper = new SubmissionDataMapper(ctx);
decimal result = subMapper.calculateAcceptedSubmissions();
if (result != -1)
{
Console.WriteLine(String.Concat("percentage of acceptions: ", result));
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));
}
}
}
