public static void DeleteCommodity()
{
DisplayAllCommodities();
BlobDbContext db = new BlobDbContext();
Commodity com = new Commodity();
Console.WriteLine("Please enter the Commodity ID that you want to delete : ");
var input = Console.ReadLine();
Console.WriteLine();
if (Int32.TryParse(input, out int userInput))
{
var rowcount = db.Commodities.Find(userInput);
if (rowcount != null)
{
db.Commodities.Remove(rowcount);
db.SaveChanges();
Console.WriteLine("Commodity successfully deleted. Returning to main menu..", Color.Green);
}
else
{
Console.WriteLine("Not a valid commodity ID, Hit enter to return to main menu", Color.Red);
Console.ReadLine();
}
}
}
public static void AddCommodity()
{
BlobDbContext db = new BlobDbContext();
Console.WriteLine("All fields are mandatory and cannot be blank\n");
Commodity com = new Commodity();
do
{
Console.WriteLine("Commodity Code: ");
com.CommodityCode = Console.ReadLine();
}while (String.IsNullOrEmpty(com.CommodityCode));
do
{
Console.WriteLine("Commodity Name : ");
com.CommodityName = Console.ReadLine();
}while (String.IsNullOrEmpty(com.CommodityName));
do
{
Console.WriteLine("Unit : ");
com.Unit = Console.ReadLine();
}while (String.IsNullOrEmpty(com.Unit));
do
{
Console.WriteLine("Estimated Quantity : ");
com.EstimatedQuantity = Console.ReadLine();
}while (String.IsNullOrEmpty(com.EstimatedQuantity));
do
{
Console.WriteLine("Actual Quantity : ");
com.ActualQuantity = Console.ReadLine();
}while (String.IsNullOrEmpty(com.ActualQuantity));
db.Commodities.Add(com);
db.SaveChanges();
Console.WriteLine("\nCommodity added successfully. Hit enter to return to main menu", Color.Green);
Console.ReadLine();
}