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());
}
