/// <summary> /// The get containers. /// </summary> /// <param name="ship"> /// The ship. /// </param> /// <param name="port"> /// The port. /// </param> /// <returns> /// The <see cref="List"/>. /// </returns> public List<Container> GetContainers(string ship, string port) { var containerlist = new List<Container>(); using (var db = new Database()) { Container containers = null; db.OpenConnection(); db.CreateCommand( "Select Container.*,Company.Name AS name,Ship.type AS shiptype from Container,Ship,Port,Company WHERE Ship.Type LIKE @ship AND Port.Name LIKE @port AND Company.ID = Container.Company_ID AND Ship.ID = Container.Ship_ID"); db.AddParameter("@ship", ship); db.AddParameter("@port", port); MySqlDataReader dr = db.Command.ExecuteReader(); while (dr.Read()) { containers = new Container(); containers.id = (int)dr["id"]; containers.type = (string)dr["type"]; containers.weight = (int)dr["weight"]; containers.onship = (string)dr["shiptype"]; containers.companyname = (string)dr["name"]; containerlist.Add(containers); } } return containerlist; }
public List<Item> ItemsGridview(string name) { var griditems = new List<Item>(); Item item = null; using (var db = new Database()) { db.OpenConnection(); db.CreateCommand( "SELECT Item.*, Quality.Name AS Quality FROM Item, Quality WHERE Item.Quality_ID=Quality.Quality_ID AND Item.Name LIKE @name"); db.AddParameter("@name", "%" + name + "%"); MySqlDataReader dr = db.Command.ExecuteReader(); while (dr.Read()) { item = new Item(); item.Name = (string)dr["name"]; item.Level = (int)dr["level"]; item.ReqLevel = (int)dr["Reqlevel"]; item.Quality = (string)dr["Quality"]; griditems.Add(item); } } return griditems; }
public List<Guide> GuideGridview(string name) { var gridguide = new List<Guide>(); Guide guide = null; using (var db = new Database()) { db.OpenConnection(); db.CreateCommand( "SELECT Guide.Name, Author.Name AS Author FROM Guide, Author WHERE Guide.Author_ID=Author.Author_ID And Guide.Name LIKE @name"); db.AddParameter("@name", "%" + name + "%"); MySqlDataReader dr = db.Command.ExecuteReader(); while (dr.Read()) { guide = new Guide(); guide.Name = (string)dr["name"]; guide.Author = (string)dr["author"]; gridguide.Add(guide); } } return gridguide; }
public List<Classes> ClassesGridview(string name) { var gridclasses = new List<Classes>(); Classes classes = null; using (var db = new Database()) { db.OpenConnection(); db.CreateCommand( "SELECT Class.*, Spec.Name AS Spec FROM Class, Spec WHERE Class.Class_ID=Spec.Class_ID AND Class.Name LIKE @name"); db.AddParameter("@name", "%" + name + "%"); MySqlDataReader dr = db.Command.ExecuteReader(); while (dr.Read()) { classes = new Classes(); classes.Name = (string)dr["name"]; classes.Specs = (string)dr["spec"]; gridclasses.Add(classes); } } return gridclasses; }
public Item GetItemByName(string name) { Item item = null; using (Database db = new Database()) { db.OpenConnection(); //db.CreateCommand("SELECT * FROM Item WHERE Name = @name"); //db.AddParameter("@name", name); db.CreateCommand("SELECT * FROM Item WHERE Name LIKE @name"); db.AddParameter("@name", "%" + name + "%"); // Part of the string MySqlDataReader dr = db.Command.ExecuteReader(); while (dr.Read()) { item = new Item(); item.Name = dr["name"].ToString(); item.Level = dr["level"].ToString(); } } return item; }