public ActionResult Admin_clienti()
{
try
{
if (t.Id != null)
{
_db.Tabel_clienti.Add(t);
_db.SaveChanges();
}
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Debug.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Debug.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
}
Repository_clienti.Getall();
return(View(Repository_clienti.lista_clienti));
}
public ActionResult COD(COD c)
{
Model_clienti model1;
id = c.id;
model1 = Repository_clienti.Cautare_client(id);
return(RedirectToAction("Actualizare_client", model1));
}
public void Testare_actualizare_lista()
{
//Arrange
//Act
Repository_clienti.Actualizare_lista();
//Assert
Assert.IsNotNull(Repository_clienti.lista_clienti);
}
public void Test_verif_update_rep()
{
//Arrange
//Act
Repository_clienti.Verif_up(model_client);
//Assert
Assert.Pass();
}
public void Test_insert_first_fail()
{
//Arrange
bool result = false;
//Act
result = Repository_clienti.First(model_client);
//Assert
Assert.IsFalse(result);
}
public void Test_insert()
{
//Arrange
bool result = false;
//Act
result = Repository_clienti.Insert(model_client);
//Assert
Assert.IsTrue(result);
}
public void Test_anulare_rezervare()
{
//Arrange
string id = "1";
//Act
Repository_clienti.Anulare_rezervare(id);
//Assert
Assert.Pass();
}
public void Test_maxim()
{
//Arrange
int max = 0;
//Act
max = Repository_clienti.maxim();
//Assert
Assert.AreEqual(2, max);
}
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_Revenire_camera()
{
//Arrange
string id_tabel_client = "2";
//Act
Repository_clienti.Revenire_camera(id_tabel_client);
//Assert
Assert.Pass();
}
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 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);
}
[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_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();
}
public void Test_Update()
{
//Arrange
model_client.ID = "2";
model_client.Nume = "Nume2";
model_client.tip_camera = Model_clienti.Tip_camera.Superior;
//Act
string result = Repository_clienti.Update(model_client, "1", Model_clienti.Tip_camera.Lux);
//Assert
Assert.IsNull(result);
}
[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 ActionResult COD(COD c)
{
c.Verificare();
if (c.fail != null)
{
return(View(c));
}
Model_clienti model1;
id = c.id;
model1 = Repository_clienti.Cautare_client(id);
return(RedirectToAction("Actualizare_client", model1));
}
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);
}
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);
}
//GET
public ActionResult Rapoarte_clienti()
{
Repository_clienti.Actualizare_lista();
return(View(Repository_clienti.Sortare_lista()));
}
[HttpPost]//De aici la view-ul administratorului
public ActionResult Rezervare(Model_clienti m)
{
Repository_clienti.Insert(m);
return(View(m));
}
public ActionResult Actualizare_client(Model_clienti m, string s)
{
Repository_clienti.Update(m, id);
return(View(m));
}
public ActionResult Anulare()
{
Repository_clienti.Anulare_rezervare(id);
return(View());
}
public ActionResult Actualizare_client(Model_clienti m, string s)
{
Repository_clienti.Update(m, id);
return(RedirectToAction("Modificare"));
}