public static void Verificari_update(Model_clienti m)
{
string fail = null;
if (Verificare_nume(m.Nume))
{
fail = "Nume necompletat";
}
if (Verificare_prenume(m.Prenume))
{
fail = "Prenume necompletat";
}
/*
* if (Verificare_tip_camera_modificat(m))
* {
* if (Verificare_camera(m.tip_camera, m.check_in, m.check_out))
* {
* fail = "nu mai sunt camere de acest tip sau data nu este disponibila";
* }
* }*/
if (Verificare_carte_credit(m.carte_de_credit, m.numar_carte, m.Data_expirarii, m.CCV))
{
fail = "Numarul este gresit scris(fara spatii sau linii)";
}
m.fail = fail;
}
public static void Verificari_update(Model_clienti m)
{
string fail = null;
if (Verificare_nume(m.Nume))
{
fail = "Nume necompletat";
}
if (Verificare_prenume(m.Prenume))
{
fail = "Prenume necompletat";
}
if (Verificare_tip_camera_modificat(m))
{
if (Verificare_date_valabile(m.check_in, m.check_out, m.tip_camera))
{
fail = "nu mai sunt camere de acest tip sau data nu este disponibila";
}
}
if (Verificare_carte_credit(m.carte_de_credit, m.numar_carte, m.Data_expirarii, m.CCV))
{
fail = "fail card";
}
m.fail = fail;
}
public static void Verificari(Model_clienti m)
{
string fail = null;
fail = Verificare_nume(m.Nume);
fail = Verificare_prenume(m.Prenume);
fail = Verificare_camera(m.tip_camera, m.check_in, m.check_out);
fail = Verificare_carte_credit(m.carte_de_credit, m.numar_carte, m.Data_expirarii, m.CCV);
m.fail = fail;
}
public static bool Verificare_tip_camera_modificat(Model_clienti m)
{
MySqlConnection conn = new MySqlConnection(ConnectionString);
string query = "SELECT Tip_camera FROM tabel_clienti WHERE ID='" + m.ID + "';";
MySqlCommand cmd = new MySqlCommand(query, conn);
MySqlDataAdapter adapt = new MySqlDataAdapter();
adapt.SelectCommand = cmd;
DataTable dTable = new DataTable();
adapt.Fill(dTable);
List <DataRow> client = dTable.AsEnumerable().ToList();
Model_clienti cautat = Repository_clienti.Cautare_client(m.ID);
foreach (DataRow stare_camere in client)
{
if (stare_camere.ItemArray[0].ToString() == cautat.tip_camera.ToString())
{
return(false);
}
}
return(true);
}
public static void Verificari(Model_clienti m)
{
string fail = null;
if (Verificare_nume(m.Nume))
{
fail = "Nume necompletat";
}
if (Verificare_prenume(m.Prenume))
{
fail = "Prenume necompletat";
}
if (Verificare_date_valabile(m.check_in, m.check_out, m.tip_camera, m))
{
fail = "Acest tip de camera nu este disponibila pentru datele introduse";
}
if (Verificare_carte_credit(m.carte_de_credit, m.numar_carte, m.Data_expirarii, m.CCV))
{
fail = "Numarul este gresit scris(fara spatii sau linii)";
}
m.fail = fail;
}
/*public static bool Verificare_camera(Tip_camera t, DateTime check_in, DateTime check_out)
* {
* MySqlConnection conn = new MySqlConnection(ConnectionString);
* string query = "select " + t.ToString() + " from Camere;";
* MySqlCommand cmd = new MySqlCommand(query, conn);
* MySqlDataAdapter adapt = new MySqlDataAdapter();
* adapt.SelectCommand = cmd;
* DataTable dTable = new DataTable();
* adapt.Fill(dTable);
* List<DataRow> list_camere = dTable.AsEnumerable().ToList();
* foreach (DataRow stare_camere in list_camere)
* {
* if (stare_camere.ItemArray[0].ToString() == "liber_curata")
* {
* return Verificare_date_valabile(check_in, check_out, t);
* }
* }
*
* return true;
* }*/
public static bool Verificare_date_valabile(DateTime check_in, DateTime check_out, Tip_camera t, Model_clienti m)
{
int ok1 = 0, an_in_compare, an_out_compare, luna_in_compare, luna_out_compare, zi_in_compare, zi_out_compare;
bool valabil = false;
int ok2 = 0;
string query1;
int zi_in = int.Parse(check_in.ToString().Substring(0, 2)), zi_out = int.Parse(check_out.ToString().Substring(0, 2));
int luna_in = int.Parse(check_in.ToString().Substring(3, 2)), luna_out = int.Parse(check_out.ToString().Substring(3, 2));
int an_in = int.Parse(check_in.ToString().Substring(6, 4)), an_out = int.Parse(check_out.ToString().Substring(6, 4));
if (ok)
{
return(false);
}
if (an_in > an_out || luna_in > luna_out || zi_in > zi_out)
{
return(true);
}
MySqlConnection conn = new MySqlConnection(ConnectionString);
query1 = "select Check_IN,Check_OUT from Tabel_clienti WHERE Tip_camera='" + t.ToString() + "' AND Stare NOT IN('Inactiv') AND ID NOT IN('" + m.ID + "');";
MySqlCommand cmd1 = new MySqlCommand(query1, conn);
MySqlDataAdapter adapt1 = new MySqlDataAdapter();
adapt1.SelectCommand = cmd1;
DataTable dTable1 = new DataTable();
adapt1.Fill(dTable1);
List <DataRow> list_data_check = dTable1.AsEnumerable().ToList();
foreach (DataRow data in list_data_check)
{
an_in_compare = int.Parse(data.ItemArray[0].ToString().Substring(6, 4)); //an in
an_out_compare = int.Parse(data.ItemArray[1].ToString().Substring(6, 4)); //an out
luna_in_compare = int.Parse(data.ItemArray[0].ToString().Substring(3, 2)); //luna in
luna_out_compare = int.Parse(data.ItemArray[1].ToString().Substring(3, 2)); //luna out
zi_in_compare = int.Parse(data.ItemArray[0].ToString().Substring(0, 2)); //zi in
zi_out_compare = int.Parse(data.ItemArray[1].ToString().Substring(0, 2)); //zi out
if ((an_in_compare < an_in && an_in < an_out_compare) || (an_in_compare < an_out && an_out < an_out_compare) || (an_in < an_in_compare && an_out_compare < an_out))
{
valabil = true;
}
else
{
if ((luna_in_compare < luna_in && luna_in < luna_out_compare) || (luna_in_compare < luna_out && luna_out < luna_out_compare) || (luna_in < luna_in_compare && luna_out_compare < luna_out))
{
valabil = true;
}
else
{
if ((zi_in_compare <= zi_in && zi_in <= zi_out_compare - 1) || (zi_in_compare <= zi_out && zi_out <= zi_out_compare - 1) || (zi_in <= zi_in_compare && zi_out_compare - 1 <= zi_out))
{
valabil = true;
}
else
{
ok1++;
}
if (valabil == true)
{
ok2++;
valabil = false;
}
}
}
}
Repository_camere.Actualizare_lista_camere();
if (ok2 >= Repository_camere.lista_camere.Count)
{
valabil = true;
}
return(valabil);
}
