public wam.Vertex selectById(int id)
{
var v = db.WAM_VERTEXes.FirstOrDefault(i => i.Id == id);
wam.Vertex vertex = new wam.Vertex((int)v.Id, v.name, v.label, (int)v.x, (int)v.y, (int)v.width, (int)v.height);
return(vertex);
}
public ArrayList selectAll()
{
var vertexRows = db.WAM_VERTEXes.Take(100);
ArrayList vertices = new ArrayList();
foreach (var v in vertexRows)
{
wam.Vertex vertex = new wam.Vertex((int)v.Id, v.name, v.label, (int)v.x, (int)v.y, (int)v.width, (int)v.height);
vertices.Add(vertex);
}
return vertices;
}
public ArrayList selectAll()
{
var vertexRows = db.WAM_VERTEXes.Take(100);
ArrayList vertices = new ArrayList();
foreach (var v in vertexRows)
{
wam.Vertex vertex = new wam.Vertex((int)v.Id, v.name, v.label, (int)v.x, (int)v.y, (int)v.width, (int)v.height);
vertices.Add(vertex);
}
return(vertices);
}
protected void insert_Click(object sender, EventArgs e)
{
string name = nameTxt.Text;
string label = labelTxt.Text;
string x = xTxt.Text;
string y = yTxt.Text;
string width = widthTxt.Text;
string height = heightTxt.Text;
wam.Vertex vertex = new wam.Vertex(0, name, label, Convert.ToInt32(x), Convert.ToInt32(y), Convert.ToInt32(width), Convert.ToInt32(height));
// vertex = dao.insert(vertex);
// resultTxt.Text += vertex.ToString() + "\n";
}
protected void insert_Click(object sender, EventArgs e)
{
string name = nameTxt.Text;
string label = labelTxt.Text;
string x = xTxt.Text;
string y = yTxt.Text;
string width = widthTxt.Text;
string height = heightTxt.Text;
wam.Vertex vertex = new wam.Vertex(0, name, label, Convert.ToInt32(x), Convert.ToInt32(y), Convert.ToInt32(width), Convert.ToInt32(height));
// vertex = dao.insert(vertex);
// resultTxt.Text += vertex.ToString() + "\n";
}
protected void update_Click(object sender, EventArgs e)
{
string id = idTxt.Text;
string newName = nameTxt.Text;
string newLabel = labelTxt.Text;
string newX = xTxt.Text;
string newY = yTxt.Text;
string newW = widthTxt.Text;
string newH = heightTxt.Text;
wam.Vertex changedVertex = new wam.Vertex(Convert.ToInt32(id), newName, newLabel, Convert.ToInt32(newX), Convert.ToInt32(newY), Convert.ToInt32(newW), Convert.ToInt32(newH));
// dao.update(changedVertex);
//// resultTxt.Text = dao.update(vertex);
// resultTxt.Text = dao.update(id, newName, newLabel, newX, newY, newH, newW);
}
protected void update_Click(object sender, EventArgs e)
{
string id = idTxt.Text;
string newName = nameTxt.Text;
string newLabel = labelTxt.Text;
string newX = xTxt.Text;
string newY = yTxt.Text;
string newW = widthTxt.Text;
string newH = heightTxt.Text;
wam.Vertex changedVertex = new wam.Vertex(Convert.ToInt32(id), newName, newLabel, Convert.ToInt32(newX), Convert.ToInt32(newY), Convert.ToInt32(newW), Convert.ToInt32(newH));
// dao.update(changedVertex);
//// resultTxt.Text = dao.update(vertex);
// resultTxt.Text = dao.update(id, newName, newLabel, newX, newY, newH, newW);
}
public Vertex insert(Vertex vertex)
{
WAM_VERTEX v = new WAM_VERTEX
{
name = vertex.name,
label = vertex.label,
x = vertex.x,
y = vertex.y,
width = vertex.width,
height = vertex.height
};
db.WAM_VERTEXes.InsertOnSubmit(v);
db.SubmitChanges();
vertex.id = v.Id;
return vertex;
}
public void update(Vertex vertex)
{
WAM_VERTEX v = db.WAM_VERTEXes.FirstOrDefault(i => i.Id == vertex.id);
v.name = vertex.name;
v.label = vertex.label;
v.width = vertex.width;
v.height = vertex.height;
v.x = vertex.x;
v.y = vertex.y;
db.SubmitChanges();
}
public wam.Vertex selectById(int id)
{
var v = db.WAM_VERTEXes.FirstOrDefault(i => i.Id == id);
wam.Vertex vertex = new wam.Vertex((int)v.Id, v.name, v.label, (int)v.x, (int)v.y, (int)v.width, (int)v.height);
return vertex;
}
