public static void stergere()
{
CONNECT conn = new CONNECT();
conn.openConnection();
SqlCommand command = new SqlCommand("DELETE FROM Meniu", conn.getConnection());
command.ExecuteNonQuery();
conn.closeConnection();
}
public static void intializare()
{
CONNECT conn = new CONNECT();
SqlCommand command = new SqlCommand();
StreamReader sr = new StreamReader(Application.StartupPath + @"\Resurse_C#\meniu.txt");
char[] split = { ';' };
string sir;
conn.openConnection();
sir = sr.ReadLine();
while ((sir = sr.ReadLine()) != null)
{
string[] siruri = sir.Split(split);
string query = "INSERT INTO Meniu(id_produs,denumire_produs,descriere,pret,kcal,felul) VALUES (@id,@nume,@desc,@pret,@kcal,@felul)";
//@id,@nume,@desc,@pret,@kcal,@felul
//command.CommandText = query;
//command.Connection = conn.getConnection();
command = new SqlCommand(query, conn.getConnection());
if (siruri[0].Trim() != "")
{
command.Parameters.Add("id", SqlDbType.Int).Value = Convert.ToInt32(siruri[0].Trim());
command.Parameters.Add("nume", SqlDbType.VarChar).Value = siruri[1].ToString();
command.Parameters.Add("desc", SqlDbType.NText).Value = siruri[2].ToString();
command.Parameters.Add("pret", SqlDbType.Int).Value = Convert.ToInt32(siruri[3].ToString());
command.Parameters.Add("kcal", SqlDbType.Int).Value = Convert.ToInt32(siruri[4].ToString());
command.Parameters.Add("felul", SqlDbType.Int).Value = Convert.ToInt32(siruri[5].ToString());
command.ExecuteNonQuery();
}
}
conn.closeConnection();
}
