public ActionResult List(int ID)
{
ItemList newIL = new ItemList { };
newIL = ItemList.getListByID(ID);
foreach (var gr in newIL.ListGroups)
{
gr.GroupsItems = ItemGroup.GetGroupsItems(gr.gid);
}
ViewBag.Measurments = Measurment.GetAllMeasurments();
var lists = new List<ItemList> { };
Person person = Person.GetPersonFromSession();
lists = ItemList.getAllListsForPerson(person.oid);
ViewBag.UsersList = Person.GetViewersForList(person.oid, person.fid, ID);
ViewBag.ListsList = lists;
List<string> items = Item.GetAllItems();
ViewBag.Typeahead = items;
return View(newIL);
}
public static ItemList InsertNewEmptyList(string listname, int listoid)
{
ItemList newlist = new ItemList { Name = listname };
string cmd = "Insert into Lists (ListName, oid) values ('" + listname + "', '" + listoid.ToString() + "')";
SQLCmd = new SqlCommand(cmd, SQLCon);
SQLCmd.ExecuteNonQuery();
SQLCmd = new SqlCommand("Select top 1 lid, oid from Lists order by lid desc", SQLCon);
SQLDR = SQLCmd.ExecuteReader(CommandBehavior.Default);
while (SQLDR.Read())
{
int tmp = 1;
int.TryParse(SQLDR["lid"].ToString(), out tmp);
newlist.lid = tmp;
}
SQLDR.Close();
SQLCmd = new SqlCommand("Insert into Views (lid, oid) values ('" + newlist.lid.ToString() + "', '" + listoid.ToString() + "')", SQLCon);
SQLCmd.ExecuteNonQuery();
SQLCmd = new SqlCommand("Insert into ItemGroups (lid) values ('" + newlist.lid.ToString() + "')", SQLCon);
SQLCmd.ExecuteNonQuery();
return newlist;
}
public static ItemList getListByID(int ID)
{
SQLCmd = new SqlCommand("Select ListName, ListComment, oid from Lists where lid = " + ID.ToString(), SQLCon);
SQLDR = SQLCmd.ExecuteReader(CommandBehavior.Default);
ItemList lst = new ItemList { lid = ID };
while (SQLDR.Read())
{
int tmpoid = 0;
int.TryParse(SQLDR["oid"].ToString(), out tmpoid);
lst.Name = SQLDR["ListName"].ToString();
lst.oid = tmpoid;
lst.Comment = SQLDR["ListComment"].ToString();
}
SQLDR.Close();
SQLCmd = new SqlCommand("Select gid, Name from ItemGroups where ( lid = " + ID.ToString() + ")", SQLCon);
SQLDR = SQLCmd.ExecuteReader(CommandBehavior.Default);
lst.ListGroups = new List<ItemGroup> { };
while (SQLDR.Read())
{
int tmpgid = 0;
int.TryParse(SQLDR["gid"].ToString(), out tmpgid);
lst.ListGroups.Add(new ItemGroup { lid = ID, gid = tmpgid, Name = SQLDR["Name"].ToString() });
}
SQLDR.Close();
return lst;
}