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 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 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 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;
}
}
}
}
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 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";
}
}
}
}
