public OrdersRefDTO UpdateOrderRef(OrdersRefDTO orderRef)
{
using (var entities = new TradingCompanyEntities())
{
entities.OrdersRefs.AddOrUpdate(_mapper.Map <OrdersRef>(orderRef));
var _orderRef = entities.OrdersRefs.Single(o => (o.refOrderID == orderRef.refOrderID & o.refItemID == orderRef.refItemID));
entities.SaveChanges();
return(_mapper.Map <OrdersRefDTO>(_orderRef));
}
}
public OrdersRefDTO CreateOrderRef(OrdersRefDTO orderRef)
{
using (var entities = new TradingCompanyEntities())
{
OrdersRef o = _mapper.Map <OrdersRef>(orderRef);
entities.OrdersRefs.Add(o);
entities.SaveChanges();
return(_mapper.Map <OrdersRefDTO>(o));
}
}
public OrdersRefDTO UpdateOrderRef(OrdersRefDTO orderRef)
{
using (SqlConnection conn = new SqlConnection(this.connectionString))
using (SqlCommand comm = conn.CreateCommand())
{
comm.CommandText = "UPDATE OrdersRef set amount = @amount";
comm.Parameters.Clear();
comm.Parameters.AddWithValue("@amount", orderRef.amount);
conn.Open();
//
orderRef.refOrderID = Convert.ToInt64(comm.ExecuteScalar());
return(orderRef);
}
}
public OrdersRefDTO CreateOrderRef(OrdersRefDTO orderRef)
{
using (SqlConnection conn = new SqlConnection(this.connectionString))
using (SqlCommand comm = conn.CreateCommand())
{
comm.CommandText = "INSERT into OrdersRef (refOrderID, refItemID, amount) values (@refOrderID, @refItemID, @amount)";
comm.Parameters.Clear();
comm.Parameters.AddWithValue("@refOrderID", orderRef.refOrderID);
comm.Parameters.AddWithValue("@refItemID", orderRef.refItemID);
comm.Parameters.AddWithValue("@amount", orderRef.amount);
conn.Open();
return(orderRef);
}
}
private void deleteItemsFromOrder()
{
Console.WriteLine("\t~*~ ~*~ ~*~ \tDeleting Items from Order\t ~*~ ~*~ ~*~\n");
Console.WriteLine("Input OrderID: ");
long id = Convert.ToInt64(Console.ReadLine());
OrderDTO myOrder = dalorder.GetOrderByID(id);
if (myOrder is null) //check if such order exists
{
Console.WriteLine("\n~~~ ERROR ~~~~\t No such order in database.\n");
return;
}
IMapper mapper = SetupMapper();
IOrdersRefDal dalref = new OrdersRefDalEf(mapper);
List <OrdersRefDTO> myList = dalref.GetItemsInOrder(id); //get all items in this order
foreach (var i in myList)
{
Console.WriteLine("Amount: {0}, ItemID: {1}", i.amount, i.refItemID);
}
Console.WriteLine("Names of Items in order: ");
printItemsInOrder(myOrder.MainOrderID); //print those items
Console.WriteLine("Input ID of Item you want to delete: ");
long _itemID = Convert.ToInt64(Console.ReadLine());
OrdersRefDTO currentItem = myList.Find(o => o.refItemID == _itemID);
if (currentItem is null)
{
Console.WriteLine("\n~~~ ERROR ~~~~\tNo such item in order!\n\n");
return;
}
dalref.DeleteOrderRef(id, _itemID);
}
private void updateItemInOrder()
{
Console.WriteLine("\t~*~ ~*~ ~*~ \tAdding Items to an Order\t ~*~ ~*~ ~*~\n");
Console.WriteLine("Input OrderID: ");
long id = Convert.ToInt64(Console.ReadLine());
OrderDTO myOrder = dalorder.GetOrderByID(id);
if (myOrder is null) //check if such order exists
{
Console.WriteLine("\n~~~ ERROR ~~~~\t No such order in database.\n");
return;
}
IMapper mapper = SetupMapper();
IOrdersRefDal dalref = new OrdersRefDalEf(mapper);
List <OrdersRefDTO> myList = dalref.GetItemsInOrder(id);
bool flag = true;
while (flag)
{
Console.WriteLine($"~ Updating Order: {myOrder.MainOrderID}");
foreach (var i in myList)
{
Console.WriteLine("Amount: {0}, ItemID: {1}", i.amount, i.refItemID);
}
Console.WriteLine("Names of Items in order: ");
printItemsInOrder(myOrder.MainOrderID);
Console.WriteLine("\nChoose an option:" +
"\n\t1. Change number of items" +
"\n\t0. Exit");
try
{
int opt = Convert.ToInt32(Console.ReadLine());
if (opt == 0)
{
flag = false;
}
switch (opt)
{
case 1:
Console.WriteLine("Input ID of Item you wish to change number of: ");
long _itemID = Convert.ToInt64(Console.ReadLine());
OrdersRefDTO currentItem = myList.Find(o => o.refItemID == _itemID);
if (currentItem is null)
{
Console.WriteLine("\n~~~ ERROR ~~~~\tNo such item in order!\n\n");
break;
}
Console.WriteLine("Input new number of items: ");
int am = Convert.ToInt32(Console.ReadLine());
currentItem.amount = am;
currentItem = dalref.UpdateOrderRef(currentItem);
Console.WriteLine($"Updated number of items: {currentItem.amount}");
break;
case 0:
flag = false;
break;
default:
throw new Exception("Invalid input.");
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
Console.WriteLine("Try again, or input 0 to exit.");
}
}
}
private void addItems() //creates rows in table OrdersRef
{
Console.WriteLine("\t~*~ ~*~ ~*~ \tAdding Items to an Order\t ~*~ ~*~ ~*~\n");
Console.WriteLine("Input OrderID: ");
long id = Convert.ToInt64(Console.ReadLine());
OrderDTO myOrder = dalorder.GetOrderByID(id);
if (myOrder is null) //check if such order exists
{
Console.WriteLine("Invalid input! No such order in database.\n");
return;
}
ItemsManager MyItems = new ItemsManager(new ItemDalEf(SetupMapper()));
MyItems.printAll();
Console.WriteLine("Input 1 to add an item or 0 to exit");
int step;
bool flag = true;
while (flag)
{
try
{
step = Convert.ToInt32(Console.ReadLine());
switch (step)
{
case 1:
Console.WriteLine("Input ID of the Item you want to add: ");
long _itemID = Convert.ToInt64(Console.ReadLine());
Console.WriteLine("How many items you wish to add?");
int _amount = Convert.ToInt32(Console.ReadLine());
OrdersRefDTO _myOrder = new OrdersRefDTO
{
refOrderID = myOrder.MainOrderID,
refItemID = _itemID,
amount = _amount
};
IMapper mapper = SetupMapper();
IOrdersRefDal dalref = new OrdersRefDalEf(mapper);
_myOrder = dalref.CreateOrderRef(_myOrder);
Console.WriteLine($"~ Success! ~\nNew Item with ID {_myOrder.refItemID} added to order {_myOrder.refOrderID}");
Console.WriteLine("\nInput 1 to add an item or 0 to exit");
break;
case 0:
flag = false;
break;
default:
throw new Exception("Invalid data inputted. Try again!");
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
Console.WriteLine("\nSomething went wrong... Try again, or input 0 to exit.");
}
}
}
