public static void Load()
{
using (SqlConnection conn = new SqlConnection(Aplikacija.CONNECTION_STRING))
{
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = @"select * from tip_soba where postoji=1";
SqlDataAdapter sqlDA = new SqlDataAdapter();
sqlDA.SelectCommand = cmd;
DataSet ds = new DataSet();
sqlDA.Fill(ds, "tipoviSobe");
//Console.WriteLine(ds.GetXml());
foreach (DataRow row in ds.Tables["tipoviSobe"].Rows)
{
TipSobe ts = new TipSobe();
ts.Id = (long)row["ID"];
ts.Naziv = (string)row["NAZIV"];
ts.BrojKreveta = (int)row["BR_KREVETA"];
Aplikacija.Instanca.hotel.tipoviSobe.Add(ts);
}
}
}
public async Task <IActionResult> Edit(int id, [Bind("Id,Naziv,Opis")] TipSobe tipSobe)
{
if (id != tipSobe.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(tipSobe);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TipSobeExists(tipSobe.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(tipSobe));
}
public async Task <IActionResult> Create([Bind("Id,Kapacitet,Naziv,Opis")] TipSobe tipSobe)
{
if (ModelState.IsValid)
{
_context.Add(tipSobe);
await _context.SaveChangesAsync();
List <TipSobeNamjestaj> nova = new List <TipSobeNamjestaj>();
foreach (Namjestaj.TipNamjestaja val in Enum.GetValues(typeof(Namjestaj.TipNamjestaja)))
{
nova.Add(new TipSobeNamjestaj()
{
TipNamjestaja = val,
Kolicina = tipSobe.Kapacitet,
TipSobeID = tipSobe.Id
});
}
_context.TipSobeNamjestaj.AddRange(nova);
_context.SaveChanges();
return(RedirectToAction(nameof(Index)));
}
return(View(tipSobe));
}
public void Index_ShouldReturnSameCountOfRooms()
{
var context = new TestHotelContext();
Hotel p = new Hotel();
TipSobe c = new TipSobe();
context.Hoteli.Add(p);
context.TipSoba.Add(c);
var controller = new SobaController(context);
controller.Create(new Soba {
Hotel = p, TipSobe = c
});
controller.Create(new Soba {
Hotel = p, TipSobe = c
});
controller.Create(new Soba {
Hotel = p, TipSobe = c
});
var result = controller.Index() as ViewResult;
var roomData = (IList <Soba>)result.ViewData.Model;
Assert.IsNotNull(roomData, "There's no room data");
Assert.AreEqual(3, roomData.Count, "The count does not match");
}
public ActionResult DeleteConfirmed(int id)
{
TipSobe tipSobe = db.TipSoba.Find(id);
db.TipSoba.Remove(tipSobe);
db.SaveChanges();
return(RedirectToAction("Index"));
}
private void btnObrisi_Click(object sender, RoutedEventArgs e)
{
if (MessageBox.Show("Da li ste sigurni???", "Brisanje tipa sobe", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
TipSobe ts = dgTipoviSobe.SelectedItem as TipSobe;
Aplikacija.Instanca.hotel.tipoviSobe.Remove(ts);
TipSobeDAO.Delete(ts);
dgTipoviSobe.Items.Refresh();
}
}
public ActionResult Edit([Bind(Include = "TipSobeID,OpisSobe,CijenaPoNoci")] TipSobe tipSobe)
{
if (ModelState.IsValid)
{
// db.ChangeState<TipSobe>(tipSobe);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tipSobe));
}
public ActionResult Create([Bind(Include = "TipSobeID,OpisSobe,CijenaPoNoci")] TipSobe tipSobe)
{
if (ModelState.IsValid)
{
db.TipSoba.Add(tipSobe);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tipSobe));
}
// GET: TipSobe/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TipSobe tipSobe = db.TipSoba.Find(id);
if (tipSobe == null)
{
return(HttpNotFound());
}
return(View(tipSobe));
}
public IActionResult SnimiTip(SobeTipSobeDodajVM model)
{
if (!ModelState.IsValid)
{
return(View("DodajTipSobe", model));
}
TipSobe tipSobe = new TipSobe();
tipSobe = model.TipSobe;
_db.TipSobe.Add(tipSobe);
_db.SaveChanges();
return(RedirectToAction(nameof(Dodaj)));
}
public static void DeleteLogicko(TipSobe ts)
{
using (SqlConnection conn = new SqlConnection(Aplikacija.CONNECTION_STRING))
{
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = @"update tip_soba set postoji=0 where id=@id";
cmd.Parameters.Add(new SqlParameter("@id", ts.Id));
cmd.ExecuteNonQuery();
}
}
public static void Create(TipSobe ts)
{
using (SqlConnection conn = new SqlConnection(Aplikacija.CONNECTION_STRING))
{
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = @"insert into tip_soba (br_kreveta,naziv,postoji) values (@brKreveta, @naziv, 1)";
cmd.Parameters.Add(new SqlParameter("@brKreveta", ts.BrojKreveta));
cmd.Parameters.Add(new SqlParameter("@naziv", ts.Naziv));
cmd.Parameters.Add(new SqlParameter("@id", ts.Id));
cmd.ExecuteNonQuery();
}
}
public static void Update(TipSobe ts)
{
using (SqlConnection conn = new SqlConnection(Aplikacija.CONNECTION_STRING))
{
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = @"update tip_soba set br_kreveta=@brKreveta, naziv=@naziv where id=@id";
cmd.Parameters.Add(new SqlParameter("@brKreveta", ts.BrojKreveta));
cmd.Parameters.Add(new SqlParameter("@naziv", ts.Naziv));
cmd.Parameters.Add(new SqlParameter("@id", ts.Id));
cmd.ExecuteNonQuery();
}
}
public IzmeniTipSobeWindow(TipoviSobeWindow tipoviSobeWindow, STANJE st)
: this()
{
this.tipoviSobeWindow = tipoviSobeWindow;
this.trenutnoStanje = st;
if (st == STANJE.IZMENA)
{
this.orgTipSobe = tipoviSobeWindow.dgTipoviSobe.SelectedItem as TipSobe;
this.tipSobe = orgTipSobe.Clone() as TipSobe;
}
else
{
this.tipSobe = new TipSobe();
this.orgTipSobe = tipSobe;
}
this.DataContext = tipSobe;
}
public void Create_ShouldNotCreateRoomWithoutRoomType()
{
var context = new TestHotelContext();
Hotel p = new Hotel();
TipSobe c = new TipSobe();
context.Hoteli.Add(p);
context.TipSoba.Add(c);
var controller = new SobaController(context);
controller.Create(new Soba {
Hotel = p, TipSobe = c, TipSobeID = 5
});
controller.ModelState.AddModelError("TipSobeID", "Room type does not exist");
Assert.IsTrue(controller.ModelState.IsValid == false, "The model state is valid");
}
public void Update_ShouldUpdateRoomType()
{
mockContext = new Mock <IHotelAC>();
mockSet = new Mock <DbSet <TipSobe> >();
mockContext.Setup(m => m.TipSoba).Returns(mockSet.Object);
var controller = new TipSobeController(mockContext.Object);
var newRoomType = new TipSobe
{
CijenaPoNoci = 100,
OpisSobe = "Test",
TipSobeID = 1
};
controller.Create(newRoomType);
newRoomType.CijenaPoNoci = 200;
controller.Edit(newRoomType);
Assert.IsTrue(200 == newRoomType.CijenaPoNoci, "The room type did not update");
}
public void Create_ShouldReturnInvalidModelState()
{
mockContext = new Mock <IHotelAC>();
mockSet = new Mock <DbSet <TipSobe> >();
mockContext.Setup(m => m.TipSoba).Returns(mockSet.Object);
var controller = new TipSobeController(mockContext.Object);
controller.ModelState.AddModelError("CijenaSobe", "Room price needs to have a value");
var newRoomType = new TipSobe
{
CijenaPoNoci = 0,
OpisSobe = "Test",
TipSobeID = 1
};
controller.Create(newRoomType);
Assert.IsTrue(controller.ViewData.ModelState.IsValid == false, "Room price cannot be zero");
}
