public static UtilizatorModel Logare(string connectionStrin, string email, string parola) { UtilizatorModel utilizator = new UtilizatorModel(); using (SqlConnection con = new SqlConnection(connectionStrin)) { con.Open(); string cmdText = "Select email,parola,nume,prenume from utilizatori where email = @email and parola = @parola"; using (SqlCommand cmd = new SqlCommand(cmdText, con)) { cmd.Parameters.AddWithValue("email", email); cmd.Parameters.AddWithValue("parola", parola); using (SqlDataReader rdr = cmd.ExecuteReader()) { if (rdr.Read()) { utilizator = new UtilizatorModel { email = (string)rdr["email"], parola = (string)rdr["parola"], nume = (string)rdr["nume"], prenume = (string)rdr["prenume"] }; } } } } return(utilizator); }
public static int VerificaImprumuturi(UtilizatorModel utilizator) { int i = 0; using (SqlConnection con = new SqlConnection(ConnectionString)) { con.Open(); DateTime data = DateTime.Now.AddDays(-30); string cmdText = "Select * from imprumut where email = @email and data_imprumut > @data"; using (SqlCommand cmd = new SqlCommand(cmdText, con)) { cmd.Parameters.AddWithValue("email", utilizator.email); cmd.Parameters.AddWithValue("data", data); using (SqlDataReader rdr = cmd.ExecuteReader()) { while (rdr.Read()) { i++; } } } } return(i); }
public void Insert(UtilizatorModel utilizatorModel) { var utilizator = utilizatorModel.ToEntity(); utilizator.Parola = Utilities.GetHash("ParolaDefault"); UtilizatorHelper.Insert(utilizator); }
private void button2_Click(object sender, EventArgs e) { if (textBox4.Text == textBox5.Text) { UtilizatorModel utilizator = new UtilizatorModel { email = textBox1.Text, nume = textBox2.Text, prenume = textBox3.Text, parola = textBox4.Text }; try { SqlDataAcces.Registrare(SqlDataAcces.ConnectionString, utilizator); utilizator = SqlDataAcces.Logare(SqlDataAcces.ConnectionString, textBox1.Text, textBox4.Text); MessageBox.Show("Inregistrare cu succes!"); this.Close(); this.Visible = false; (Owner as FreeBookHome).Autentificat(utilizator); } catch (Exception) { MessageBox.Show("Email-ul este deja utilizat!"); } } else { MessageBox.Show("Confirmare parola nu corespunde"); } }
public ActionResult Edit(int id, UtilizatorModel utilizator) { if (ModelState.IsValid) { new UtilizatorBusiness().Update(utilizator); } return(View()); }
public ActionResult Create(UtilizatorModel utilizatorModel) { if (ModelState.IsValid) { new UtilizatorBusiness().Insert(utilizatorModel); return(RedirectToAction("Index")); } return(View()); }
public void Autentificat(UtilizatorModel utilizator) { var page = new MeniuFreeBook { utilizator = utilizator }; //MessageBox.Show("Logare cu succes!"); this.Visible = false; page.ShowDialog(this); }
public static Utilizator ToEntity(this UtilizatorModel utilizatorModel) { return(new Utilizator() { ID = utilizatorModel.ID, Username = utilizatorModel.Username, IDFunctie = utilizatorModel.IDFunctie, Email = utilizatorModel.Email, Prenume = utilizatorModel.Prenume, Nume = utilizatorModel.Nume, IDElev = utilizatorModel.IDElev }); }
private void button2_Click(object sender, EventArgs e) { UtilizatorModel utilizator = SqlDataAcces.Logare(SqlDataAcces.ConnectionString, textBox1.Text, textBox4.Text); if (utilizator.email == textBox1.Text) { this.Close(); this.Visible = false; (Owner as FreeBookHome).Autentificat(utilizator); } else { MessageBox.Show("Eroare autentificare!"); } }
public static void Registrare(string connectionStrin, UtilizatorModel utilizator) { using (SqlConnection con = new SqlConnection(connectionStrin)) { con.Open(); string cmdText = "Insert into utilizatori (email,parola,nume,prenume) values (@email,@parola,@nume,@prenume);"; using (SqlCommand cmd = new SqlCommand(cmdText, con)) { cmd.Parameters.AddWithValue("email", utilizator.email); cmd.Parameters.AddWithValue("parola", utilizator.parola); cmd.Parameters.AddWithValue("nume", utilizator.nume); cmd.Parameters.AddWithValue("prenume", utilizator.prenume); cmd.ExecuteNonQuery(); } } }
public static void ImprumutaCarte(int idCarte, UtilizatorModel utilizator) { using (SqlConnection con = new SqlConnection(ConnectionString)) { con.Open(); string cmdText = "Insert into imprumut ( id_carte, email, data_imprumut ) values " + "(@idCarte, @email, @data)"; using (SqlCommand cmd = new SqlCommand(cmdText, con)) { DateTime data = DateTime.Now; cmd.Parameters.AddWithValue("idCarte", idCarte); cmd.Parameters.AddWithValue("email", utilizator.email); cmd.Parameters.AddWithValue("@data", data); cmd.ExecuteNonQuery(); } } }
public static List <ImprumutModel> GetImprumuturiUtilizator(UtilizatorModel utilizator) { List <ImprumutModel> imprumuturi = new List <ImprumutModel>(); int i = 0; using (SqlConnection con = new SqlConnection(ConnectionString)) { con.Open(); string cmdText = "Select c.id_carte, c.titlu, c.autor, i.data_imprumut from carti c, imprumut i where c.id_carte = i.id_carte and i.email = @email"; using (SqlCommand cmd = new SqlCommand(cmdText, con)) { cmd.Parameters.AddWithValue("email", utilizator.email); using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { i++; DateTime date = (DateTime)reader[3]; ImprumutModel imprumut = new ImprumutModel { Index = i, IDCarte = (int)reader[0], Titlu = (string)reader[1], Autor = (string)reader[2], DataImprumut = date, DataDisponibilitate = date.AddDays(30) }; imprumuturi.Add(imprumut); } } } } return(imprumuturi); }
public void Update(UtilizatorModel utilizatorModel) { UtilizatorHelper.Update(utilizatorModel.ToEntity()); }