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