public static bool Update_camera(Model_clienti m)
{
if (!Verificare.Verificare_camera(m.tip_camera))
{
using (MySqlConnection conn = GetConnection())
{
conn.Open();
string query, id;
id = Cautare_camera_pe_tip(m.tip_camera);
if (id == null)
{
return(false);
}
query = "UPDATE camere SET " + m.tip_camera.ToString() + "='rezervat' WHERE ID='" + id + "';";
MySqlCommand cmd = new MySqlCommand(query, conn);
MySqlDataReader myreader;
myreader = cmd.ExecuteReader();//EXECUTE QUERY
m.id_camera = id;
return(true);
}
}
else
{
return(false);
}
}
public void Send(Model_clienti c)
{
var bus = Bus.Factory.CreateUsingRabbitMq(sbc =>
{
var host = sbc.Host(new Uri("amqp://*****:*****@hawk.rmq.cloudamqp.com/xjkfljkg"), h =>
{
h.Username("xjkfljkg");
h.Password("6f3VVB4u_9BuC-iPf0-FKzRnwET1GHNs");
});
});
bus.Start();
this.bus = bus;
bus.Publish(new Model_clienti()
{
ID = c.ID,
Nume = c.Nume,
Prenume = c.Prenume,
tip_camera = c.tip_camera,
check_in = c.check_in,
check_out = c.check_out,
carte_de_credit = c.carte_de_credit,
numar_carte = c.numar_carte,
Data_expirarii = c.Data_expirarii,
CCV = c.CCV,
Mentiuni = c.Mentiuni,
id_camera = c.id_camera,
stare = c.stare,
fail = c.fail,
email = c.email
});
}
//GET
public ActionResult Rezervare()
{
Model_clienti m = new Model_clienti();
m.fail = null;
return(View(m));
}
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 void Actualizare_lista()
{
lista_clienti.Clear();
MySqlConnection conn = new MySqlConnection(ConnectionString);
string query = "SELECT * FROM tabel_clienti;";
MySqlCommand cmd = new MySqlCommand(query, conn);
MySqlDataAdapter adapt = new MySqlDataAdapter();
adapt.SelectCommand = cmd;
DataTable dTable = new DataTable();
adapt.Fill(dTable);
List <DataRow> lista_clienti_db = dTable.AsEnumerable().ToList();
foreach (DataRow client in lista_clienti_db)
{
Model_clienti m = new Model_clienti();
m.ID = client.ItemArray[0].ToString();
m.Nume = client.ItemArray[1].ToString();
m.Prenume = client.ItemArray[2].ToString();
m.tip_camera = (Tip_camera)Enum.Parse(typeof(Tip_camera), client.ItemArray[3].ToString());
m.check_in = DateTime.Parse(client.ItemArray[4].ToString());
m.check_out = DateTime.Parse(client.ItemArray[5].ToString());
m.carte_de_credit = (Carte_de_credit)Enum.Parse(typeof(Carte_de_credit), client.ItemArray[6].ToString());
m.numar_carte = client.ItemArray[7].ToString();
m.Data_expirarii = client.ItemArray[8].ToString();
m.CCV = client.ItemArray[9].ToString();
m.Mentiuni = client.ItemArray[10].ToString();
m.stare = (Stare)Enum.Parse(typeof(Stare), client.ItemArray[11].ToString());
lista_clienti.Add(m);
}
}
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 ActionResult Actualizare_client(Model_clienti m_nou)
{
if (ok)
{
//Repository_clienti.Update(m);
}
ok = true;
return(View(m_nou));
}
public void Test_actualizare_client_POST()
{
var controller = new HomeController();
var model_client = new Model_clienti();
//Act
var result = controller.Actualizare_client(model_client, " ");
//Assert
Assert.IsInstanceOf <RedirectToActionResult>(result);
}
public void Testare_cautare_client_fail(string id)
{
//Arrange
Model_clienti m1 = new Model_clienti();
//Act
m1 = Repository_clienti.Cautare_client(id);
//Assert
Assert.IsNull(m1);
}
public void Test_actualizare_client_GET()
{
var controller = new HomeController();
var model_client = new Model_clienti();
//Act
var result = controller.Actualizare_client(model_client);
//Assert
Assert.IsInstanceOf <ViewResult>(result);
}
[HttpPost]//De aici la view-ul administratorului
public ActionResult Rezervare(Model_clienti m)
{
if (Repository_clienti.Insert(m))
{
c1.id_confirmare = m.ID;
c1.m = m;
id = c1.id_confirmare;
return(RedirectToAction("Confirmare"));
}
return(View(m));
}
public void Test_Rezervare_POST_not_insert()
{
//Arrange
var controller = new HomeController();
var model_client = new Model_clienti();
//Act
var result = controller.Rezervare(model_client);
//Assert
Assert.IsInstanceOf <ViewResult>(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_deactualizare_camera_db()
{
//Arrange
Model_clienti m1 = new Model_clienti();
m1.id_camera = "2";
m1.tip_camera = Model_clienti.Tip_camera.Lux;
//Act
Repository_clienti.Deactualizare_baza(m1, m1.tip_camera);
//Assert
Assert.Pass();
}
[HttpPost]//De aici la view-ul administratorului
public ActionResult Rezervare(Model_clienti m)
{
serviciu.Add_client(m);
Receive.Program.Main();
if (Repository_clienti.Insert(m))
{
c1.id_confirmare = m.ID;
c1.m = m;
id = c1.id_confirmare;
return(RedirectToAction("Confirmare"));
}
return(View(m));
}
public void Test_verificare_tip_camera_good()
{
//Arrange
Model_clienti m1 = new Model_clienti();
m1.ID = "1";
bool result = false;
//Act
result = Verificare.Verificare_tip_camera_modificat(m1);
//Assert
Assert.IsFalse(result);
}
public void Test_cautare_client_good(string id)
{
//Arrange
Model_clienti m1 = new Model_clienti();
//Act
m1 = Repository_clienti.Cautare_client(id);
//Assert
Assert.AreEqual(m1.Nume, model_client.Nume);
Assert.AreEqual(m1.Prenume, model_client.Prenume);
Assert.AreEqual(m1.tip_camera, model_client.tip_camera);
Assert.AreEqual(m1.carte_de_credit, model_client.carte_de_credit);
Assert.AreEqual(m1.CCV, model_client.CCV);
Assert.AreEqual(m1.Data_expirarii, model_client.Data_expirarii);
Assert.AreEqual(m1.Mentiuni, model_client.Mentiuni);
}
private static ClassLibrary1.Model_clienti Convert(Model_clienti m)
{
ClassLibrary1.Model_clienti m1 = new ClassLibrary1.Model_clienti();
m1.Nume = m.Nume;
m1.Prenume = m.Prenume;
m1.check_in = m.check_in;
m1.check_out = m.check_out;
m1.carte_de_credit = (ClassLibrary1.Model_clienti.Carte_de_credit)m.carte_de_credit;
m1.Data_expirarii = m.Data_expirarii;
m1.CCV = m.CCV;
m1.tip_camera = (ClassLibrary1.Model_clienti.Tip_camera)m.tip_camera;
m1.Mentiuni = m.Mentiuni;
m1.ID = m.ID;
m1.id_camera = m.id_camera;
m1.stare = (ClassLibrary1.Model_clienti.Stare)m.stare;
m1.fail = m.fail;
m1.email = m.email;
return(m1);
}
public void Add_client(Model_clienti m)
{
bus.Publish(new Model_clienti()
{
carte_de_credit = m.carte_de_credit,
CCV = m.CCV,
check_in = m.check_in,
check_out = m.check_out,
Data_expirarii = m.Data_expirarii,
email = m.email,
fail = m.fail,
ID = m.ID,
id_camera = m.id_camera,
Mentiuni = m.Mentiuni,
numar_carte = m.numar_carte,
Nume = m.Nume,
Prenume = m.Prenume,
stare = m.stare,
tip_camera = m.tip_camera
});
}
public static void Revenire_camera(string id)
{
using (MySqlConnection conn = GetConnection())
{
string id1 = null;
conn.Open();
string query;
Model_clienti m1 = new Model_clienti();
Actualizare_lista();
foreach (Model_clienti m in lista_clienti)
{
if (m.ID == id)
{
m1 = m;
}
}
id1 = Cautare_camera_rezervata(m1.tip_camera);
query = "UPDATE camere SET " + m1.tip_camera.ToString() + "='liber_curata' WHERE ID='" + id1 + "';";
MySqlCommand cmd = new MySqlCommand(query, conn);
MySqlDataReader myreader;
myreader = cmd.ExecuteReader();//EXECUTE QUERY
}
}
public static void Verif(Model_clienti m)
{
Verificare.Verificari(m);
}
public bool Completare_raport(Model_clienti m, Prognoza_pe_baza_de_statisticics p, Puncte_de_vanzare v)
{
return(true);
}
public ActionResult Actualizare_client(Model_clienti m, string s)
{
Repository_clienti.Update(m, id);
return(View(m));
}
public ActionResult Actualizare_client(Model_clienti m)
{
model = m;
m.fail = null;
return(View(m));
}
private static void Verif(Model_clienti m)
{
Verificare.Verificari(m);
}
public void Report(IAudit a, IIncasari i, Prognoza_pe_baza_de_statisticics p, Puncte_de_vanzare v, Model_clienti m, float pret, string camera)
{
bool ok = a.Completare_raport(m, p, v);
float res = i.Calcul_pret(pret, camera, v);
}
public static void Verif_up(Model_clienti m)
{
Verificare.Verificari_update(m);
}
public ActionResult Actualizare_client(Model_clienti m, string s)
{
Repository_clienti.Update(m, id);
return(RedirectToAction("Modificare"));
}
[HttpPost]//De aici la view-ul administratorului
public ActionResult Rezervare(Model_clienti m)
{
Repository_clienti.Insert(m);
return(View(m));
}
