public EditLivingSpaceView GetRoomById(int id)
{
EditLivingSpaceView LivingSpaces = new EditLivingSpaceView();
string connStr = ConfigurationManager.ConnectionStrings["MysqlConnection"].ConnectionString;
MySqlConnection mySqlConnection = new MySqlConnection(connStr);
string sqlQuery = @"SELECT * FROM livingspace WHERE id_LivingSpace = '" + id + "'";
MySqlCommand mySqlCommand = new MySqlCommand(sqlQuery, mySqlConnection);
mySqlConnection.Open();
MySqlDataAdapter mda = new MySqlDataAdapter(mySqlCommand);
DataTable dt = new DataTable();
mda.Fill(dt);
mySqlConnection.Close();
foreach (DataRow dr in dt.Rows)
{
LivingSpaces.adress = Convert.ToString(dr["adress"]);
LivingSpaces.roomNumber = Convert.ToInt32(dr["roomNumber"]);
LivingSpaces.maxCapacity = Convert.ToInt32(dr["maxCapacity"]);
LivingSpaces.id_LivingSpace = Convert.ToInt32(dr["id_LivingSpace"]);
}
return(LivingSpaces);
}
public ActionResult EditLivingSpace(int id, EditLivingSpaceView collection)
{
TempData["err"] = "";
try
{
// Atnaujina kliento informacija
if (ModelState.IsValid)
{
LivingSpaceRepos.EditExistingRoom(collection);
}
return(RedirectToAction("RoomList", new { id = collection.adress }));
}
catch
{
return(View(collection));
}
}
public bool EditExistingRoom(EditLivingSpaceView Room)
{
try
{
string conn = ConfigurationManager.ConnectionStrings["MysqlConnection"].ConnectionString;
MySqlConnection mySqlConnection = new MySqlConnection(conn);
string sqlquery = @"UPDATE livingspace a SET a.maxCapacity=?maxCapacity WHERE a.id_LivingSpace=?id";
MySqlCommand mySqlCommand = new MySqlCommand(sqlquery, mySqlConnection);
mySqlCommand.Parameters.Add("?maxCapacity", MySqlDbType.VarChar).Value = Room.maxCapacity;
mySqlCommand.Parameters.Add("?id", MySqlDbType.VarChar).Value = Room.id_LivingSpace;
mySqlConnection.Open();
mySqlCommand.ExecuteNonQuery();
mySqlConnection.Close();
return(true);
}
catch (Exception)
{
return(false);
}
}
public ActionResult EditLivingSpace(int id)
{
EditLivingSpaceView livingspace = LivingSpaceRepos.GetRoomById(id);
return(View(livingspace));
}