public void AddCraft(DataAccessCrafts craftToAdd)
{
SqlConnection connection = new SqlConnection(_connectionString);
SqlCommand cmd = new SqlCommand("sp_CreateCraft", connection);
cmd.CommandType = CommandType.StoredProcedure;
try
{
cmd.Parameters.AddWithValue("@CraftName", craftToAdd.CraftName);
cmd.Parameters.AddWithValue("@Description", craftToAdd.Description);
cmd.Parameters.AddWithValue("@User_ID", craftToAdd.User_ID);
connection.Open();
cmd.ExecuteNonQuery();
}
catch (Exception error)
{
using (StreamWriter writer = new StreamWriter(_errorLog))
{
writer.Write("Create Exception: " + error);
}
}
finally
{
connection.Close();
}
}
public static DataAccessCrafts RowToCrafts(DataRow tableRow)
{
DataAccessCrafts dCraft = new DataAccessCrafts();
dCraft.Craft_ID = (int)tableRow["Craft_ID"];
dCraft.CraftName = tableRow["CraftName"].ToString();
dCraft.Description = tableRow["Description"].ToString();
dCraft.User_ID = (int)tableRow["User_ID"];
return(dCraft);
}
public BusinessLogicCrafts MapCraft(DataAccessCrafts dCraft)
{
BusinessLogicCrafts bCraft = new BusinessLogicCrafts();
bCraft.Craft_ID = dCraft.Craft_ID;
bCraft.CraftName = dCraft.CraftName;
bCraft.Description = dCraft.Description;
bCraft.User_ID = dCraft.User_ID;
return(bCraft);
}
public DataAccessCrafts MapCraft(BusinessLogicCrafts bCraft)
{
DataAccessCrafts dCraft = new DataAccessCrafts();
dCraft.Craft_ID = bCraft.Craft_ID;
dCraft.CraftName = bCraft.CraftName;
dCraft.Description = bCraft.Description;
dCraft.User_ID = bCraft.User_ID;
return(dCraft);
}
public DataAccessCrafts GetCraftsByCraftName(string craftName)
{
DataAccessCrafts dCrafts = new DataAccessCrafts();
foreach (DataAccessCrafts craft in GetCrafts())
{
if (craftName == craft.CraftName)
{
dCrafts = craft;
}
}
return(dCrafts);
}
public DataAccessCrafts GetCraftByCraftId(int craftId)
{
DataAccessCrafts craft = new DataAccessCrafts();
foreach (DataAccessCrafts dCraft in GetCrafts())
{
if (craftId == dCraft.Craft_ID)
{
craft = dCraft;
}
}
return(craft);
}
public DataAccessCrafts MapCraft(BusinessLogicCrafts bCraft)
{
if (bCraft == null)
{
return null;
}
DataAccessCrafts dCraft = new DataAccessCrafts
{
Craft_ID = bCraft.Craft_ID,
CraftName = bCraft.CraftName,
Description = bCraft.Description,
User_ID = bCraft.User_ID
};
return dCraft;
}
public List <DataAccessCrafts> TableToListOfCrafts(DataTable craftsTable)
{
List <DataAccessCrafts> dCrafts = new List <DataAccessCrafts>();
if (craftsTable != null && craftsTable.Rows.Count > 0)
{
foreach (DataRow row in craftsTable.Rows)
{
DataAccessCrafts dCraft = new DataAccessCrafts();
dCraft = RowToCrafts(row);
dCrafts.Add(dCraft);
}
}
return(dCrafts);
}
public BusinessLogicCrafts MapCraft(DataAccessCrafts dCraft)
{
if (dCraft == null)
{
return null;
}
BusinessLogicCrafts bCraft = new BusinessLogicCrafts
{
Craft_ID = dCraft.Craft_ID,
CraftName = dCraft.CraftName,
Description = dCraft.Description,
User_ID = dCraft.User_ID,
Username = dCraft.Username
};
return bCraft;
}
