public void Run(string connection, string param)
{
Dictionary <string, string> args = GetArgs(param);
string id = null, name = null, year = null, mail = null, date = null, grade = null;
using (si2Entities ctx = new si2Entities())
{
args.TryGetValue("-i", out id);
var conf = ctx.Conferencia.Find(int.Parse(id));
var president = ctx.Utilizador.Find(conf.idPresidente);
args.TryGetValue("-n", out name);
args.TryGetValue("-y", out year);
args.TryGetValue("-m", out mail);
args.TryGetValue("-d", out date);
args.TryGetValue("-g", out grade);
ctx.updateConference(
int.Parse(id),
name == null ? conf.nome : name,
year == null ? conf.ano : int.Parse(year),
mail == null ? president.mail : mail,
date == null ? conf.dataLimite : DateTime.Parse(date),
grade == null ? conf.notaMinima : int.Parse(grade)
);
ctx.Database.SqlQuery <Conferencia>("select * from Conferencia");
}
}
public void Run(string connection, string param)
{
using (var ctx = new si2Entities())
{
var total = ctx.Database.SqlQuery <Int32>("select count(*) from dbo.Submissao");
var accepted = ctx.Database.SqlQuery <Int32>("select count(*) from dbo.Submissao as s inner join dbo.Estado as e on " +
" (s.idEstado = e.id) where e.descricao ='Aceite'");
int t = total.ElementAt(0);
int a = accepted.ElementAt(0);
float res = ((float)a / (float)t) * 100;
Console.WriteLine(String.Concat("Percentage of accepted Submissions :", res));
Console.WriteLine();
}
}
public void Run(string connection, string param)
{
using (var ctx = new si2Entities())
{
Dictionary <string, string> dic = GetArgs(param);
int subId = -1;
int confId = -1;
if (dic.TryGetValue("-is", out string id))
{
subId = int.Parse(id);
}
if (dic.TryGetValue("-ic", out id))
{
confId = int.Parse(id);
}
if (subId != -1 && confId != -1)
{
SqlParameter p1 = new SqlParameter("@idSubmissao", SqlDbType.Int);
SqlParameter p2 = new SqlParameter("@idConf", SqlDbType.Int);
p1.Value = subId;
p2.Value = confId;
var reviewers = ctx.Database.SqlQuery <Utilizador>("select u.* from dbo.Utilizador as u " +
"inner join dbo.Registo as reg on (u.id = reg.idUtilizador) " +
"inner join dbo.Conferencia as conf on (reg.idConferencia = conf.id) " +
"where conf.id = @idConf and u.id not in (" +
"select idUtilizador " +
"from Autor_Submissao as au " +
"inner join Submissao_Conferencia as sc on (au.idSubmissao = sc.idSubmissao) " +
"where sc.idSubmissao = @idSubmissao)", p2, p1);
Console.WriteLine(String.Concat("submission: ", subId));
Console.WriteLine("Reviewers Availables:");
Console.WriteLine();
foreach (var reviewer in reviewers)
{
Console.WriteLine(String.Concat("name: ", reviewer.nome));
Console.WriteLine(String.Concat("id: ", reviewer.id));
Console.WriteLine(String.Concat("mail: ", reviewer.mail));
Console.WriteLine(String.Concat("institution: ", reviewer.idInstituicao));
Console.WriteLine();
}
}
}
}
public void Run(string connection, string param)
{
using (si2Entities ctx = new si2Entities())
{
Dictionary <string, string> dic = GetArgs(param);
dic.TryGetValue("-ic", out string id);
int conf = int.Parse(id);
if (dic.TryGetValue("-l", out string grade))
{
int limit = int.Parse(grade);
ctx.updateSubmissionsState(limit, conf);
}
else
{
ctx.updateSubmissionsState(null, conf);
}
Console.WriteLine("Submissions updated");
}
}
public void Run(string connection, string param)
{
Dictionary <string, string> args = GetArgs(param);
string id = null, ic = null;
using (si2Entities ctx = new si2Entities())
{
args.TryGetValue("-i", out id);
args.TryGetValue("-c", out ic);
if (id == null || ic == null)
{
Console.WriteLine("type an user id and a conference id");
return;
}
ctx.updateUserRole(
int.Parse(id),
int.Parse(ic)
);
ctx.Database.SqlQuery <Revisor>("select * from Revisor");
}
}
public void Run(string connection, string param)
{
Dictionary <string, string> dic = GetArgs(param);
string idReviewer = null, idSubmission = null;
using (var ctx = new si2Entities())
{
dic.TryGetValue("-ir", out idReviewer);
dic.TryGetValue("-is", out idSubmission);
if (idSubmission == null || idReviewer == null)
{
Console.WriteLine("Type a reviewer id and a submission id to assign the reviewer!\n");
return;
}
ctx.assignReviewerToReview(
int.Parse(idReviewer),
int.Parse(idSubmission)
);
ctx.Database.SqlQuery <Revisor_Submissao>("select * from Revisor_Submissao");
}
}
public void Run(string connection, string param)
{
using (var ctx = new si2Entities())
{
var conferences = ctx.Database.SqlQuery <Conferencia>("select * from Conferencia");
foreach (var conference in conferences)
{
var president = ctx.Database
.SqlQuery <Utilizador>("select * from Utilizador")
.Where(pres => pres.id == conference.idPresidente).First();
Console.WriteLine(string.Concat("id: ", conference.id));
Console.WriteLine(string.Concat("President: ", president.nome));
Console.WriteLine(string.Concat("President mail: ", president.mail));
Console.WriteLine(string.Concat("Minimum Grade: ", conference.notaMinima));
Console.WriteLine(string.Concat("Acronym: ", conference.acronimo));
Console.WriteLine(string.Concat("name: ", conference.nome));
Console.WriteLine(string.Concat("year: ", conference.ano));
Console.WriteLine(string.Concat("Realization Date: ", conference.dataRealizacao));
Console.WriteLine(string.Concat("Date Line: ", conference.dataLimite));
Console.WriteLine();
}
}
}
public void Run(string connection, string param)
{
Dictionary <string, string> dic = GetArgs(param);
string idSubmission = null, grade = null, text = null;
using (si2Entities ctx = new si2Entities())
{
dic.TryGetValue("-is", out idSubmission);
dic.TryGetValue("-g", out grade);
dic.TryGetValue("-t", out text);
if (idSubmission == null || grade == null || text == null)
{
Console.WriteLine("Type the submission id, the grade and the text related to the submission");
return;
}
ctx.registerReview(
int.Parse(idSubmission),
int.Parse(grade),
text
);
ctx.Database.SqlQuery <Revisor_Submissao>("select * from Revisor_Submissao");
Console.WriteLine();
}
}