public static void remove <T>(List <T> list, int primPosition, int finalPosition)
{
if (list is List <Magazin> )
{
for (int i = primPosition; i < finalPosition; i++)
{
Object objects = list[i];
Magazin magazins = (Magazin)objects;
magazins.getListCereale().Clear();
magazins.getListLegume().Clear();
}
list.RemoveRange(--primPosition, --finalPosition);
}
else
{
list.RemoveRange(--primPosition, --finalPosition);
}
}
public static void remove <T>(List <T> list, int i)
{
if (list is List <Magazin> )
{
i--;
Object objects = list[i];
if (objects is Magazin)
{
Magazin magazins = (Magazin)objects;
magazins.getListCereale().Clear();
magazins.getListLegume().Clear();
list.RemoveAt(i);
}
}
else
{
list.RemoveAt(--i);
}
}
public void magazinTout()
{
Magazin magazin = null;
sqlConnection.Open();
SqlCommand sqlCommand = new SqlCommand("select * from Magazin", sqlConnection);
using (SqlDataReader reader = sqlCommand.ExecuteReader())
{
Program.getListMagazin().Clear();
while (reader.Read())
{
magazin=new Magazin();
magazin.id = Int32.Parse(reader[0].ToString());
magazin.nameMagazin = reader[1].ToString();
Program.getListMagazin().Add(magazin);
}
Program.magazinPrimar = magazin;
}
sqlCommand.Dispose();
sqlConnection.Close();
}
public void magazinTout()
{
Magazin magazin = null;
sqlConnection.Open();
SqlCommand sqlCommand = new SqlCommand("select * from Magazin", sqlConnection);
using (SqlDataReader reader = sqlCommand.ExecuteReader())
{
Program.getListMagazin().Clear();
while (reader.Read())
{
magazin = new Magazin();
magazin.id = Int32.Parse(reader[0].ToString());
magazin.nameMagazin = reader[1].ToString();
Program.getListMagazin().Add(magazin);
}
Program.magazinPrimar = magazin;
}
sqlCommand.Dispose();
sqlConnection.Close();
}
public static void addMagazin(int posInitial)
{
magazinPrimar = new Magazin();
listMagazin.Insert(--posInitial, magazinPrimar);
}
public static void addMagazin()
{
magazinPrimar = new Magazin();
listMagazin.Add(magazinPrimar);
}
static void Main(string[] args)
{
while (true)
{
Console.WriteLine("Menu");
Console.WriteLine("1. Adauga un magazin"); //
Console.WriteLine("2. Arata magazinele"); //
Console.WriteLine("3. Alege magazinul");
Console.WriteLine("4. Sterge magazin"); //
Console.WriteLine("5. Sterge o serie de magazine");
Console.WriteLine("6. Sortare magazine"); //
Console.WriteLine("7. Adauga mai multe magazine");
Console.WriteLine("8.Adauga la magazin ceva nou");
Console.WriteLine("9. Arata toate informatia despre magazin"); //
Console.WriteLine("10. Adauga o noua cereale "); //
Console.WriteLine("11. Adauga o noua lactata");
Console.WriteLine("12 Show listCereale"); //
Console.WriteLine("13 Show listLactate");
Console.WriteLine("14. Update magazin"); //
Console.WriteLine("15. update cereale");
Console.WriteLine("16. id Magazin"); // temporar
Console.WriteLine("Introduce o cifra ");
switch (Convert.ToInt32(Console.ReadLine()))
{
case 1:
new InsertDB().magazin();
//addMagazin();
break;
case 2:
new SelectDB().magazinTout();
show <Magazin>(listMagazin);
break;
case 3:
show <Magazin>(listMagazin);
Console.WriteLine("Alege Magazinul dorita");
int i = Convert.ToInt32(Console.ReadLine());
foreach (Magazin magazin in listMagazin)
{
if (magazin.id == i)
{
magazinPrimar = magazin;
}
}
break;
case 4:
Console.WriteLine("Introduce id la magazinul care doresti sa stergi");
int id = Convert.ToInt32(Console.ReadLine());
new DeleteDB().deleteMagazin(id);
//remove<Magazin>(listMagazin, idDelete());
break;
case 5:
Console.WriteLine("Introduce intre ce raza doriti sa stergeti elementele : ");
int primPosition = Convert.ToInt32(Console.ReadLine());
int finalPositon = Convert.ToInt32(Console.ReadLine());
remove <Magazin>(listMagazin, primPosition, finalPositon);
break;
case 6:
sorts <Magazin>(listMagazin);
break;
case 7:
Console.WriteLine("Alege positia initiala");
int init = Convert.ToInt32(Console.ReadLine());
Console.WriteLine("Numarul de date care doriti sa adaugati");
int nrDate = Convert.ToInt32(Console.ReadLine());
for (int j = 0; j < nrDate; j++)
{
addMagazin(init);
}
break;
case 8:
Console.WriteLine("1. Introduce ceriale");
Console.WriteLine("2. Arata ceriale");
Console.WriteLine("3. Sterge ceriale");
Console.WriteLine("4. Sterge mai mult ceriale");
Console.WriteLine("5. Sortare ceriale");
Console.WriteLine("6. Adauga mai multe ceriale");
Console.WriteLine("7. Introduce lactate");
Console.WriteLine("8. Arata lactate");
Console.WriteLine("9. Sterge lactate");
Console.WriteLine("10. Sterge mai multe lactate");
Console.WriteLine("11. Sortare lactate");
Console.WriteLine("12. Adauga mai multe lactate");
Console.WriteLine("Introduce o cifra ");
switch (Convert.ToInt32(Console.ReadLine()))
{
case 1:
showListCereale();
Console.WriteLine("introduceti care cereala doriti");
int ii = Convert.ToInt32(Console.ReadLine());
magazinPrimar.addProdus(listCereale[--ii]);
break;
case 2:
new SelectDB().cerealeMagazinID(magazinPrimar.id);
show <Cereale>(magazinPrimar.getListCereale());
break;
case 3:
remove <Cereale>(magazinPrimar.getListCereale(), idDelete());
break;
case 4:
Console.WriteLine("Introduce intre ce raza doriti sa stergeti elementele : ");
primPosition = Convert.ToInt32(Console.ReadLine());
finalPositon = Convert.ToInt32(Console.ReadLine());
remove <Cereale>(magazinPrimar.getListCereale(), primPosition, finalPositon);
break;
case 5:
sorts <Cereale>(magazinPrimar.getListCereale());
break;
case 6:
Console.WriteLine("Alege positia initiala");
init = Convert.ToInt32(Console.ReadLine());
Console.WriteLine("Numarul de date care doriti sa adaugati");
nrDate = Convert.ToInt32(Console.ReadLine());
for (int j = 0; j < nrDate; j++)
{
showListCereale();
Console.WriteLine("introduceti care cereala doriti");
ii = Convert.ToInt32(Console.ReadLine());
magazinPrimar.addProdus(listCereale[--ii], init);
}
break;
case 7:
showListLactate();
Console.WriteLine("introduceti care lactate doriti");
ii = Convert.ToInt32(Console.ReadLine());
magazinPrimar.addProdus(listLactate[--ii]);
break;
case 8:
show <Lactate>(magazinPrimar.getListLegume());
break;
case 9:
remove <Lactate>(magazinPrimar.getListLegume(), idDelete());
break;
case 10:
Console.WriteLine("Introduce intre ce raza doriti sa stergeti elementele : ");
primPosition = Convert.ToInt32(Console.ReadLine());
finalPositon = Convert.ToInt32(Console.ReadLine());
remove <Lactate>(magazinPrimar.getListLegume(), primPosition, finalPositon);
break;
case 11:
sorts <Lactate>(magazinPrimar.getListLegume());
break;
case 12:
Console.WriteLine("Alege positia initiala");
init = Convert.ToInt32(Console.ReadLine());
Console.WriteLine("Numarul de date care doriti sa adaugati");
nrDate = Convert.ToInt32(Console.ReadLine());
for (int j = 0; j < nrDate; j++)
{
magazinPrimar.addProdus((new Lactate()), init);
}
break;
}
break;
case 9:
Console.WriteLine(magazinPrimar.ToString());
break;
case 10:
// listCereale.Add(new Cereale());
new InsertDB().cereale();
break;
case 11:
listLactate.Add(new Lactate());
break;
case 12:
showListCereale();
break;
case 13:
showListCereale();
break;
case 14:
Console.WriteLine("Alege positia care doriti sa faceti modificare");
id = Convert.ToInt32(Console.ReadLine());
Console.WriteLine("Introduce numele nou a magazinului");
string nameMagazin = Console.ReadLine();
new UpdateDB().magazin(id, nameMagazin);
break;
case 15:
new UpdateDB().cereale(1, "griu", 10, "10%");
break;
case 16:
Console.WriteLine(magazinPrimar.id);
break;
default:
Console.WriteLine("Introduce cifra corecta");
break;
}
}
}
