public static string Update(Model_clienti m, string id, Tip_camera tip_vechi)
{
Verif_up(m);
if (m.fail == null)
{
//cautare client
using (MySqlConnection conn = GetConnection())
{
conn.Open();
string query;
m.id_camera = id;
query = "UPDATE tabel_clienti SET Nume='" + m.Nume + "',Prenume='" + m.Prenume + "',Tip_camera='" + m.tip_camera.ToString() + "'" +
",Check_IN='" + m.check_in.ToString() + "',Check_OUT='" + m.check_out.ToString() + "',Carte_Credit='" + m.carte_de_credit.ToString() + "'" +
",Numar_Carte='" + m.numar_carte + "',Data_expirare='" + m.Data_expirarii + "',CCV='" + m.CCV + "',Mentiuni='" + m.Mentiuni + "' WHERE ID='" + m.ID + "';";
MySqlCommand cmd = new MySqlCommand(query, conn);
MySqlDataReader myreader;
myreader = cmd.ExecuteReader();//EXECUTE QUERY
Deactualizare_baza(m, tip_vechi);
Actualizare_lista();
Verificare.ok = false;
}
Repository_camere.Update_camera(m);
}
return(null);
}
private static bool First(Model_clienti m)
{
Actualizare_lista();
if (lista_clienti.Count > 0)
{
return(false);
}
if (Verificare.ok)
{
numar_confirmare++;
using (MySqlConnection conn = GetConnection())
{
conn.Open();
string query, query1;
m.ID = numar_confirmare.ToString();
query = "INSERT into Tabel_clienti VALUES('" + numar_confirmare.ToString() + "','" + m.Nume + "','" + m.Prenume + "','"
+ m.tip_camera.ToString() + "','" + m.check_in.ToString() + "','" + m.check_out.ToString() + "','" + m.carte_de_credit.ToString()
+ "','" + m.numar_carte + "','" + m.Data_expirarii + "','" + m.CCV + "','" + m.Mentiuni + "','Activ');";
MySqlCommand cmd = new MySqlCommand(query, conn);
MySqlDataReader myreader;
myreader = cmd.ExecuteReader();//EXECUTE QUERY
Repository_camere.Update_camera(m);
Actualizare_lista();
Verificare.ok = false;
return(true);
}
}
return(false);
}
public static bool Insert(Model_clienti m)
{
if (First(m))
{
return(true);
}
else
{
numar_confirmare = maxim() + 1;
Verif(m);
if (m.fail == null)
{
using (MySqlConnection conn = GetConnection())
{
conn.Open();
string query;
m.ID = numar_confirmare.ToString();
query = "INSERT into Tabel_clienti VALUES('" + numar_confirmare.ToString() + "','" + m.Nume + "','" + m.Prenume + "','"
+ m.tip_camera.ToString() + "','" + m.check_in.ToString() + "','" + m.check_out.ToString() + "','" + m.carte_de_credit.ToString()
+ "','" + m.numar_carte + "','" + m.Data_expirarii + "','" + m.CCV + "','" + m.Mentiuni + "','Activ');";
MySqlCommand cmd = new MySqlCommand(query, conn);
MySqlDataReader myreader;
myreader = cmd.ExecuteReader();//EXECUTE QUERY
}
Repository_camere.Update_camera(m);
Actualizare_lista();
Verificare.ok = false;
return(true);
}
}
return(false);
}
public static void Actualizare_stare_clienti_o_data_pe_zi()
{
Actualizare_lista();
foreach (Model_clienti m in lista_clienti)
{
if (m.check_out == DateTime.Now)
{
using (MySqlConnection conn = GetConnection())
{
conn.Open();
string query;
query = "UPDATE tabel_clienti SET Stare='Inactiv' WHERE ID='" + m.ID + "';";
MySqlCommand cmd = new MySqlCommand(query, conn);
MySqlDataReader myreader;
myreader = cmd.ExecuteReader();//EXECUTE QUERY
Repository_camere.Eliberare_o_camera(m.tip_camera);
}
}
}
}