public ActionResult Create(DataObject dataobject)
{
if (ModelState.IsValid)
{
dataObjects.Add(dataobject);
return RedirectToAction("Index");
}
return View(dataobject);
}
public ActionResult Create(DataObject dataobject)
{
if (ModelState.IsValid)
{
Transformator.ExecuteQuery();
return RedirectToAction("Index");
}
return View(dataobject);
}
//
// GET: /Object/Details/5
public ViewResult Details(int id)
{
DataObject returnObject = new DataObject();
foreach (DataObject dataObject in dataObjects)
{
if (dataObject.ID == id)
{
returnObject = dataObject;
}
}
return View(returnObject);
}
public static List<DataObject> ExecuteQuery()
{
ObjectsEntities context = new ObjectsEntities();
var query = from Objects in context.Objects
orderby Objects.ID
select Objects;
List<DataObject> toReturn = new List<DataObject>();
foreach (Objects obj in query)
{
DataObject dataObject = new DataObject();
dataObject.ID = obj.ID;
dataObject.Name = obj.Name;
}
return toReturn;
}
public static List<DataObject> ExecuteQuery()
{
List<DataObject> toReturn = new List<DataObject>();
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
SqlCommand command = new SqlCommand(query, connection);
SqlDataReader sqlReader = command.ExecuteReader();
while (sqlReader.Read())
{
DataObject obj = new DataObject();
obj.Name = sqlReader.GetString(1);
toReturn.Add(obj);
}
}
return toReturn;
}
//
// GET: /Object/Edit/5
public ActionResult Edit(int id)
{
DataObject returnObject = new DataObject();
foreach (DataObject dataObject in dataObjects)
{
if (dataObject.ID == id)
{
returnObject = dataObject;
}
}
return View(returnObject);
}
public ActionResult Edit(DataObject dataobject)
{
if (ModelState.IsValid)
{
foreach (DataObject dataObject in dataObjects)
{
if (dataobject.ID == dataObject.ID)
{
dataObjects.Remove(dataObject);
dataObjects.Add(dataobject);
return RedirectToAction("Index");
}
}
}
return View(dataobject);
}
