public void Run(string connection, string param)
{
Dictionary <string, string> args = GetArgs(param);
using (Context ctx = new Context(connection))
{
UserDataMapper usrMapper = new UserDataMapper(ctx);
ConferenceDataMapper confMapper = new ConferenceDataMapper(ctx);
User user = null;
Conference conf = null;
if (args.TryGetValue("-i", out string id))
{
user = usrMapper.Read(int.Parse(id));
}
if (args.TryGetValue("-c", out id))
{
conf = confMapper.Read(int.Parse(id));
}
if (conf != null && user != null)
{
int res = usrMapper.updateUserRole(user, conf);
Console.WriteLine(res == 1 ? "updated successfully!" : "couldn't give the role");
Console.WriteLine();
}
}
}
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> args = GetArgs(param);
using (Context ctx = new Context(connection))
{
ConferenceDataMapper confMapper = new ConferenceDataMapper(ctx);
Conference conference = null;
if (args.TryGetValue("-i", out string id))
{
conference = confMapper.Read(int.Parse(id));
}
foreach (KeyValuePair <string, string> idx in args)
{
switch (idx.Key)
{
case "-n":
conference.name = idx.Value;
break;
case "-y":
conference.year = int.Parse(idx.Value);
break;
case "-m":
conference.president.name = idx.Value;
break;
case "-d":
conference.limitDate = DateTime.Parse(idx.Value);
break;
case "-g":
conference.minGrade = int.Parse(idx.Value);
break;
}
}
Conference conf = confMapper.Update(conference);
Console.WriteLine(conf);
}
}
public void Run(string connection, string param)
{
using (Context ctx = new Context(connection))
{
ConferenceDataMapper confMapper = new ConferenceDataMapper(ctx);
List <Conference> conferences = confMapper.ReadAll();
foreach (Conference idx in conferences)
{
Console.WriteLine(string.Concat("id: ", idx.id));
Console.WriteLine(string.Concat("President: ", idx.president.name));
Console.WriteLine(string.Concat("President mail: ", idx.president.mail));
Console.WriteLine(string.Concat("Minimum Grade: ", idx.minGrade));
Console.WriteLine(string.Concat("Acronym: ", idx.acronym));
Console.WriteLine(string.Concat("name: ", idx.name));
Console.WriteLine(string.Concat("year: ", idx.year));
Console.WriteLine(string.Concat("Realization Date: ", idx.realizationDate));
Console.WriteLine(string.Concat("Date Line: ", idx.limitDate));
Console.WriteLine();
}
}
}
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!");
}
}
