public async void TestCreate_InvalidOrderDetail_ShouldFail()
{
// Arrange
OrderDetailsController controller = new OrderDetailsController(_context);
InitializeOrderDetail();
orderDetail.GameId = 99;
try
{
// Act
var result = await controller.Create(orderDetail);
// Assert
Assert.IsType <ViewResult>(result);
ViewResult viewResult = (ViewResult)result;
Assert.NotNull(viewResult.ViewData.ModelState);
Assert.NotEmpty(viewResult.ViewData.ModelState.Keys);
foreach (string item in viewResult.ViewData.ModelState.Keys)
{
Assert.Equal("", item);
}
}
catch (Exception ex)
{
Assert.Equal("Microsoft.EntityFrameworkCore.DbUpdateException", ex.GetType().ToString());
}
}
public List <Products> BuscarProducto(int OrderNumber)
{
List <Products> ob = null;
ob = OrderDetailsController.BuscarProducto(OrderNumber);
return(ob);
}
// THIS METHOD ADD PRODUCTS FROM INVENTORY TO ORDER
protected void vendorCategoryCatalog_ItemCommand(object source, RepeaterCommandEventArgs e)
{
// Collect the required data fo the event
OrderDetailsController sysmgr = new OrderDetailsController();
// obtain the productid Selected Inventory Item
int productID = int.Parse(e.CommandArgument.ToString());
// obtain the CurrentActive Order ID
int orderID = int.Parse(((Label)OrderDetailsGridView.Rows[0].FindControl("lblOrderID")).Text);
//txtComments.Text = "Order ID, this is for testing purpose: " + int.Parse(orderID);
// Qty should be equal to 1 at first
int qty = 1;
// Obtain the vendor ID
int vendorID = int.Parse(VendorDDL.SelectedValue.ToString());
// Obtain the cost
decimal itemPrice = 5;
MessageUserControl.TryRun(() =>
{
OrderDetailsController sysm = new OrderDetailsController();
sysm.Add_ProductToOrder(productID, orderID, qty, itemPrice);
List <ListVendorOrders> datainfo = sysm.Get_Active_Order(vendorID);
OrderDetailsGridView.DataSource = datainfo;
OrderDetailsGridView.DataBind();
CalculateTotal(sysm, vendorID);
}, "Adding to order", $"Product added to the order");
}
protected void btnSelectVendor_Click(object sender, EventArgs e)
{
if (VendorDDL.SelectedIndex == 0)
{
pnlInventory.Visible = false;
pnlVendorResults.Visible = false;
MessageUserControl.ShowInfo("Missing Data", "Select a vendor from the drop down list");
}
else
{
MessageUserControl.TryRun(() =>
{
pnlInventory.Visible = true;
pnlVendorResults.Visible = true;
txtComments.Text = "Comments";
// Vendors Controller to get orders
VendorsController sysmgr = new VendorsController();
OrderDetailsController controller = new OrderDetailsController();
int vendorId = int.Parse(VendorDDL.SelectedValue);
var info = sysmgr.Purchasing_Vendor_Get(vendorId);
lblVendorName.Text = info.Name;
lblVendorContact.Text = info.Contact;
lblPhone.Text = info.Phone;
//txtComments.Text = info.Orders.Comment;
// Calculate Total
CalculateTotal(controller, vendorId);
var data = controller.Get_Active_Order(int.Parse(VendorDDL.SelectedValue));
OrderDetailsGridView.DataSource = data;
OrderDetailsGridView.DataBind();
}, "Vendors Selection", "Active Order Retrieved");
}
}
public void OrderDetails_DetailsViewReturn()
{
// Arrange
var dbContext = _serviceProvider.GetRequiredService <ApplicationDbContext>();
var controller = new OrderDetailsController(dbContext);
// Act
var result = controller.Details(null);
//var result2 = controller.Details(null);
//var result3 = controller.Details(null);
// Assert
var viewResult = Assert.IsType <HttpNotFoundResult>(result);
//var viewResult2 = Assert.IsType<ViewResult>(result2);
//var viewResult3 = Assert.IsType<ViewResult>(result3);
Assert.NotNull(viewResult);
// Assert.NotNull(viewResult.);
//Assert.NotNull(viewResult2);
//Assert.NotNull(viewResult2.ViewData);
//Assert.NotNull(viewResult3);
//Assert.NotNull(viewResult3.ViewData);
//Assert.Same("Your contact page.", viewResult.ViewData["Message"]);
}
public async void TestEdit_InvalidOrderDetail_ShouldFail()
{
// Arrange
OrderDetailsController controller = new OrderDetailsController(_context);
try
{
// Act
OrderDetail replayOrderDetail = await _context.OrderDetail
.FirstOrDefaultAsync(a => a.OrderId == 20 && a.GameId == 20);
replayOrderDetail.GameId = 99;
var result = await controller.Edit(replayOrderDetail.OrderId, replayOrderDetail.GameId, replayOrderDetail);
// Assert
Assert.IsType <ViewResult>(result);
ViewResult viewResult = (ViewResult)result;
Assert.NotNull(viewResult.ViewData.ModelState);
Assert.NotEmpty(viewResult.ViewData.ModelState.Keys);
foreach (string item in viewResult.ViewData.ModelState.Keys)
{
Assert.Equal("", item);
}
}
catch (Exception ex)
{
Assert.Equal("System.NullReferenceException", ex.GetType().ToString());
}
}
public OrderDetailsControllerTests()
{
_context = new Dima3APIContext(dbContextOptions);
DummyDataDBInitializer db = new DummyDataDBInitializer();
db.Seed(_context);
_controller = new OrderDetailsController(_context);
}
public void TestOrderDetailExist_InvalidOrderIdAndGameId_Rejected(string value)
{
int orderId = int.Parse(value.Substring(0, value.IndexOf(",")));
int gameId = int.Parse(value.Substring(value.IndexOf(",") + 1,
value.Length - value.IndexOf(",") - 1));
OrderDetailsController controller = new OrderDetailsController(_context);
bool isExist = controller.OrderExists(orderId, gameId);
Assert.Equal("False", isExist.ToString());
}
public void CalculateTotal(OrderDetailsController controller, int vendorid)
{
controller = new OrderDetailsController();
var countTotal = controller.Get_Active_Order(vendorid);
var subtotal = countTotal.Sum(x => x.OrderQuantity * x.UnitCost);
var tax = subtotal * (decimal)0.05;
var total = subtotal + tax;
txtSubTotal.Text = subtotal.ToString("c");
txtTax.Text = tax.ToString("c");
txtTotal.Text = total.ToString("c");
}
public OrderItemDetailsView(Guid orderId)
{
InitializeComponent();
_orderId = orderId;
_orderItems = new List <OrderItemDTO>();
_orderDetailsController = new OrderDetailsController();
_listAllOrderItemController = new ListOrderItemsController();
_listProductController = new ListProductController();
_addOrderItemController = new AddOrderItemController();
}
public void Setup()
{
_orderDetailsService = A.Fake <IOrderDetailsService>();
_modifyOrderDetailsViewModelFactory =
A.Fake <IAsyncViewModelFactory <ModifyOrderDetailsViewModel, ModifyOrderDetailsViewModel> >();
_mapper = A.Fake <IMapper>();
_orderDetailsController = new OrderDetailsController(
_orderDetailsService,
_modifyOrderDetailsViewModelFactory,
_mapper);
}
public OrderDetailControllerTests()
{
var config = new MapperConfiguration(opts =>
{
opts.AddProfile <ModelToViewModelProfile>();
opts.AddProfile <ViewModelToModelProfile>();
});
_mapper = config.CreateMapper();
_logger = new Mock <ILoggerManager>();
_mockrepo = new Mock <IRepositoryWrapper>();
_controller = new OrderDetailsController(_mapper, _mockrepo.Object, _logger.Object);
}
public static void RegisterRoutes(RouteCollection routes)
{
routes.IgnoreRoute("{resource}.axd/{*pathInfo}");
routes.MapHttpRoute(
name: "DefaultApi",
routeTemplate: "{controller}/{id}",
defaults: new { id = RouteParameter.Optional }
);
OrdersController.AddRoutes(routes);
OrderDetailsController.AddRoutes(routes);
}
public void OrderDetails_CreatesView()
{ // return type is void not async task
// Arrange
var dbContext = _serviceProvider.GetRequiredService <ApplicationDbContext>();
var controller = new OrderDetailsController(dbContext);
// Act
var result = controller.Create(); // controller uses sync methods (not async)
// Assert
var viewResult = Assert.IsType <ViewResult>(result);
Assert.Null(viewResult.ViewName);
Assert.NotNull(viewResult.ViewData);
}
public void OrderDetails_ReturnView()
{
// Arrange
var dbContext = _serviceProvider.GetRequiredService <ApplicationDbContext>();
var controller = new OrderDetailsController(dbContext);
// Act
var result = controller.Index();
// Assert
var viewResult = Assert.IsType <ViewResult>(result);
Assert.NotNull(viewResult);
Assert.NotNull(viewResult.ViewData);
//Assert.Same("Your contact page.", viewResult.ViewData["Message"]);
}
protected void btnDelete_Click(object sender, EventArgs e)
{
int orderID = int.Parse(((Label)OrderDetailsGridView.Rows[0].FindControl("lblOrderID")).Text);
MessageUserControl.TryRun(() =>
{
OrderDetailsController controller = new OrderDetailsController();
int vendorId = int.Parse(VendorDDL.SelectedValue);
controller.Delete_ProductItem(orderID);
List <ListVendorOrders> datainfo = controller.Get_Active_Order(vendorId);
OrderDetailsGridView.DataSource = datainfo;
OrderDetailsGridView.DataBind();
CalculateTotal(controller, vendorId);
}, "Deleting Order", "Order Has been Removed");
}
public async void TestDelete_InvalidOrderDetail_ShouldFail()
{
// Arrange
OrderDetailsController controller = new OrderDetailsController(_context);
try
{
// Act
var result = await controller.DeleteConfirmed(99, 99);
}
// Assert
catch (Exception ex)
{
Assert.Equal("System.InvalidOperationException", ex.GetType().ToString());
}
}
protected void ForceClose_Click(object sender, EventArgs e)
{
var CloseOrder = new List <OrderList>();
var OrderID = int.Parse(VendorDDL.SelectedValue);
var reason = ReasonCommentReasonMessage.Text;
if (string.IsNullOrEmpty(ReasonCommentReasonMessage.Text) || OrderID == 0)
{
MessageUserControl.ShowInfo("Must enter a reason for why you would like to close this order and make sure you have a vendor selected");
}
else
{
var closeorder = new OrderList();
foreach (GridViewRow row in ReceivingGridView.Rows)
{
var closelist = new OrderList();
var ProductID = row.FindControl("ProductID") as Label;
var QuantityOutstanding = row.FindControl("QuantityOutstanding") as Label;
closelist.ProductID = int.Parse(ProductID.Text);
closelist.QuantityOutstanding = int.Parse(QuantityOutstanding.Text);
closelist.QuantityOutstanding = 0;
CloseOrder.Add(closelist);
}
ReceivingPanel.Visible = false;
MessageUserControl.TryRun(() =>
{
var closeordercontroller = new OrderDetailsController();
closeordercontroller.Force_Closure(OrderID, reason);
}, "Closure Message Sucess", "The order is now closed");
VendorDDL.DataBind();
}
}
public void ParseOrderDetails_Full()
{
var controller = new OrderDetailsController(_firebaseService);
var expectedList = new OrderDetail()
{
Id = 1,
TrackingNumber = "LB000x000",
TrackingSteps = new List <TrackingStep>()
{
new TrackingStep()
{
Date = new DateTime(2019, 10, 01, 08, 00, 00), Status = Status.Bought
},
new TrackingStep()
{
Date = new DateTime(2019, 10, 01, 08, 30, 00), Status = Status.Paid
},
new TrackingStep()
{
Date = new DateTime(2019, 10, 01, 16, 00, 00), Status = Status.Sent
},
new TrackingStep()
{
Date = new DateTime(2019, 10, 01, 16, 00, 00), Status = Status.InTransit
},
new TrackingStep()
{
Date = new DateTime(2019, 10, 06, 10, 00, 00), Status = Status.Delivered
}
}
};
var json = JsonConvert.SerializeObject(expectedList);
var list = controller.ParseOrderDetails(json);
Assert.Equal(expectedList, list);
}
protected void OrderDetailsGridView_RowCommand(object sender, GridViewCommandEventArgs e)
{
OrderDetailsController controller = new OrderDetailsController();
int vendorId = int.Parse(VendorDDL.SelectedValue);
if (e.CommandName.Equals("Refresh"))
{
int OrderDetailID = int.Parse(e.CommandArgument.ToString());
int qty = 0;
decimal unitcost = 0;
decimal perItemCost = 0;
decimal unitSize = 0;
Label yourlabel = null;
for (int rowIndex = 0; rowIndex < OrderDetailsGridView.Rows.Count; rowIndex++)
{
if ((OrderDetailsGridView.Rows[rowIndex].FindControl("lblOrderDetailID") as Label).Text == e.CommandArgument.ToString())
{
qty = int.Parse((OrderDetailsGridView.Rows[rowIndex].FindControl("txtQuantity") as TextBox).Text);
//string z = (OrderDetailsGridView.Rows[rowIndex].FindControl("txtUnitCost") as TextBox).Text;
//string zRemove = z.Remove(0, 0);
unitcost = decimal.Parse((OrderDetailsGridView.Rows[rowIndex].FindControl("txtUnitCost") as TextBox).Text);
string x = (OrderDetailsGridView.Rows[rowIndex].FindControl("lblPerItemCost") as Label).Text;
string xRemove = x.Remove(0, 1);
perItemCost = decimal.Parse(xRemove);
string y = (OrderDetailsGridView.Rows[rowIndex].FindControl("lblUnitSize") as Label).Text;
string yRemove = y.Remove(2);
unitSize = decimal.Parse(yRemove);
// For the warning message
yourlabel = (OrderDetailsGridView.Rows[rowIndex].FindControl("lblCostWarning") as Label);
//bind your label to data here
}
}
if (qty <= 0)
{
MessageUserControl.ShowInfo("Quantity can not be a negative number");
}
else if (perItemCost > (unitcost / unitSize))
{
MessageUserControl.ShowInfo("Per-item cost can not be greater than selling price");
yourlabel.Visible = true;
CalculateTotal(controller, vendorId);
}
else
{
MessageUserControl.TryRun(() =>
{
controller.Quantity_Refresh(OrderDetailID, qty, unitcost);
List <ListVendorOrders> datainfo = controller.Get_Active_Order(vendorId);
OrderDetailsGridView.DataSource = datainfo;
OrderDetailsGridView.DataBind();
CalculateTotal(controller, vendorId);
}, "Refreshing", "Item Quantity Updated");
}
}
else
{
int OrderDetailID = int.Parse(e.CommandArgument.ToString());
MessageUserControl.TryRun(() =>
{
controller.Delete_ProductItem(OrderDetailID);
List <ListVendorOrders> datainfo = controller.Get_Active_Order(vendorId);
OrderDetailsGridView.DataSource = datainfo;
OrderDetailsGridView.DataBind();
CalculateTotal(controller, vendorId);
}, "Deleting Product", "Item Has been Removed from Order");
}
}
public IActionResult Get()
{
var query = from h in context.Lg00101Orfiche
join y in context.Lg00101Orfline on h.Logicalref equals y.Ordficheref
join r in context.Lg001Clcard on h.Clientref equals r.Logicalref
join x in context.Lg001Items on y.Stockref equals x.Logicalref
join q in context.Lg001Unitsetf on y.Usref equals q.Logicalref
join z in context.Lg001Unitsetl on y.Uomref equals z.Logicalref
join w in context.Lg001Specodes.Where(p => p.Spetyp1 == 1) on x.Specode equals w.Specode into ej
from w in ej.DefaultIfEmpty()
join e in context.Lg001Specodes.Where(p => p.Spetyp2 == 1) on x.Specode2 equals e.Specode into ed
from e in ed.DefaultIfEmpty()
join a in context.Lg001Specodes.Where(p => p.Spetyp3 == 1) on x.Specode3 equals a.Specode into ey from a in ey.DefaultIfEmpty()
join b in context.Lg001Specodes.Where(p => p.Spetyp4 == 1) on x.Specode4 equals b.Specode into ek
from b in ek.DefaultIfEmpty()
join g in context.Lg001Specodes.Where(p => p.Spetyp5 == 1) on x.Specode5 equals g.Specode into eo from g in eo.DefaultIfEmpty()
select new
{
Logicalref = h.Logicalref,
Sipdetay = y.Logicalref,
Main = new
{
MainCode = q.Code,
MainName = q.Name,
MainLogicalRef = q.Logicalref,
MainCreatedTime = q.CapiblockCreadeddate,
MainModifiedTime = q.CapiblockModifieddate
},
Alt = new
{
AltCode = z.Code,
AltName = z.Name,
AltId = z.Logicalref,
AltMainID = z.Unitsetref
},
Item = new
{
ItemId = x.Logicalref,
ItemCode = x.Code,
ItemName = x.Name,
ItemColor = w.Definition,
ItemFloor = e.Definition,
ItemPattern = a.Definition,
ItemRope = b.Definition,
ItemStrike = g.Definition,
ItemCreatedTime = x.CapiblockCreadeddate,
ItemModifiedTime = x.CapiblockModifieddate
},
Client = new {
ClientId = r.Logicalref,
ClientName = r.Definition,
ClientCode = r.Code
},
Order = new
{
orderId = h.Logicalref,
FicheNo = h.Ficheno,
clientid = r.Logicalref
},
Orderdetail = new
{
OrderId = h.Logicalref,
amount = y.Amount,
altunitId = z.Logicalref,
itemId = x.Logicalref
},
Ficheno = h.Ficheno,
Date = h.Date,
Time = h.Time,
Stockref = y.Stockref,
specode1 = w.Definition,
specode2 = e.Definition,
specode3 = a.Definition,
specode4 = b.Definition,
specode5 = g.Definition,
Musteri = h.Clientref,
musterino = r.Code,
birim = y.Usref
};
foreach (var item in query)
{
//client oluşturma
ClientsController clientsController = new ClientsController(_context);
Client client = new Client();
client.Name = item.Client.ClientName;
client.ClientCode = item.Client.ClientCode;
client.Id = item.Client.ClientId;
clientsController.PostClient(client);
//item oluşturma
ItemsController itemsController = new ItemsController(_context);
Item item1 = new Item();
item1.Id = item.Item.ItemId;
item1.Code = item.Item.ItemCode;
item1.Name = item.Item.ItemName;
item1.Color = item.Item.ItemColor;
item1.Floor = item.Item.ItemFloor;
item1.Pattern = item.Item.ItemPattern;
item1.Rope = item.Item.ItemRope;
item1.Strike = item.Item.ItemStrike;
item1.LogicCreatedDate = item.Item.ItemCreatedTime;
item1.LogicModifiedDate = item.Item.ItemModifiedTime;
itemsController.PostItem(item1);
//mainunit
MainUnitsController mainUnit = new MainUnitsController(_context);
MainUnit main = new MainUnit();
main.Code = item.Main.MainCode.ToString();
main.Name = item.Main.MainName;
main.Id = item.Main.MainLogicalRef;
main.LogicCreatedDate = item.Main.MainCreatedTime;
main.LogicModifiedDate = item.Main.MainModifiedTime;
mainUnit.PostMainUnit(main);
//altUnit
AltUnitsController altUnit = new AltUnitsController(_context);
AltUnit alt = new AltUnit();
alt.Id = item.Alt.AltId;
alt.Code = item.Alt.AltCode;
alt.Name = item.Alt.AltName;
alt.MainUnitId = item.Alt.AltMainID;
//altUnit.PostAltUnit(alt);
altUnit.PostAltUnit(alt);
//order
OrdersController order1 = new OrdersController(_context);
Order order = new Order();
order.Id = item.Order.orderId;
order.FicheNo = item.Order.FicheNo;
order.ClientId = item.Order.clientid;
order.Statu = 0;
order1.PostOrder(order);
//orderdetail
OrderDetailsController orderDetail = new OrderDetailsController(_context);
OrderDetail orderd = new OrderDetail();
orderd.OrderId = item.Orderdetail.OrderId;
orderd.Amount = item.Orderdetail.amount;
orderd.AltUnitId = item.Orderdetail.altunitId;
orderd.ItemId = item.Orderdetail.itemId;
orderDetail.PostOrderDetail(orderd);
}
return(Ok(query));
}
