public List <Hult> GetAllHult()
{
Connect();
log4net.Config.DOMConfigurator.Configure();
log.Info("Вызывается метод который возвращает список всех остановок.");
List <Hult> hultlList = new List <Hult>();
SqlCommand commandRead = new SqlCommand("SELECT*FROM Hult;", Connection);
SqlDataReader reader = commandRead.ExecuteReader();
try
{
if (reader.HasRows)
{
while (reader.Read())
{
Hult hult = new Hult();
hult.Id = Convert.ToInt32(reader["id"]);
hult.HultName = Convert.ToString(reader["hultName"]);
hultlList.Add(hult);
}
}
}
catch (SqlException e)
{
log.Error("ERROR" + e.Message);
}
finally
{
reader.Close();
Disconnect();
}
return(hultlList);
}
public bool AddHult(Hult hult)
{
bool result = true;
Connect();
log4net.Config.DOMConfigurator.Configure();
log.Info("Вызывается метод который добавляет новую остановку");
try
{
string sql = "INSERT INTO Hult (hultName) VALUES (@hultName)";
SqlCommand cmd_SQL = new SqlCommand(sql, Connection);
cmd_SQL.Parameters.AddWithValue("@hultName", hult.HultName);
cmd_SQL.ExecuteNonQuery();
}
catch (SqlException e)
{
log.Error("ERROR" + e.Message);
result = false;
}
finally
{
Disconnect();
}
return(result);
}
public ActionResult AddHult(int id, Route route)
{
try
{
IEnumerable <Hult> hults = routeDAO.GetHultWhithout(id);
ViewBag.AllHult = new SelectList(hults, "id", "hultName");
List <Hult> hultList = routeDAO.GetHultById(id);
int count = hultList.Count();
if (count > 0)
{
Hult hult = hultList[hultList.Count - 1];
hultList.RemoveAt(count - 1);
ViewBag.IDList = hultList;
ViewBag.LustHult = hult.HultName;
}
if (routeDAO.AddHult(id, route.HultId))
{
return(RedirectToAction("Index"));
}
else
{
return(View("AddHult"));
}
}
catch
{
return(View("AddHult"));
}
}
public List <Hult> GetHultWhithout(int id)
{
List <Hult> hultList = new RouteDAO().GetHultById(id);
Connect();
log4net.Config.DOMConfigurator.Configure();
log.Info("Вызывается метод который возвращает список всех остановок на маршруте.");
List <Hult> hultlList = new List <Hult>();
string query = "SELECT*FROM Hult;";
SqlCommand commandRead = new SqlCommand(query, Connection);
SqlDataReader reader = commandRead.ExecuteReader();
try
{
if (reader.HasRows)
{
while (reader.Read())
{
Hult hult = new Hult();
hult.HultName = Convert.ToString(reader["hultName"]);
hult.Id = Convert.ToInt32(reader["Id"]);
bool flag = true;
foreach (Hult h in hultList)
{
if (hult.Id == h.Id)
{
flag = false;
}
}
if (flag)
{
hultlList.Add(hult);
}
}
}
}
catch (SqlException e)
{
log.Error("ERROR: " + e.Message);
}
finally
{
reader.Close();
Disconnect();
}
return(hultlList);
}
public ActionResult DetailsVisitor(int id)
{
List <Hult> hultList = routeDAO.GetHultById(id);
int count = hultList.Count();
if (count > 0)
{
Hult hult = hultList[hultList.Count - 1];
hultList.RemoveAt(count - 1);
ViewBag.IDList = hultList;
ViewBag.LustHult = hult.HultName;
}
return(View(routeDAO.GetById(id)));
}
public ActionResult Edit(int id, Hult hult)
{
try
{
if (hultDAO.UpdateHult(id, hult))
{
return(RedirectToAction("Index"));
}
else
{
return(View("Edit"));
}
}
catch
{
return(View("Edit"));
}
}
public ActionResult Create([Bind(Exclude = "d")] Hult hult)
{
try
{
if (hultDAO.AddHult(hult))
{
return(RedirectToAction("Index"));
}
else
{
return(View("Create"));
}
}
catch
{
return(View("Create"));
}
}
public List <Hult> GetHultById(int id)
{
Connect();
log4net.Config.DOMConfigurator.Configure();
log.Info("Вызывается метод который возвращает список всех остановок на маршруте.");
List <Hult> hultlList = new List <Hult>();
string query = "SELECT*FROM RoteHult INNER JOIN Hult " +
"ON Hult.id=RoteHult.Id_Hult where Id_Route=@id ORDER BY RoteHult.routeNumber ASC;";
SqlCommand commandRead = new SqlCommand(query, Connection);
commandRead.Parameters.AddWithValue("@id", id);
SqlDataReader reader = commandRead.ExecuteReader();
try
{
if (reader.HasRows)
{
while (reader.Read())
{
Hult hult = new Hult();
hult.HultName = Convert.ToString(reader["hultName"]);
hult.Id = Convert.ToInt32(reader["Id_Hult"]);
hultlList.Add(hult);
}
}
}
catch (SqlException e)
{
log.Error("ERROR: " + e.Message);
}
finally
{
reader.Close();
Disconnect();
}
return(hultlList);
}
public Hult GetById(int id)
{
Connect(); Hult hult = new Hult();
string query = "SELECT*FROM Hult where id=@id";
SqlCommand commandRead = new SqlCommand(query, Connection);
commandRead.Parameters.AddWithValue("@id", id);
SqlDataReader reader = commandRead.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
hult.Id = Convert.ToInt32(reader["id"]);
hult.HultName = Convert.ToString(reader["hultName"]);
}
}
reader.Close();
Disconnect();
return(hult);
}
// GET: Route/AddHult/5
public ActionResult AddHult(int id)
{
IEnumerable <Hult> hults = routeDAO.GetHultWhithout(id);
ViewBag.AllHult = new SelectList(hults, "id", "hultName");
if (hults.Count() == 0)
{
return(View("ErrorAdd"));
}
List <Hult> hultList = routeDAO.GetHultById(id);
int count = hultList.Count();
if (count > 0)
{
Hult hult = hultList[hultList.Count - 1];
hultList.RemoveAt(count - 1);
ViewBag.IDList = hultList;
ViewBag.LustHult = hult.HultName;
}
return(View(routeDAO.GetById(id)));
}
public bool UpdateHult(int id, Hult hult)
{
bool result = true;
Connect();
try
{
string sql = "UPDATE Hult SET hultName=@hultName WHERE id=@id";
SqlCommand cmd_SQL = new SqlCommand(sql, Connection);
cmd_SQL.Parameters.AddWithValue("@id", id);
cmd_SQL.Parameters.AddWithValue("@hultName", hult.HultName);
cmd_SQL.ExecuteNonQuery();
}
catch (Exception)
{
result = false;
}
finally
{
Disconnect();
}
return(result);
}
