public static ShipDesignDetails AddShipDesignPods(List <AddShipPods> Pods) { SqlConnection sqlConn = DatabaseHelper.GetConnection(); sqlConn.Open(); foreach (AddShipPods Pod in Pods) { SqlDataReader sqlReader = default(SqlDataReader); SqlCommand DBCmd = new SqlCommand("dbo.AddShipDesignPods", sqlConn); DBCmd.CommandType = CommandType.StoredProcedure; DBCmd.Parameters.AddWithValue("@ShipDesignID", Pod.ShipDesignID); DBCmd.Parameters.AddWithValue("@PodID", Pod.PodID); DBCmd.Parameters.AddWithValue("@NumofPods", Pod.NumofPods); sqlReader = DBCmd.ExecuteReader(); sqlReader.Close(); } sqlConn.Close(); ShipDesignDetails design = new ShipDesignDetails(); if (Pods.Count > 0) { design = GetShipDesignSummary(Pods[0].ShipDesignID); } return(design); }
public static ShipDesignDetails GetShipDesignSummary(int?ShipDesignID) { ShipDesignDetails design = new ShipDesignDetails(); using (SqlConnection sqlConn = DatabaseHelper.GetConnection()) using (SqlCommand DBCmd = new SqlCommand("dbo.GetShipDesignSummary", sqlConn)) { SqlDataReader sqlReader = default(SqlDataReader); DBCmd.CommandType = CommandType.StoredProcedure; DBCmd.Parameters.AddWithValue("@ShipDesignID", ShipDesignID); sqlConn.Open(); sqlReader = DBCmd.ExecuteReader(CommandBehavior.CloseConnection); if (sqlReader.Read()) { design.ShipDesignID = sqlReader.GetInt32Nullable("ShipDesignID"); design.DesignName = sqlReader.GetString("DesignName"); design.HullName = sqlReader.GetString("HullName"); design.Hull = sqlReader.GetDoubleNullable("Hull"); design.ShipYardLevel = sqlReader.GetInt32Nullable("ShipYardLevel"); design.MaterialCost = sqlReader.GetDoubleNullable("MaterialCost"); design.MilitaryCost = sqlReader.GetInt32Nullable("MilitaryCost"); design.Armor = sqlReader.GetDoubleNullable("Armor"); design.Laser = sqlReader.GetDoubleNullable("Laser"); design.Missile = sqlReader.GetDoubleNullable("Missile"); design.Plasma = sqlReader.GetDoubleNullable("Plasma"); design.Shields = sqlReader.GetDoubleNullable("Shields"); design.Bays = sqlReader.GetDoubleNullable("Bays"); } return(design); } }
public static List <UserDesigns> RemoveShipDesigns(int?UserID, int?ShipDesignID) { ShipDesignDetails design = new ShipDesignDetails(); using (SqlConnection sqlConn = DatabaseHelper.GetConnection()) using (SqlCommand DBCmd = new SqlCommand("dbo.RemoveShipDesigns", sqlConn)) { SqlDataReader sqlReader = default(SqlDataReader); DBCmd.CommandType = CommandType.StoredProcedure; DBCmd.Parameters.AddWithValue("@ShipDesignID", ShipDesignID); DBCmd.Parameters.AddWithValue("@UserID", UserID); sqlConn.Open(); sqlReader = DBCmd.ExecuteReader(CommandBehavior.CloseConnection); List <UserDesigns> designs = GetShipDesignbyUser(UserID); return(designs); } }
public static List <ShipDesignDetails> GetShipDesignDetails(int?ShipDesignID) { List <ShipDesignDetails> designs = new List <ShipDesignDetails>(); using (SqlConnection sqlConn = DatabaseHelper.GetConnection()) using (SqlCommand DBCmd = new SqlCommand("dbo.GetShipDesignDetails", sqlConn)) { SqlDataReader sqlReader = default(SqlDataReader); DBCmd.CommandType = CommandType.StoredProcedure; DBCmd.Parameters.AddWithValue("@ShipDesignID", ShipDesignID); sqlConn.Open(); sqlReader = DBCmd.ExecuteReader(CommandBehavior.CloseConnection); while (sqlReader.Read()) { ShipDesignDetails design = new ShipDesignDetails(); design.ShipDesignID = sqlReader.GetInt32Nullable("ShipDesignID"); design.DesignName = sqlReader.GetString("DesignName"); design.HullName = sqlReader.GetString("HullName"); design.Hull = sqlReader.GetDoubleNullable("Hull"); design.NumofPods = sqlReader.GetInt32Nullable("NumofPods"); design.ShipPodID = sqlReader.GetInt32Nullable("ShipPodID"); design.PodName = sqlReader.GetString("PodName"); design.Armor = sqlReader.GetDoubleNullable("Armor"); design.Energy = sqlReader.GetDoubleNullable("Energy"); design.EnergyCost = sqlReader.GetDoubleNullable("EnergyCost"); design.MilitaryCost = sqlReader.GetInt32Nullable("MilitaryCost"); design.Missile = sqlReader.GetDoubleNullable("Missile"); design.Movement = sqlReader.GetDoubleNullable("Movement"); design.Laser = sqlReader.GetDoubleNullable("Laser"); design.MaterialCost = sqlReader.GetDoubleNullable("MaterialCost"); design.Plasma = sqlReader.GetDoubleNullable("Plasma"); design.Shields = sqlReader.GetDoubleNullable("Shields"); design.Bays = sqlReader.GetDoubleNullable("Bays"); designs.Add(design); } return(designs); } }