private static void cadastrar()
{
System.Console.WriteLine("Digite o nome:");
string nome = System.Console.ReadLine();
System.Console.WriteLine("Digite o salário");
decimal salario = decimal.Parse(System.Console.ReadLine());
var prof = new ProfessorDTO()
{
Nome = nome,
Salario = salario
};
Uri uri = new ProfessorRepository().Cadastrar(prof);
if (uri != null)
{
System.Console.WriteLine("Url {0}", uri.ToString());
}
else
{
System.Console.WriteLine("Cadastro não realizado!");
}
}
public async void RemoverProfessor(Professor professorDeletado)
{
if (professorDeletado.Id == 0 || !(Professores.Any(x => x.Id == professorDeletado.Id)))
{
await App.Current.MainPage.DisplayAlert("Ooops!", "O item selecionado p/ remoção não é válido!", "Ok");
return;
}
var confirm = await App.Current.MainPage.DisplayAlert("Você tem certeza?", "Após a confirmação esta ação não poderá ser desfeita!", "Sim, remova!", "Cancelar");
if (confirm)
{
var result = await ProfessorRepository.DeleteProfessorSqlAzureAsync(professorDeletado.Id.ToString());
if (result)
{
await App.Current.MainPage.DisplayAlert("Sucesso!", "Deletado com sucesso!", "Ok");
CarregarProfessores(true);
return;
}
else
{
await App.Current.MainPage.DisplayAlert("Oops!", "Ocorreu um erro ao remover!", "Ok");
}
}
}
public async Task Carregar()
{
await ProfessorRepository.GetProfessoresSqlAzureAsync().ContinueWith(retorno =>
{
CopiaListaProfessores = retorno.Result.ToList();
});
AplicarFiltro();
}
public async Task <bool> Carregar()
{
CopiaListaProfessores = await ProfessorRepository.GetProfessoresSqlAzureAsync();
AplicarFiltro();
return(true);
}
public async Task Carregar()
{
await ProfessorRepository.GetProfessores().ContinueWith(retorno => {
CopiarListaProfessores = retorno.Result.ToList();
});
Filtro();
}
public OfferingsController()
{
_termRepository = new TermRepository();
_offeringRepository = new OfferingRepository();
_courseRepository = new CourseRepository();
_professorRepository = new ProfessorRepository();
_scheduleRepository = new ScheduleRepository();
}
private static void Listar()
{
IEnumerable <ProfessorDTO> lista = new ProfessorRepository().Listar();
foreach (var item in lista)
{
System.Console.WriteLine("id: {0} Nome do Professor {1}, Salário {2}", item.Id, item.Nome, item.Salario);
}
}
public async void Adicionar(Professor paramProfessor)
{
if ((paramProfessor == null) || (string.IsNullOrWhiteSpace(paramProfessor.Nome)))
await App.Current.MainPage.DisplayAlert("Atenção", "O campo nome é obrigatório", "OK");
else if (await ProfessorRepository.PostProfessorSqlAzureAsync(paramProfessor))
await App.Current.MainPage.Navigation.PopAsync();
else
await App.Current.MainPage.DisplayAlert("Falhou", "Desculpe, ocorreu um erro inesperado =(", "OK");
}
public UnitOfWork(SWEContext context)
{
this.context = context;
Facultie = new FacultieRepository(context);
Department = new DepartmentRepository(context);
Professor = new ProfessorRepository(context);
Student = new StudentRepository(context);
StudentLog = new StudentLogRepository(context);
Course = new CourseRepository(context);
}
public async void Carregar()
{
CopiaListaProfessores = await ProfessorRepository.GetProfessoresSqlAzureAsync();
CopiaListaProfessores.ForEach(x => {
Professores.Add(x);
});
AplicarFiltro();
}
public ProfessorViewModel()
{
OnSairCMD = new Command(OnSair);
OnNovoCMD = new Command(OnNovo);
OnAdicionarProfessorCMD = new OnAdicionarProfessorCMD(this);
OnEditarProfessorCMD = new OnEditarProfessorCMD(this);
OnDeleteProfessorCMD = new OnDeleteProfessorCMD(this);
ProfessorList = ProfessorRepository.GetProfessoresSqlAzureAsync().Result;
}
public async void Remove(Professor professor)
{
bool action = await App.Current.MainPage.DisplayAlert("Atenção", $"Deseja remover o {professor.Name}?", "Sim", "Não");
if (action)
{
await ProfessorRepository.DeleteProfessorAsync(professor.Id);
await App.Current.MainPage.DisplayAlert("Info", $"{professor.Name} removido com sucesso!", "Ok");
await LoadProfessors();
}
}
public ProfessorViewModel()
{
var teste = ProfessorRepository.GetProfessoresSqlAzureAsync();
OnAdicionarProfessorCMD = new OnAdicionarProfessorCMD(this);
OnEditarProfessorCMD = new OnEditarProfessorCMD(this);
OnDeleteProfessorCMD = new OnDeleteProfessorCMD(this);
OnSairCMD = new Xamarin.Forms.Command(OnSair);
OnNovoCMD = new Xamarin.Forms.Command(OnNovo);
CopiaListaProfessores = new List <Professor>();
Carregar();
}
public int RemoveProfessorScore(int?professoreCode, string term)
{
var scoreRepository = new ProfessorScoreRepository(new DatabaseFactory());
var prof = new ProfessorRepository(new DatabaseFactory());
var professor = prof.GetMany(x => x.ProfessorCode == professoreCode && x.Term.TermCode == term).FirstOrDefault();
return(scoreRepository.Delete(x => x.Professor.Id == professor.Id &&
!x.Score.Indicator.CountOfType.Contains("p7") &&
!x.Score.Indicator.CountOfType.Contains("p11") &&
!x.Score.Indicator.CountOfType.Contains("p12") &&
!x.Score.Indicator.CountOfType.Contains("p16"), true));
//else return -3000;
}
public async void CarregarProfessores(bool updateBase)
{
var professoresData = await ProfessorRepository.GetProfessoresSqlAzureAsync(updateBase);
if (professoresData != null)
{
Professores.Clear();
foreach (var prof in professoresData)
{
Professores.Add(prof);
}
}
}
public async void Remover()
{
if (await App.Current.MainPage.DisplayAlert("Atenção?",
string.Format("Tem certeza que deseja remover o {0}?", Selecionado.Nome), "Sim", "Não"))
{
if (await ProfessorRepository.DeleteProfessorSqlAzureAsync(Selecionado.Id.ToString()))
{
CopiaListaProfessores.Remove(Selecionado);
await Carregar();
}
else
await App.Current.MainPage.DisplayAlert(
"Falhou", "Desculpe, ocorreu um erro inesperado =(", "OK");
}
}
public async void Remover()
{
if (await App.Current.MainPage.DisplayAlert("Atenção",
string.Format("Tem certeza que deseja remover o {0}?", Professor.Nome), "Sim", "Não"))
{
if (ProfessorRepository.DeleteProfessorSqlAzureAsync(Professor.Id.ToString()).Result)
{
ProfessorList.Remove(Professor);
}
else
{
await App.Current.MainPage.DisplayAlert(
"Falhou", "Desculpe, ocorreu um erro inesperado =(", "OK");
}
}
}
static void Main(string[] args)
{
Endereco obj = new Endereco();
obj.Rua = "Rue Cadillac";
obj.Numero = 4020;
obj.Cep = "H1R1H8";
obj.Complemento = "Proximo ao metro Cadillac";
obj.IdEndereco = 1;
EnderecoRepository rep = new EnderecoRepository();
//rep.Insert(obj);
Console.WriteLine("Endereço gravado com sucesso!");
List <Endereco> lista = rep.SelectAll();
foreach (var item in lista)
{
Console.WriteLine("Rua: " + item.Rua);
Console.WriteLine("Numero: " + item.Numero);
Console.WriteLine("Cep: " + item.Cep);
Console.WriteLine("Complemento: " + item.Complemento);
Console.WriteLine("*********************************");
}
Professor professor = new Professor("Luka", 20.00, obj, "programacao");
Professor professor1 = new Professor("Joao", 15.00, obj, "matematica");
ProfessorRepository profrep = new ProfessorRepository();
profrep.Insert(professor1);
List <Professor> proflista = profrep.SelectAll();
foreach (var item in proflista)
{
Console.WriteLine("Nome: " + item.Nome);
Console.WriteLine("Salario: " + item.Salario);
Console.WriteLine("Endereco: " + item.Endereco.Rua + "\n" + item.Endereco.Numero);
Console.WriteLine("Disciplina: " + item.Disciplina);
Console.WriteLine("*********************************");
}
Console.ReadKey();
}
public async Task <ApiResponse> GetStateUser(string userId)
{
var isNumeric = int.TryParse(userId, out int resualt);
try
{
if (isNumeric)
{
var studentRepo = new StudentRepository();
var student = studentRepo.Select(studentCode: userId);
var professorRepo = new ProfessorRepository();
var professor = professorRepo.Select(professorCode: userId);
if (!(student is null))
{
var studentState = studentRepo.GetStateForTickets(studentCode: userId);
return(new ApiResponse
{
ErrorId = (int)Helper.ApiOutputError.NoError,
ErrorTitle = ((Helper.ApiOutputError)Helper.ApiOutputError.NoError).ToString(),
Result = studentState
});
}
if (!(professor is null))
{
var professorState = new UserTicketState();
return(new ApiResponse
{
ErrorId = (int)Helper.ApiOutputError.NoError,
ErrorTitle = ((Helper.ApiOutputError)Helper.ApiOutputError.NoError).ToString(),
Result = professorState
});
}
}
return(new ApiResponse
{
ErrorId = (int)Helper.ApiOutputError.NotExists,
ErrorTitle = ((Helper.ApiOutputError)Helper.ApiOutputError.NotExists).ToString(),
Result = null
});
}
catch (System.Exception ex)
{
throw;
}
}
public ActionResult <ApiResponse> Get(Helper.ObjectType objectType, string code, int randomNumber)
{
var smsRepository = new SmsRepository();
string mobile;
switch (objectType)
{
case Helper.ObjectType.Student:
var studentRepository = new StudentRepository();
mobile = studentRepository.Select(code).Mobile;
return(new ApiResponse
{
ErrorId = mobile == null || mobile.Trim() == ""
? (int)Helper.ApiOutputError.NotExists
: (int)Helper.ApiOutputError.NoError,
ErrorTitle = mobile == null || mobile.Trim() == ""
? ((Helper.ApiOutputError)Helper.ApiOutputError.NotExists).ToString()
: ((Helper.ApiOutputError)Helper.ApiOutputError.NoError).ToString(),
Result = $"{mobile}-{smsRepository.SendRandomNumber(mobile, randomNumber.ToString(), _config)}"
});
case Helper.ObjectType.Professor:
var professorRepository = new ProfessorRepository();
mobile = professorRepository.Select(code).Mobile;
return(new ApiResponse
{
ErrorId = mobile == null || mobile.Trim() == ""
? (int)Helper.ApiOutputError.NotExists
: (int)Helper.ApiOutputError.NoError,
ErrorTitle = mobile == null || mobile.Trim() == ""
? ((Helper.ApiOutputError)Helper.ApiOutputError.NotExists).ToString()
: ((Helper.ApiOutputError)Helper.ApiOutputError.NoError).ToString(),
Result = $"{mobile}-{smsRepository.SendRandomNumber(mobile, randomNumber.ToString(), _config)}"
});
default:
return(new ApiResponse());
}
}
private async Task HandleEdit(Professor professor)
{
bool result = await ProfessorRepository.PutProfessorAsync(professor);
if (result)
{
await App.Current.MainPage.Navigation.PopAsync();
await App.Current.MainPage.DisplayAlert("Info", $"{professor.Name} editado com sucesso!", "Ok");
await LoadProfessors();
}
else
{
await App.Current.MainPage.DisplayAlert("Atenção", $"Ocorreu um problema ao editar o {professor.Name}, " +
$"tente novamente mais tarde.", "Ok");
}
}
public async void Adicionar(Professor paramProfessor)
{
if ((paramProfessor == null) || (string.IsNullOrWhiteSpace(paramProfessor.Nome)))
{
await App.Current.MainPage.DisplayAlert("Atenção", "O campo nome é obrigatório", "OK");
}
var sucesso = await ProfessorRepository.PostProfessorSqlAzureAsync(paramProfessor);
if (sucesso)
{
CopiaListaProfessores.Add(paramProfessor);
Carregar();
await App.Current.MainPage.Navigation.PopAsync();
}
else
{
await App.Current.MainPage.DisplayAlert("Falhou", "Desculpe, ocorreu um erro inesperado =(", "OK");
}
}
public async void EditarProfessor(Professor professor)
{
if (string.IsNullOrWhiteSpace(professor.Nome) || string.IsNullOrWhiteSpace(professor.Titulo))
{
await App.Current.MainPage.DisplayAlert("Ooops!", "O item selecionado não é válido!", "Ok");
return;
}
var result = await ProfessorRepository.PutProfessorSqlAzureAsync(professor);
if (result)
{
await App.Current.MainPage.DisplayAlert("Sucesso!", "Professor editado com sucesso!", "Ok");
await App.Current.MainPage.Navigation.PopAsync();
return;
}
await App.Current.MainPage.DisplayAlert("Oops!", "Ocorreu um erro ao editar o professor!", "Ok");
}
public async Task <ApiResponse> GetUser(string userId)
{
var isNumeric = int.TryParse(userId, out int resualt);
if (isNumeric)
{
var studentRepo = new StudentRepository();
var student = studentRepo.Select(studentCode: userId);
var professorRepo = new ProfessorRepository();
var professor = professorRepo.Select(professorCode: userId);
if (!(student is null))
{
return new ApiResponse
{
ErrorId = (int)Helper.ApiOutputError.NoError,
ErrorTitle = ((Helper.ApiOutputError)Helper.ApiOutputError.NoError).ToString(),
Result = student
}
}
;
if (!(professor is null))
{
return new ApiResponse
{
ErrorId = (int)Helper.ApiOutputError.NoError,
ErrorTitle = ((Helper.ApiOutputError)Helper.ApiOutputError.NoError).ToString(),
Result = professor
}
}
;
}
return(new ApiResponse
{
ErrorId = (int)Helper.ApiOutputError.NotExists,
ErrorTitle = ((Helper.ApiOutputError)Helper.ApiOutputError.NotExists).ToString(),
Result = null
});
}
public void Init()
{
conection = new MSSQLDB(new DBConfiguration());
_PREP = new ProfessorRepository(conection);
_encryptor = new Encryptor();
handler = new ProfessorQueryHandler(_PREP);
var db = conection.GetCon();
var cpf = "357.034.413-40";
string password = cpf.Replace("-", "").Replace(".", "");
password = _encryptor.Encrypt(password, out string salt);
professor = new Professor("Lívia", "Emanuelly Elisa", cpf, "*****@*****.**", "(21) 2682-8370", EDegree.Master, password, salt);
_PREP.Create(professor);
commandGet = new ProfessorInputGet()
{
ProfessorId = professor.Id
};
}
public async void NovoProfessor(Professor professor)
{
if (string.IsNullOrWhiteSpace(professor.Nome) || string.IsNullOrWhiteSpace(professor.Titulo))
{
await App.Current.MainPage.DisplayAlert("Alerta!", "Todos os campos são obrigatórios!", "OK");
return;
}
// TODO: gerar um ID aletório com a data
professor.Id = (int)((DateTime.UtcNow - new DateTime(1970, 1, 1, 0, 0, 0, DateTimeKind.Utc)).TotalSeconds / 516);
var result = await ProfessorRepository.PostProfessorSqlAzureAsync(professor);
if (result)
{
await App.Current.MainPage.DisplayAlert("Sucesso!", "Professor adicionado com sucesso!", "Ok");
await App.Current.MainPage.Navigation.PopAsync();
return;
}
}
public void Init()
{
conection = new MSSQLDB(new DBConfiguration());
_PREP = new ProfessorRepository(conection);
_encryptor = new Encryptor();
handler = new ProfessorCommandHandler(_PREP, _encryptor);
var db = conection.GetCon();
var cpf = "357.034.413-40";
string password = cpf.Replace("-", "").Replace(".", "");
password = _encryptor.Encrypt(password, out string salt);
professor = new Professor("Lívia", "Emanuelly Elisa", cpf, "*****@*****.**", "(21) 2682-8370", EDegree.Master, password, salt);
_PREP.Create(professor);
commandRegister = new ProfessorInputRegister()
{
FirstName = "Lívia",
LastName = "Emanuelly Elisa",
CPF = cpf,
Email = "*****@*****.**",
Phone = "(21) 2682-8370",
Degree = EDegree.Master
};
commandUpdate = new ProfessorInputUpdate()
{
ProfessorId = professor.Id,
FirstName = "Lívia",
LastName = "Emanuelly Elisa",
Email = "*****@*****.**",
Phone = "(21) 2682-8370",
Degree = EDegree.Master
};
}
public ActionResult <ApiResponse> GetPicture(string code)
{
var studentRepo = new StudentRepository();
var studentPicture = studentRepo.Select(code, true)?.Picture;
if (studentPicture != null)
{
return(new ApiResponse
{
ErrorId = (int)Helper.ApiOutputError.NoError,
ErrorTitle = ((Helper.ApiOutputError)Helper.ApiOutputError.NoError).ToString(),
Result = studentPicture
});
}
var professorRepo = new ProfessorRepository();
var professorPicture = professorRepo.Select(code, true)?.Picture;
if (professorPicture != null)
{
return(new ApiResponse
{
ErrorId = (int)Helper.ApiOutputError.NoError,
ErrorTitle = ((Helper.ApiOutputError)Helper.ApiOutputError.NoError).ToString(),
Result = professorPicture
});
}
return(new ApiResponse
{
ErrorId = (int)Helper.ApiOutputError.NotExists,
ErrorTitle = ((Helper.ApiOutputError)Helper.ApiOutputError.NotExists).ToString(),
Result = "default"
});
}
public ActionResult <ApiResponse> Get(string code)
{
var studentRepo = new StudentRepository();
var student = studentRepo.Select(code);
if (student != null)
{
return(new ApiResponse
{
ErrorId = (int)Helper.ApiOutputError.NoError,
ErrorTitle = ((Helper.ApiOutputError)Helper.ApiOutputError.NoError).ToString(),
Result = student.Active
});
}
var professorRepo = new ProfessorRepository();
var professor = professorRepo.Select(code);
if (professor != null)
{
student.ObjectType = Helper.ObjectType.Professor;
return(new ApiResponse
{
ErrorId = (int)Helper.ApiOutputError.NoError,
ErrorTitle = ((Helper.ApiOutputError)Helper.ApiOutputError.NoError).ToString(),
Result = professor.Active
});
}
return(new ApiResponse
{
ErrorId = (int)Helper.ApiOutputError.NotExists,
ErrorTitle = ((Helper.ApiOutputError)Helper.ApiOutputError.NotExists).ToString(),
Result = "default"
});
}
public ProfessorController()
{
repo = new ProfessorRepository();
}