public Casier Chercher(int ID)
{
Casier c = null;
if (con.State != ConnectionState.Open)
{
con.Open();
}
try
{
IDbCommand com = con.CreateCommand();
com.CommandText = "SELECT * FROM Casier WHERE IdCasier=" + ID.ToString();
IDataReader reader = com.ExecuteReader();
if (reader.Read())
{
c = reader2Casier(reader);
}
}
finally
{
con.Close();
}
return(c);
}
public void operatiiCasier(Casier c, int optiune)
{
try
{
c.Password = encrypt(c.Password);
helper.OpenConnection();
if (optiune == (int)E.CREATE)
{
helper.Session.Save(c);
}
else if (optiune == (int)E.UPDATE)
{
helper.Session.Update(c);
}
else if (optiune == (int)E.DELETE)
{
helper.Session.Delete(c);
}
helper.Commit();
}
catch (Exception ex)
{
System.Windows.MessageBox.Show(ex.ToString());
}
finally
{
helper.CloseConnection();
}
}
public void Créer(Casier c)
{
con.Open();
try
{
IDbCommand com = con.CreateCommand();
com.CommandText = "SELECT Max(IdCasier) FROM Casier;";
IDataReader reader = com.ExecuteReader();
int id = 0;
try
{
if (reader.Read())
{
id = Convert.ToInt32(reader[0]);
}
}
catch { }
c.Id = id;
con.Close();
con.Open();
com.CommandText = "INSERT INTO Casier(IdCasier,NomCasier, Largeur_X, Largeur_Y) VALUES('" + (id + 1) + "', '" + c.Nom + "', '" + c.LargeurX + "', '" + c.LargeurY + "')";
com.ExecuteNonQuery();
}
finally
{
con.Close();
}
}
private void Autentificare_Click(object sender, EventArgs e)
{
User user = new User(view.getUser(), view.getPass());
Admin resultAdmin = userRepo.getAdminByAccount(user);
SpectacolRepository spectacolRepo = new SpectacolRepository();
if (resultAdmin == null)
{
Casier resultCasier = userRepo.getCasierByAccount(user);
if (resultCasier == null)
{
view.showMessage("Date incorecte");
}
else
{
CasierView casierView = new CasierView();
CasierController cc = new CasierController(casierView, spectacolRepo);
view.showMessage("Bine ai venit, " + resultCasier.Nume + " !");
view.closeWindow();
casierView.Show();
}
}
else
{
AdminView adminView = new AdminView();
AdminController ac = new AdminController(adminView, userRepo, spectacolRepo);
view.showMessage("Bine ai venit, " + resultAdmin.Username + " !");
view.closeWindow();
adminView.Show();
}
//Casier result = UserRepository.getCasierByAccount(user);
//view.showMessage(user.Username + " " + user.Password);
}
private Casier reader2Casier(IDataReader reader)
{
Casier c = new Casier();
c.Id = Convert.ToInt32(reader["IdCasier"]);
c.Nom = reader["NomCasier"].ToString();
c.LargeurX = Convert.ToInt32(reader["Largeur_X"]);
c.LargeurY = Convert.ToInt32(reader["Largeur_Y"]);
return(c);
}
public void Supprimer(Casier c)
{
con.Open();
try
{
IDbCommand com = con.CreateCommand();
com.CommandText = "DELETE FROM Casier WHERE IdCasier=" + c.Id.ToString();
com.ExecuteNonQuery();
}
finally
{
con.Close();
}
}
public void Sauver(Casier c)
{
con.Open();
try
{
IDbCommand com = con.CreateCommand();
com.CommandText = "UPDATE Casier SETNomCasier='" + c.Nom + "' WHERE IdCasier=" + c.Id.ToString();
com.ExecuteNonQuery();
}
finally
{
con.Close();
}
}
private void UpdateCasier_Click(object sender, EventArgs e)
{
Casier c = view.getCasier();
if (c != null)
{
userRepo.operatiiCasier(c, 1);
//view.clearCasierTextboxes();
view.populateTable(userRepo.getCasieri(), ModificareCont_Click);
}
else
{
view.showMessage("NU ati completat toate campurile");
}
}
public void test3()
{
//delete casier
Casier c = new Casier();
c.Nume = "Ionescu Ana";
c.Username = "******";
c.Password = "******";
_userRepo.operatiiCasier(c, 2);//delete
List <Casier> lc = _userRepo.getCasieri();
Casier ctest = lc.Where(x => x.Nume == c.Nume).SingleOrDefault();
Assert.IsTrue(ctest == null);
}
public void test2()
{
//update casier
Casier c = new Casier();
c.Nume = "Ionescu Ana";
c.Username = "******";
c.Password = "******";
_userRepo.operatiiCasier(c, 1); //update
c.Password = "******"; //metoda de mai sus schimba datele
List <Casier> lc = _userRepo.getCasieri();
Casier ctest = lc.Where(x => x.Nume == c.Nume).SingleOrDefault();
Assert.IsTrue(ctest.ToString() == c.ToString());
}
public Casier getCasier()
{
Casier c = new Casier();
c.Nume = numeTextBox.Text;
c.Username = userCasierTextBox.Text;
c.Password = parolaCasierTextBox.Text;
if (c.Nume != "" && c.Username != "" && c.Password != "")
{
return(c);
}
else
{
return(null);
}
}
public void Relire(Casier c)
{
con.Open();
try
{
IDbCommand com = con.CreateCommand();
com.CommandText = "SELECT * FROM Casier WHERE IdCasier=" + c.Id.ToString();
IDataReader reader = com.ExecuteReader();
if (reader.Read())
{
c.Nom = reader["NomCasier"].ToString();
}
}
finally
{
con.Close();
}
}
public Casier getCasierByAccount(User a)
{
Casier casierNou = new Casier();
try
{
helper.OpenConnection();
casierNou = helper.Session.QueryOver <Casier>().Where(x => x.Username == a.Username && x.Password == encrypt(a.Password)).SingleOrDefault();
helper.Commit();
}
catch (Exception ex)
{
System.Windows.MessageBox.Show(ex.ToString());
}
finally
{
helper.CloseConnection();
}
return(casierNou);
}
public Bouteilles Lister(Casier c)
{
Bouteilles liste = new Bouteilles();
con.Open();
try
{
IDbCommand com = con.CreateCommand();
com.CommandText = "SELECT * FROM Bouteille WHERE IdCasier=" + c.Id.ToString();
IDataReader reader = com.ExecuteReader();
while (reader.Read())
{
Bouteille b = reader2Bouteille(reader);
liste.Ajouter(b);
}
}
finally
{
con.Close();
}
return(liste);
}
public Casiers Lister()
{
Casiers liste = new Casiers();
con.Open();
try
{
IDbCommand com = con.CreateCommand();
com.CommandText = "SELECT * FROM Casier";
IDataReader reader = com.ExecuteReader();
while (reader.Read())
{
Casier c = reader2Casier(reader);
liste.Ajouter(c);
}
}
finally
{
con.Close();
}
return(liste);
}
public Casiers Lister(Cave c)
{
Casiers liste = new Casiers();
con.Open();
try
{
IDbCommand com = con.CreateCommand();
com.CommandText = "SELECT * FROM Casier WHERE IdCave=" + c.Id.ToString();
IDataReader reader = com.ExecuteReader();
while (reader.Read())
{
Casier cd = reader2Casier(reader);
liste.Ajouter(cd);
}
}
finally
{
con.Close();
}
return(liste);
}
private Bouteille reader2BouteilleRecherche(IDataReader reader)
{
Bouteille bouteille = new Bouteille();
bouteille.Texte = reader[1].ToString();
bouteille.Id = Convert.ToInt32(reader[0]);
bouteille.PosX = Convert.ToInt32(reader[3]);
bouteille.PosY = Convert.ToInt32(reader[4]);
bouteille.Bue = Convert.ToBoolean(reader[2]);
Casier c = new Casier();
c.Id = Convert.ToInt32(reader[5]);
c.Nom = reader[16].ToString();
bouteille.Casier = c;
Metier.Type t = new Metier.Type();
t.Id = Convert.ToInt32(reader[6]);
t.NomType = reader[21].ToString();
bouteille.Type = t;
try
{
Region r = new Region();
r.Id = Convert.ToInt32(reader[7]);
r.NomRegion = reader[24].ToString();
bouteille.Region = r;
}
catch { }
try
{
Pays p = new Pays();
p.Id = Convert.ToInt32(reader[8]);
p.NomPays = reader[26].ToString();
bouteille.Pays = p;
}
catch { }
try
{
Domaine d = new Domaine();
d.Id = Convert.ToInt32(reader[9]);
d.NomDomaine = reader[28].ToString();
bouteille.Domaine = d;
}
catch { }
try
{
Contenance co = new Contenance();
co.Id = Convert.ToInt32(reader[10]);
co.Valeur = Convert.ToInt32(reader[30]);
bouteille.Contenance = co;
}
catch { }
try
{
Cru cr = new Cru();
cr.Id = Convert.ToInt32(reader[11]);
cr.NomCru = reader[32].ToString();
bouteille.Cru = cr;
}
catch { }
try
{
Millesime m = new Millesime();
m.Id = Convert.ToInt32(reader[12]);
m.NomMillesime = reader[34].ToString();
bouteille.Millesime = m;
}
catch { }
try
{
Type_vinification tv = new Type_vinification();
tv.Id = Convert.ToInt32(reader[13]);
tv.NomVinif = reader[36].ToString();
bouteille.Type_vinification = tv;
}
catch { }
try
{
Appelation a = new Appelation();
a.Id = Convert.ToInt32(reader[14]);
a.NomAppelation = reader[38].ToString();
bouteille.Appelation = a;
}
catch { }
return(bouteille);
}
