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);
}
}
