public IHttpActionResult updateData([FromBody] ModelUtilizatori usr)
{
UserServicies us = new UserServicies();
us.updateData(usr);
return(Ok());
}
public IHttpActionResult creeazaCont([FromBody] ModelUtilizatori spc)
{
AdministratorServicies spec = new AdministratorServicies();
spec.creeazaUser(spc);
return(Ok());
}
public string updateAccountsAdmin(ModelUtilizatori user)
{
AdministratorRepository up = new AdministratorRepository();
string testing1 = up.updateAccountsAdmin(user);
return(testing1);
}
public string creeazaUser(ModelUtilizatori newAcc)
{
AdministratorRepository spec = new AdministratorRepository();
string mesaj = spec.creeazaUser(newAcc);
return(mesaj);
}
public string updateData(ModelUtilizatori user)
{
SqlConnection conn = db.initializare();
SqlCommand cmd;
string testing1 = " ";
try
{
cmd = new SqlCommand(Query.updateAccount, conn);
cmd.Parameters.Add(new SqlParameter("idUtilizator", user.idUtilizator));
cmd.Parameters.Add(new SqlParameter("nume", user.nume));
cmd.Parameters.Add(new SqlParameter("prenume", user.prenume));
cmd.Parameters.Add(new SqlParameter("email", user.email));
cmd.Parameters.Add(new SqlParameter("parola", user.parola));
cmd.Parameters.Add(new SqlParameter("adresa", user.adresa));
cmd.Parameters.Add(new SqlParameter("numarTelefon", user.numarTelefon));
if (cmd.ExecuteNonQuery() == 1)
{
testing1 = "Profile updated successfully";
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Dispose();
conn.Close();
}
return(testing1);
}
public IHttpActionResult updateAccountsAdmin([FromBody] ModelUtilizatori usr)
{
AdministratorServicies us = new AdministratorServicies();
us.updateAccountsAdmin(usr);
return(Ok());
}
public string updateData(ModelUtilizatori user)
{
UserRepository up = new UserRepository();
string testing1 = up.updateData(user);
return(testing1);
}
public ModelUtilizatori getAllUserInformation(int idUtilizator)
{
UserRepository up = new UserRepository();
ModelUtilizatori user = null;
user = up.getAllUserInformation(idUtilizator);
return(user);
}
public ModelUtilizatori checkUserLogin(string email, string pass)
{
SqlConnection conn = db.initializare();
ModelUtilizatori user = null;
try
{
cmd = new SqlCommand(Query.loginCheck, conn);
cmd.Parameters.Add(new SqlParameter("email", email));
reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
int idUtilizator = Int32.Parse(reader["id_utilizator"].ToString());
string nume = reader["nume"].ToString();
string prenume = reader["prenume"].ToString();
email = reader["email"].ToString();
string parola = reader["parola"].ToString();
string adresa = reader["adresa"].ToString();
string numarTelefon = reader["nr_telefon"].ToString();
bool conectat = bool.Parse(reader["conectat"].ToString());
string statut = reader["statut"].ToString();
int idRol = Int32.Parse(reader["id_rol"].ToString());
string numeMaterie = "blank";
string denumireRol = reader["denumire"].ToString();
user = new ModelUtilizatori(idUtilizator, nume, prenume, email, parola, adresa, numarTelefon, conectat, statut, idRol, numeMaterie, denumireRol);
if (pass == user.parola)
{
user.statusConectare = "Conectare cu succes";
}
else
{
user.statusConectare = "Parola gresita";
}
}
}
else
{
user = new ModelUtilizatori();
user.statusConectare = "Utilizator inexistent";
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Dispose();
conn.Close();
}
return(user);
}
public static ModelUtilizatori userLogin(string email, string pass)
{
UserRepository up = new UserRepository();
ModelUtilizatori user = up.checkUserLogin(email, pass);
if (user.statusConectare == "Conectare cu succes")
{
up.updateLogin(user.idUtilizator, true);
}
return(user);
}
public ModelUtilizatori detaliiCont(int idUtilizator)
{
SqlConnection conn = db.initializare();
SqlCommand cmd;
List <ModelUtilizatori> listaConturi = new List <ModelUtilizatori>();
ModelUtilizatori cont = null;
try
{
cmd = new SqlCommand(Query.detaliiCont, conn);
cmd.Parameters.Add(new SqlParameter("idUtilizator", idUtilizator));
reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
idUtilizator = Int32.Parse(reader["id_utilizator"].ToString());
string nume = reader["nume"].ToString();
string prenume = reader["prenume"].ToString();
string email = reader["email"].ToString();
string parola = reader["parola"].ToString();
string adresa = reader["adresa"].ToString();
string numarTelefon = reader["nr_telefon"].ToString();
bool conectat = bool.Parse(reader["conectat"].ToString());
string statut = reader["statut"].ToString();
int idRol = Int32.Parse(reader["id_rol"].ToString());
cont = new ModelUtilizatori(idUtilizator, nume, prenume, email, parola, adresa, numarTelefon, conectat, statut, idRol);
listaConturi.Add(cont);
}
}
else
{
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Dispose();
conn.Close();
}
return(cont);
}
public static ModelUtilizatori detaliiCont(int idUtilizator)
{
{
AdministratorRepository up = new AdministratorRepository();
ModelUtilizatori listaConturi = null;
try
{
listaConturi = up.detaliiCont(idUtilizator);
}
catch (Exception ex)
{
//mesajele de eroare se logheaz in baza de date intr-o tabela de log-uri
var mesajEroare = ex.Message + "-" + ex.InnerException;;
}
return(listaConturi);
}
}
public string creeazaUser(ModelUtilizatori newAcc)
{
SqlConnection conn = db.initializare();
SqlCommand cmd;
string mesaj = " ";
try
{
cmd = new SqlCommand("insertAnewAccAndANewStudent", conn);
cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.Add(new SqlParameter("idSpecializare", specializare.idSpecializare));
cmd.Parameters.Add(new SqlParameter("@nume", newAcc.nume));
cmd.Parameters.Add(new SqlParameter("@prenume", newAcc.prenume));
cmd.Parameters.Add(new SqlParameter("@email", newAcc.email));
cmd.Parameters.Add(new SqlParameter("@parola", newAcc.parola));
cmd.Parameters.Add(new SqlParameter("@adresa", newAcc.adresa));
cmd.Parameters.Add(new SqlParameter("@idRol", newAcc.idRol));
cmd.Parameters.Add(new SqlParameter("@conectat", newAcc.conectat));
cmd.Parameters.Add(new SqlParameter("@nrTelefon", newAcc.numarTelefon));
cmd.Parameters.Add(new SqlParameter("@idSpecializare", newAcc.idSpecializare));
if (cmd.ExecuteNonQuery() == 1)
{
mesaj = "Cont creat cu succes";
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Dispose();
conn.Close();
}
return(mesaj);
}
public string creeazaUser(ModelUtilizatori newAcc)
{
SqlConnection conn = db.initializare();
SqlCommand cmd;
string mesaj = " ";
try
{
cmd = new SqlCommand(Query.createAccount, conn);
//cmd.Parameters.Add(new SqlParameter("idSpecializare", specializare.idSpecializare));
cmd.Parameters.Add(new SqlParameter("nume", newAcc.nume));
cmd.Parameters.Add(new SqlParameter("prenume", newAcc.prenume));
cmd.Parameters.Add(new SqlParameter("email", newAcc.email));
cmd.Parameters.Add(new SqlParameter("parola", newAcc.parola));
cmd.Parameters.Add(new SqlParameter("adresa", newAcc.adresa));
cmd.Parameters.Add(new SqlParameter("idRol", newAcc.idRol));
cmd.Parameters.Add(new SqlParameter("conectat", newAcc.conectat));
cmd.Parameters.Add(new SqlParameter("numarTelefon", newAcc.numarTelefon));
cmd.Parameters.Add(new SqlParameter("idSpecializare", newAcc.idSpecializare));
if (cmd.ExecuteNonQuery() == 1)
{
mesaj = "Cont creat cu succes";
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Dispose();
conn.Close();
}
return(mesaj);
}
