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); }
public static bool Update_camera(Tip_camera t) { if (Verificare.Verificare_camera(t) != null) { using (MySqlConnection conn = GetConnection()) { conn.Open(); string query, id; id = Cautare_camera_pe_tip(t); if (id == null) { return(false); } query = "UPDATE camere SET " + t.ToString() + "='rezervat' WHERE ID='" + id + "';"; MySqlCommand cmd = new MySqlCommand(query, conn); MySqlDataReader myreader; myreader = cmd.ExecuteReader();//EXECUTE QUERY return(true); } } else { return(false); } }
public void Testare_cautare_camera_fail(Tip_camera t) { //Arrange string result = null; //Act result = Repository_camere.Cautare_camera_pe_tip(t); //Assert Assert.IsNull(result); }
public void Test_cautare_camera_rezervata_fail() { //Arrange Tip_camera t = Tip_camera.Standard; string result = null; //Act result = Repository_clienti.Cautare_camera_rezervata(t); //Assert Assert.IsNull(result); }
public void Test_cautare_camera_rezervata_good() { //Arrange Tip_camera t = Tip_camera.Lux; string result = null; //Act result = Repository_clienti.Cautare_camera_rezervata(t); //Assert Assert.IsNotNull(result); }
public static void Deactualizare_baza(Model_clienti m, Tip_camera tip_vechi) { using (MySqlConnection conn = GetConnection()) { conn.Open(); string query = "UPDATE camere SET " + tip_vechi.ToString() + "='liber_curata' WHERE ID='" + m.id_camera + "';"; MySqlCommand cmd = new MySqlCommand(query, conn); MySqlDataReader myreader; myreader = cmd.ExecuteReader();//EXECUTE QUERY } }
public void Test_verificare_date_valabile_good(string check_in, string check_out) { //Arrange DateTime check_ind = DateTime.Parse(check_in); DateTime check_outd = DateTime.Parse(check_out); Tip_camera t1 = Tip_camera.Standard; Tip_camera t2 = Tip_camera.Lux; Tip_camera t3 = Tip_camera.Superior; bool result1, result2, result3; //Act result1 = Verificare.Verificare_date_valabile(check_ind, check_outd, t1); result2 = Verificare.Verificare_date_valabile(check_ind, check_outd, t2); result3 = Verificare.Verificare_date_valabile(check_ind, check_outd, t3); //Assert Assert.IsFalse(result1); Assert.IsFalse(result2); Assert.IsFalse(result3); }
public static string Cautare_camera_pe_tip(Tip_camera t) { MySqlConnection conn = new MySqlConnection(ConnectionString); string query = "select " + t.ToString() + ",ID 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(stare_camere.ItemArray[1].ToString()); } } return(null); }
public static void Eliberare_o_camera(Tip_camera tip_pentru_deactualizare) { Actualizare_lista_camere(); foreach (Camere c in lista_camere) { if (tip_pentru_deactualizare.ToString() == "Lux" && c.lux == Lux.rezervat) { Eliberare_camera(c.id, "Lux"); break; } if (tip_pentru_deactualizare.ToString() == "Superior" && c.sup == Superior.rezervat) { Eliberare_camera(c.id, "Superior"); break; } if (tip_pentru_deactualizare.ToString() == "Standard" && c.std == Standard.rezervat) { Eliberare_camera(c.id, "Standard"); break; } } }
public void Test_verificare_date_valabile_fail(string check_in, string check_out) { //Arrange DateTime check_ind = DateTime.Parse(check_in); DateTime check_outd = DateTime.Parse(check_out); Tip_camera t2 = Tip_camera.Lux; Tip_camera t3 = Tip_camera.Superior; bool result2, result3; //Act result2 = Verificare.Verificare_date_valabile(check_ind, check_outd, t2); result3 = Verificare.Verificare_date_valabile(check_ind, check_outd, t3); //Assert if (result2 == true || result3 == true) { Assert.Pass(); } else { Assert.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) { int ok1 = 0, a, b, c, d, e, f; bool valabil = false; 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); string query1 = "select Check_IN,Check_OUT from Tabel_clienti WHERE Tip_camera='" + t.ToString() + "';"; 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) { a = int.Parse(data.ItemArray[0].ToString().Substring(6, 4)); //an in b = int.Parse(data.ItemArray[1].ToString().Substring(6, 4)); //an out c = int.Parse(data.ItemArray[0].ToString().Substring(3, 2)); //luna in d = int.Parse(data.ItemArray[1].ToString().Substring(3, 2)); //luna out e = int.Parse(data.ItemArray[0].ToString().Substring(0, 2)); //zi in f = int.Parse(data.ItemArray[1].ToString().Substring(0, 2)); //zi out if ((a < an_in && an_in < b) || (a < an_out && an_out < b) || (an_in < a && b < an_out)) { valabil = true; } else { if ((c < luna_in && luna_in < d) || (c < luna_out && luna_out < d) || (luna_in < c && d < luna_out)) { valabil = true; } else { if ((e <= zi_in && zi_in <= f) || (e <= zi_out && zi_out <= f) || (zi_in <= e && f <= zi_out)) { valabil = true; } else { ok1++; } } } } if (ok1 == list_data_check.Count()) { valabil = false; } return(valabil); }
/*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); }