public static List <Sandwich> GetSandwiches()
{
List <Sandwich> sandwiches = new List <Sandwich>();
using (SqlConnection myConnection = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=D:\GitRepos\GitHub\SandwichService\SandwichService\App_Data\SandwichDB.mdf;Integrated Security=True"))
{
string oString = "Select * from Sandwich";
SqlCommand oCmd = new SqlCommand(oString, myConnection);
//oCmd.Parameters.AddWithValue("@Fname", fName);
myConnection.Open();
using (SqlDataReader oReader = oCmd.ExecuteReader())
{
while (oReader.Read())
{
var sandwich = new Sandwich();
for (int iField = 0; iField < oReader.FieldCount; iField++)
{
switch (oReader.GetName(iField))
{
//case nameof(sandwich.Id).ToLowerInvariant():
case nameof(sandwich.Id):
if (int.TryParse(oReader[iField] as string, out int id))
{
sandwich.Id = id;
}
break;
case nameof(sandwich.Name):
sandwich.Name = oReader[iField] as string;
break;
case nameof(sandwich.Description):
sandwich.Description = oReader[iField] as string;
break;
case nameof(sandwich.Price):
if (decimal.TryParse(oReader[iField] as string, out decimal dec))
{
sandwich.Price = dec;
}
break;
}
}
sandwiches.Add(sandwich);
}
myConnection.Close();
}
}
return(sandwiches);
}
public static Sandwich GetSandwich(int id)
{
Sandwich sandwich = new Sandwich();
using (SqlConnection myConnection = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=D:\GitRepos\GitHub\SandwichService\SandwichService\App_Data\SandwichDB.mdf;Integrated Security=True"))
{
string oString = "Select * from Sandwich where id = @id";
SqlCommand oCmd = new SqlCommand(oString, myConnection);
oCmd.Parameters.AddWithValue("@id", id);
myConnection.Open();
using (SqlDataReader oReader = oCmd.ExecuteReader())
{
while (oReader.Read())
{
for (int iField = 0; iField < oReader.FieldCount; iField++)
{
switch (oReader.GetName(iField))
{
case nameof(sandwich.Id):
if (int.TryParse(oReader[iField] as string, out int dbId))
{
sandwich.Id = dbId;
}
break;
case nameof(sandwich.Name):
sandwich.Name = oReader[iField] as string;
break;
case nameof(sandwich.Description):
sandwich.Description = oReader[iField] as string;
break;
case nameof(sandwich.Price):
if (decimal.TryParse(oReader[iField] as string, out decimal dec))
{
sandwich.Price = dec;
}
break;
}
}
}
myConnection.Close();
}
}
return(sandwich);
}