public Item Get(int itemNumber)
{
SqlConnection BAIS3150 = new SqlConnection();
BAIS3150.ConnectionString = @"Persist Security Info=False; Database=ihugya1;User ID=ihugya1;Password=SimpCord101;server=dev1.baist.ca;";
BAIS3150.Open();
SqlCommand GetItemCommand = new SqlCommand
{
Connection = BAIS3150,
CommandType = CommandType.StoredProcedure,
CommandText = "GetItem"
};
SqlParameter AGetCommandParameter = new SqlParameter
{
ParameterName = "@ItemNumber",
SqlDbType = SqlDbType.Int,
Direction = ParameterDirection.Input,
SqlValue = itemNumber
};
GetItemCommand.Parameters.Add(AGetCommandParameter);
SqlDataReader AGetCommandDataReader;
AGetCommandDataReader = GetItemCommand.ExecuteReader();
Item ExampleItem = new Item();
if (AGetCommandDataReader.HasRows)
{
AGetCommandDataReader.Read();
ExampleItem.ItemNumber = itemNumber;
ExampleItem.Description = (string)AGetCommandDataReader["Description"];
ExampleItem.UnitPrice = (decimal)AGetCommandDataReader["UnitPrice"];
}
AGetCommandDataReader.Close();
BAIS3150.Close();
return(ExampleItem);
}
public DatabaseUser GetDatabaseUser()
{
//ConfigurationBuilder DatabaseUsersBuilder = new ConfigurationBuilder();
// DatabaseUsersBuilder.SetBasePath(Directory.GetCurrentDirectory());
// DatabaseUsersBuilder.AddJsonFile("appsettings.json");
// IConfiguration DatabaseUsersConfiguration = DatabaseUsersBuilder.Build();
// SqlConnection BAIS3150 = new SqlConnection();
// BAIS3150.ConnectionString = DatabaseUsersConfiguration.GetConnectionString("BAIS3150");
SqlConnection BAIS3150; //declararation
BAIS3150 = new SqlConnection(); //instantiation
BAIS3150.ConnectionString = @$ "Persist Security Info=False;Database=ihugya1;User ID=ihugya1;Password=SimpCord101;server=dev1.baist.ca;";
BAIS3150.Open();
BAIS3150.Open();
SqlCommand AGetCommand = new SqlCommand
{
Connection = BAIS3150,
CommandType = CommandType.StoredProcedure,
CommandText = "GetDatabaseUser"
};
SqlDataReader AGetCommandDataReader;
AGetCommandDataReader = AGetCommand.ExecuteReader();
DatabaseUser CurrentDatabaseUser = new DatabaseUser();
if (AGetCommandDataReader.HasRows)
{
AGetCommandDataReader.Read();
CurrentDatabaseUser.CurrentUser = (string)AGetCommandDataReader["CurrentUser"];
CurrentDatabaseUser.SystemUser = (string)AGetCommandDataReader["SystemUser"];
CurrentDatabaseUser.SessionUser = (string)AGetCommandDataReader["SessionUser"];
}
AGetCommandDataReader.Close();
BAIS3150.Close();
return(CurrentDatabaseUser);
}
public List <Item> Get()
{
SqlConnection BAIS3150 = new SqlConnection();
BAIS3150.ConnectionString = @"Persist Security Info=False; Database=ihugya1;User ID=ihugya1;Password=SimpCord101;server=dev1.baist.ca;";
BAIS3150.Open();
SqlCommand GetItemCommand = new SqlCommand
{
Connection = BAIS3150,
CommandType = CommandType.StoredProcedure,
CommandText = "GetItems"
};
SqlDataReader AGetCommandDataReader;
AGetCommandDataReader = GetItemCommand.ExecuteReader();
List <Item> ExampleItems = new List <Item>();
if (AGetCommandDataReader.HasRows)
{
while (AGetCommandDataReader.Read())
{
Item ExampleItem = new Item
{
ItemNumber = (int)AGetCommandDataReader["ItemNumber"],
Description = AGetCommandDataReader["Description"].ToString(),
UnitPrice = (decimal)AGetCommandDataReader["UnitPrice"]
};
ExampleItems.Add(ExampleItem);
}
}
AGetCommandDataReader.Close();
BAIS3150.Close();
return(ExampleItems);
}
