public string CheckUser(string email, string password)
{
using (var context = new AdmitereLicentaContext())
{
var user = (from c in context.Candidatis
where c.Email == email
select c.ID_Candidat
).SingleOrDefault();
if (user == 0)
{
return "WrongUser";
}
else
{
var pass = (from c in context.Utilizatoris
where c.ID_Candidat == user && c.Parola == password
select c.Parola
).SingleOrDefault();
if (pass == null)
{
return "WrongPassword";
}
else
{
currentUser = Decimal.ToInt32(user);
return "Corect";
}
}
}
}
public IEnumerable<Departament> ReadDepartments(int facultyId)
{
using (var context = new AdmitereLicentaContext())
{
var department = context.Departaments.Where(n => n.ID_Facultate == facultyId).ToList();
return department;
}
}
public IEnumerable<Specializari> ReadSpecialization(int departementId)
{
using (var context = new AdmitereLicentaContext())
{
var specialization = context.Specializaris.Where(n => n.ID_Departament == departementId).ToList();
return specialization;
}
}
public IEnumerable<Facultati> ReadFaculties()
{
using (var context = new AdmitereLicentaContext())
{
var fac = (from n in context.Facultatis
select n).ToList<Facultati>();
return fac;
}
}
public IEnumerable<Rezultate_probe> ReadRezultate(int proba)
{
using (var context = new AdmitereLicentaContext())
{
var query = from u in context.Rezultate_probe
where u.ID_Proba == proba
select u;
query.OrderBy(n => n.ID_Proba).ThenByDescending(n => n.Nota).ToList();
return query.ToList<Rezultate_probe>();
}
}
public IEnumerable<Candidati>ReadAllOlimpici()
{
using (var context = new AdmitereLicentaContext())
{
var query = from n in context.Candidatis
join u in context.Olimpicis
on n.ID_Candidat equals u.ID_Candidat
select n;
return query.ToList<Candidati>();
}
}
public bool ChangePassword(string email, string oldPass, string newPass)
{
using (var context = new AdmitereLicentaContext())
{
using (var transaction = context.Database.BeginTransaction())
{
try
{
var query = (from n in context.Candidatis
join u in context.Utilizatoris
on n.ID_Candidat equals u.ID_Candidat
where n.Email == email && u.Parola == oldPass && n.ID_Candidat == currentUser
select u
).ToList<Utilizatori>().FirstOrDefault();
if (query != null)
{
query.Parola = newPass;
context.Utilizatoris.Add(query);
context.Entry(query).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
transaction.Commit();
return true;
}
else
return false;
}
catch (Exception ex)
{
transaction.Rollback();
return false;
}
}
}
}
public IEnumerable<Beneficiari> ReadAllBeneficiari()
{
using (var context = new AdmitereLicentaContext())
{
var query = context.Beneficiaris;
return query.ToList();
}
}
public Locuri_taxa ReadLocuriTaxa(string specialization)
{
using (var context = new AdmitereLicentaContext())
{
var query = (from n in context.Specializaris
join l in context.Locuri_taxa
on n.ID_Specializare equals l.ID_Specializare
where n.Nume_specializare == specialization
select l).FirstOrDefault();
return query;
}
}
public Specializari ReadOneSpecialization(int specializationID)
{
using (var context = new AdmitereLicentaContext())
{
var specialization = context.Specializaris.Where(n => n.ID_Specializare == specializationID).FirstOrDefault();
return specialization;
}
}
public IEnumerable<Locuri_taxa> ReadLocuriTaxa(int specialization)
{
using (var context = new AdmitereLicentaContext())
{
var query = context.Locuri_taxa.Where(n => n.ID_Specializare == specialization).ToList();
return query;
}
}
public IEnumerable<Probe> ReadTest()
{
using (var contest = new AdmitereLicentaContext())
{
var query = contest.Probes.ToList<Probe>();
return query;
}
}
public bool DeleteUserOption(int specID)
{
using (var context = new AdmitereLicentaContext())
{
using (var transaction = context.Database.BeginTransaction())
{
try
{
var query = (from n in context.Specializaris
join u in context.Optiunis
on n.ID_Specializare equals u.ID_Specializare
where n.ID_Specializare == specID
select u).ToList<Optiuni>().FirstOrDefault();
if (query != null)
{
context.Optiunis.Remove(query);
context.Entry(query).State = System.Data.Entity.EntityState.Deleted;
context.SaveChanges();
transaction.Commit();
return true;
}
else
return false;
}
catch (Exception ex)
{
transaction.Rollback();
return false;
}
}
}
}
public bool UpdateUserOption(int priority, string specialization)
{
using (var context = new AdmitereLicentaContext())
{
using (var transaction = context.Database.BeginTransaction())
{
try
{
var query = (from n in context.Candidatis
join u in context.Optiunis
on n.ID_Candidat equals u.ID_Candidat
join x in context.Specializaris
on u.ID_Specializare equals x.ID_Specializare
where n.ID_Candidat == currentUser && x.Nume_specializare == specialization
select u).ToList<Optiuni>().FirstOrDefault();
if (query != null)
{
query.Prioritate = Convert.ToDecimal(priority);
context.Optiunis.Add(query);
context.Entry(query).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
transaction.Commit();
return true;
}
else
return false;
}
catch(Exception ex)
{
transaction.Rollback();
return false;
}
}
}
}
public IEnumerable<Optiuni> ReadUserOption()
{
using (var context = new AdmitereLicentaContext())
{
var query = context.Optiunis.Where(n => n.ID_Candidat == currentUser).ToList<Optiuni>();
return query;
}
}
public string AddUserOption(string specializare, int prioritate, string isTaxa)
{
using (var context = new AdmitereLicentaContext())
{
using (var transaction = context.Database.BeginTransaction())
{
try
{
var q = (from c in context.Specializaris
where c.Nume_specializare == specializare
select c.ID_Specializare).FirstOrDefault();
if ( q == 0)
{
return "NoSpecialization";
}
var query = context.Optiunis;
foreach (var temp in query)
{
if (temp.ID_Specializare == q)
{
return "SpecializationExist";
}
}
var query2 = this.GetUserOptionOrderedByPriority();
bool flag = false;
foreach(var temp in query2)
{
if (temp.Prioritate == prioritate)
{
flag = true; ;
}
if (flag==true)
{
temp.Prioritate++;
this.UpdateUserOption(temp);
}
}
//var query = context.Specializaris.Where(n => n.Nume_specializare == specializare).First();
currentUser = 4;
var cand = this.GetCurrentUser();
var spec = context.Specializaris.Where(n => n.Nume_specializare == specializare).FirstOrDefault();
var option = new Optiuni();
option.ID_Candidat = 4;
option.Prioritate = prioritate;
option.Doreste_Taxa = isTaxa;
option.ID_Specializare = q;
option.Candidati = cand;
option.Specializari = spec;
context.Optiunis.Add(option);
context.Entry(option).State = System.Data.Entity.EntityState.Added;
context.SaveChanges();
transaction.Commit();
return "TransactionCorect";
}
catch (Exception ex)
{
transaction.Rollback();
return "TransactionFailed ad";
}
}
}
}
public IEnumerable<Rezultate_probe> ReadTestsResult()
{
using (var contest = new AdmitereLicentaContext())
{
//var query = (from n in contest.Rezultate_probe
// join p in contest.Probes
// on n.ID_Proba equals p.ID_Proba
// where n.ID_Candidat == currentUser
// select new { p.Nume_Proba, n.Nota }
// ).ToList();
var query = contest.Rezultate_probe.Where(n => n.ID_Candidat == currentUser).ToList<Rezultate_probe>();
return query;
}
}
public Locuri_buget ReadLocuriBuget(string specializationName, string beneficiarName)
{
using (var context = new AdmitereLicentaContext())
{
var query = (from n in context.Beneficiaris
join l in context.Locuri_buget
on n.ID_Beneficiar equals l.ID_Beneficiar
join s in context.Specializaris
on l.ID_Specializare equals s.ID_Specializare
where s.Nume_specializare == specializationName && n.Nume_beneficiar == beneficiarName
select l
).FirstOrDefault();
return query;
}
}
public Locuri_buget ReadLocuriBuget(int specializationID, int beneficiarID)
{
using (var context = new AdmitereLicentaContext())
{
var query = context.Locuri_buget.Where(n => n.ID_Beneficiar == beneficiarID && n.ID_Specializare == specializationID).FirstOrDefault();
return query;
}
}
public bool UpdateUserDetails(Candidati temp)
{
using (var context = new AdmitereLicentaContext())
{
using (var transaction = context.Database.BeginTransaction())
{
try
{
context.Candidatis.Add(temp);
context.Entry(temp).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
transaction.Commit();
return true;
}
catch (Exception ex)
{
transaction.Rollback();
return false;
}
}
}
}
public bool DeleteUser()
{
using (var context = new AdmitereLicentaContext())
{
using (var transaction = context.Database.BeginTransaction())
{
try
{
var query = context.Candidatis.Where(n => n.ID_Candidat == currentUser).ToList<Candidati>().FirstOrDefault();
if (query != null)
{
context.Candidatis.Remove(query);
context.Entry(query).State = System.Data.Entity.EntityState.Deleted;
context.SaveChanges();
transaction.Commit();
return true;
}
else
return false;
}
catch (Exception ex)
{
transaction.Rollback();
return false;
}
}
}
}
private Candidati GetCurrentUser()
{
using (var context = new AdmitereLicentaContext())
{
var cand = context.Candidatis.Where(n => n.ID_Candidat == currentUser).FirstOrDefault();
return cand;
}
}
public IEnumerable<Optiuni> GetUserOptionOrderedByPriority()
{
using (var context = new AdmitereLicentaContext())
{
var query = (from n in context.Optiunis
where n.ID_Candidat == currentUser
select n).ToList<Optiuni>();
return query;
}
}
//sergiu
public bool CheckEmail(string email)
{
using (var context = new AdmitereLicentaContext())
{
var query = context.Candidatis.Where(n => n.Email == email).FirstOrDefault();
if (query != null)
return true;
else
return false;
}
}
public string CreateUser(Dictionary<string, string> user)
{
using (var context = new AdmitereLicentaContext())
{
using (var transaction = context.Database.BeginTransaction())
{
try
{
var query = context.Candidatis.Where(n => n.CNP == Convert.ToDecimal(user["cnp"])).FirstOrDefault();
if (query == null)
{
var newUser = new Candidati();
newUser.Nume = user["nume"];
newUser.Prenume = user["prenume"];
newUser.CNP = Convert.ToDecimal(user["cnp"]);
newUser.Sex = user["sex"];
newUser.Adresa = user["adresa"];
newUser.Oras = user["oras"];
newUser.Judet = user["judet"];
newUser.Nr_telefon = Convert.ToDecimal(user["telefon"]);
newUser.Nationalitate = user["nationalitate"];
newUser.Religie = user["religie"];
newUser.Email = user["email"];
newUser.Nota_BAC = Convert.ToDecimal(user["bac"]);
context.Candidatis.Add(newUser);
context.Entry(newUser).State = System.Data.Entity.EntityState.Added;
context.SaveChanges();
transaction.Commit();
return "SuccessAdded";
}
else
return "UserExists";
}
catch (Exception ex)
{
transaction.Rollback();
return "TransactionFailed";
}
}
}
}
public Candidati ReadUserDetails()
{
using (var context = new AdmitereLicentaContext())
{
var query = context.Candidatis.Where(n => n.ID_Candidat == currentUser).ToList<Candidati>().FirstOrDefault();
return query;
}
}
public IEnumerable<Utilizatori> ReadPassword(string email)
{
using (var context = new AdmitereLicentaContext())
{
var query = from n in context.Candidatis
join u in context.Utilizatoris
on n.ID_Candidat equals u.ID_Candidat
where n.Email == email
select u;
return query.ToList();
}
}
