public async Task <ActionResult> DeleteShipments([FromBody] List <ShipmentDataRequest> shipmentDataRequests)
{
ShipmentService shipmentService = new ShipmentService();
ShipmentDataResponse shipmentDataResponse = shipmentService.DeleteShipments(shipmentDataRequests);
return(Ok(shipmentDataResponse));
}
public void FindShipmentsListModelTest()
{
// Get a test user and test company
var testUser = GetTestUser();
var testCompany = GetTestCompany(testUser, true);
// Perform a global test which should bring back the first page of all shipments
var result = ShipmentService.FindShipmentsListModel(testCompany.Id, 0, 1, PageSize, "");
Assert.IsTrue(result.Items.Count == 0, $"Error: {result.Items.Count} records were found when 0 were expected");
// Now create a shipment and try to search for it
var testShipment = GetTestShipment(testCompany, testUser, 1);
result = ShipmentService.FindShipmentsListModel(testCompany.Id, 0, 1, PageSize, "");
Assert.IsTrue(result.Items.Count == 1, $"Error: {result.Items.Count} records were found when 1 was expected");
Assert.IsTrue(result.Items[0].ShipmentId == testShipment.Id, $"Error: Shipment {result.Items[0].ShipmentId} was returned when {testShipment.Id} was expected");
// Delete the record
ShipmentService.DeleteShipment(testShipment.Id);
// Try to find it again
result = ShipmentService.FindShipmentsListModel(testCompany.Id, 0, 1, PageSize, "");
Assert.IsTrue(result.Items.Count == 0, $"Error: {result.Items.Count} records were found when 0 was expected");
}
public void Return_Created_Shipment()
{
var options = Utils.GetOptions(nameof(Return_Created_Shipment));
var newShipmentDTO = new Mock <NewShipmentDTO>().Object;
newShipmentDTO.Id = 1;
newShipmentDTO.WarehouseId = 1;
newShipmentDTO.StatusId = 1;
using (var arrangeContext = new DeliverItContext(options))
{
arrangeContext.Warehouses.AddRange(Utils.SeedWarehouses());
arrangeContext.Statuses.AddRange(Utils.SeedStatuses());
arrangeContext.Addresses.AddRange(Utils.SeedAddresses());
arrangeContext.SaveChanges();
}
using (var actContext = new DeliverItContext(options))
{
var sut = new ShipmentService(actContext);
var result = sut.Create(newShipmentDTO);
Assert.AreEqual(1, actContext.Shipments.ToList().Count());
Assert.AreEqual(newShipmentDTO.Id, result.Id);
Assert.AreEqual(newShipmentDTO.StatusId, result.StatusId);
Assert.AreEqual(newShipmentDTO.WarehouseId, result.WarehouseId);
}
}
public void Delete(ShipmentDTO client)
{
IWindowManager manager = new WindowManager();
ShipmentService.Delete(client);
Reload();
}
private void CreateShipment_OK_Click(object sender, EventArgs e)
{
ValidateChildren();
if (Company_Validation.Text == "" && City_Validation.Text == "" && Country_Validation.Text == "" && Quantity_Validation.Text == "" && Sum_Validation.Text == "")
{
DtoShipmentsViewModel = new DTOShipmentsViewModel
{
ShipmentDate = DateTime.Now,
Company = CompanyBox.Text,
City = CityBox.Text,
Country = CountryBox.Text,
Login = LoginUser,
Quantity = Convert.ToInt32(QuantityBox.Text),
Sum = Convert.ToDecimal(SumBox.Text),
};
var responce = ShipmentService.CreateShipment(DtoShipmentsViewModel);
if (responce.Responce == null)
{
DtoShipmentsViewModel.Id = responce.Id;
DtoShipmentsViewModel.SurnameName = responce.SurnameName;
MessageBox.Show("Shipment was added");
DialogResult = DialogResult.OK;
Close();
}
CreateShipment_Validation.Text = responce.Responce;
}
}
public void Return_Shipments_Warehouse3()
{
var options = Utils.GetOptions(nameof(Return_Shipments_Warehouse3));
string filter = "warehouse";
string value = "1";
var shipments = Utils.SeedShipments();
using (var arrangeContext = new DeliverItContext(options))
{
arrangeContext.Shipments.AddRange(shipments);
arrangeContext.Warehouses.AddRange(Utils.SeedWarehouses());
arrangeContext.Statuses.AddRange(Utils.SeedStatuses());
arrangeContext.Addresses.AddRange(Utils.SeedAddresses());
arrangeContext.SaveChanges();
}
using (var actContext = new DeliverItContext(options))
{
var sut = new ShipmentService(actContext);
var filtered = actContext.Shipments.Where(s => s.WarehouseId == int.Parse(value) && s.IsDeleted == false);
var result = sut.GetBy(filter, value);
Assert.AreEqual(string.Join(",", filtered.Select(p => new ShipmentDTO(p))), string.Join(",", result));
}
}
public List <ShipmentDataRequest> GetShipmentData(int wid)
{
shipmentService = new ShipmentService();
List <ShipmentDataRequest> shipmentDataRequests = shipmentService.GetShipment(wid);
return(shipmentDataRequests);
}
public ActionResult AddToShipmentPopup()
{
var model = new AddToShipmentPopupViewModel();
model.ShipmentList = ShipmentService.FindShipmentsListItemModel(CurrentCompany, true);
return(View("AddToShipmentPopup", model));
}
private void btnSelect_Click(object sender, EventArgs e)
{
dgvStockStatus.Columns.Clear();
dgvStockStatus.DataSource = null;
//조회 버튼
try
{
InventoryOrderMgtVO vo = new InventoryOrderMgtVO();
vo.start_date = dtpFromDate.Value.ToShortDateString();
vo.end_date = dtpToDate.Value.ToShortDateString();
if (cboFromFac.Text != "선택")
{
vo.fromFactory = cboFromFac.SelectedValue.ToString();
}
if (txtProduct.Text != "")
{
vo.product_name = txtProduct.Text.Trim();
}
ShipmentService service_shipment = new ShipmentService();
shipment_list = service_shipment.GetInventoryStatusByOrder(vo);
SetDGV(_cboToFac);
SetBottomStatusLabel($"{shipment_list.Count}건이 조회되었습니다.");
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
SetBottomStatusLabel("다시 검색하세요.");
}
}
private void DeleteShipmentButton_Click(object sender, EventArgs e)
{
if (ShipmentsGrid.RowCount != 0)
{
// Delete shipment can only owner (manager).
if (ShipmentsGrid.CurrentRow.Cells["Login"].Value.ToString() == LoginUser)
{
DialogResult result = MessageBox.Show("Are you sure you want to delete shipment", "", MessageBoxButtons.OKCancel);
if (result == DialogResult.OK)
{
int idCurrent = int.Parse(ShipmentsGrid.CurrentRow.Cells["Id"].Value.ToString());
if (ShipmentService.DeleteShipment(idCurrent))
{
var shipmentsGridItems = (List <DTOShipmentsViewModel>)ShipmentsGrid.DataSource;
shipmentsGridItems.RemoveAt(shipmentsGridItems.FindIndex(x => x.Id == idCurrent));
ShipmentsGrid.DataSource = null;
ShipmentsGrid.DataSource = shipmentsGridItems;
SetupGrid();
if (ShipmentsGrid.RowCount != 0)
{
ShipmentsGrid.CurrentCell = ShipmentsGrid.Rows[0].Cells["Sum"];
}
MessageBox.Show("Shipment deleted");
}
}
}
}
}
public void Return_Updated_Shipment()
{
var options = Utils.GetOptions(nameof(Return_Updated_Shipment));
var updateShipmentDTO = new Mock <UpdateShipmentDTO>().Object;
updateShipmentDTO.WarehouseId = 1;
updateShipmentDTO.StatusId = 1;
updateShipmentDTO.Departure = DateTime.UtcNow.AddDays(1);
updateShipmentDTO.Arrival = DateTime.UtcNow.AddDays(2);
using (var arrangeContext = new DeliverItContext(options))
{
arrangeContext.Shipments.AddRange(Utils.SeedShipments());
arrangeContext.Warehouses.AddRange(Utils.SeedWarehouses());
arrangeContext.Statuses.AddRange(Utils.SeedStatuses());
arrangeContext.Addresses.AddRange(Utils.SeedAddresses());
arrangeContext.SaveChanges();
}
using (var actContext = new DeliverItContext(options))
{
var sut = new ShipmentService(actContext);
var result = sut.Update(1, updateShipmentDTO);
Assert.AreEqual(updateShipmentDTO.StatusId, result.StatusId);
Assert.AreEqual(updateShipmentDTO.WarehouseId, result.WarehouseId);
Assert.AreEqual(updateShipmentDTO.Departure.ToString("dd.MMMM.yyyy"), result.Departure);
Assert.AreEqual(updateShipmentDTO.Arrival.ToString("dd.MMMM.yyyy"), result.Arrival);
}
}
public void Throws_When_UpdateShipmentInputStatusId_NotFound()
{
var options = Utils.GetOptions(nameof(Throws_When_UpdateShipmentInputStatusId_NotFound));
var updateShipmentDTO = new Mock <UpdateShipmentDTO>().Object;
updateShipmentDTO.WarehouseId = 1;
updateShipmentDTO.StatusId = 1;
updateShipmentDTO.Departure = DateTime.UtcNow.AddDays(1);
updateShipmentDTO.Arrival = DateTime.UtcNow.AddDays(2);
using (var arrangeContext = new DeliverItContext(options))
{
arrangeContext.Warehouses.AddRange(Utils.SeedWarehouses());
arrangeContext.Addresses.AddRange(Utils.SeedAddresses());
arrangeContext.SaveChanges();
}
using (var actContext = new DeliverItContext(options))
{
var sut = new ShipmentService(actContext);
Assert.ThrowsException <ArgumentNullException>(() => sut.Update(1, updateShipmentDTO));
}
}
private void btnSelect_Click(object sender, EventArgs e)
{
//조회 버튼
try
{
ShipmentClosingVO vo = new ShipmentClosingVO();
vo.start_date = dtpFromDate.Value.ToShortDateString();
vo.end_date = dtpToDate.Value.ToShortDateString();
if (cboCustomer.Text != "선택")
{
vo.company_code = cboCustomer.SelectedValue.ToString();
}
if (txtProduct.Text != "")
{
vo.product_name = txtProduct.Text.Trim();
}
SetDGV();
dt = new DataTable();
shipment_service = new ShipmentService();
dt = shipment_service.GetSalesCompleteStatus(vo);
dgvClientOrder.DataSource = dt;
SetBottomStatusLabel($"{dt.Rows.Count}건이 조회되었습니다.");
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
}
public void Return_Correct_Shipment()
{
var options = Utils.GetOptions(nameof(Return_Correct_Shipment));
var shipments = Utils.SeedShipments();
using (var arrangeContext = new DeliverItContext(options))
{
arrangeContext.Shipments.AddRange(shipments);
arrangeContext.Warehouses.AddRange(Utils.SeedWarehouses());
arrangeContext.Statuses.AddRange(Utils.SeedStatuses());
arrangeContext.Addresses.AddRange(Utils.SeedAddresses());
arrangeContext.SaveChanges();
}
var shipmentDTO = new ShipmentDTO(shipments.First());
using (var actContext = new DeliverItContext(options))
{
var sut = new ShipmentService(actContext);
var result = sut.Get(1);
Assert.AreEqual(shipmentDTO.Id, result.Id);
Assert.AreEqual(shipmentDTO.Status, result.Status);
Assert.AreEqual(shipmentDTO.Warehouse, result.Warehouse);
Assert.AreEqual(shipmentDTO.Departure, result.Departure);
Assert.AreEqual(shipmentDTO.Arrival, result.Arrival);
}
}
void prepareEditModel(EditPurchaseOrderHeaderTempViewModel model, int id)
{
var poht = PurchasingService.FindPurchaseOrderHeaderTempModel(id, CurrentCompany, false);
PrepareViewModel(model, EvolutionResources.bnrAddEditPurchase + " - " + EvolutionResources.lblOrderNumber + ": " + model.PurchaseTemp.OrderNumber.ToString(), id, MakeMenuOptionFlags(0, poht.OriginalRowId, 0) + MenuOptionFlag.RequiresNewPurchase);
model.ParentId = id;
// Get the landing date from the Shipment record
if (model.PurchaseTemp.OrderNumber != null)
{
var shipmentContent = ShipmentService.FindShipmentContentByPONoModel(CurrentCompany, model.PurchaseTemp.OrderNumber.Value);
if (shipmentContent != null && shipmentContent.ShipmentId != null)
{
var shipment = ShipmentService.FindShipmentModel(shipmentContent.ShipmentId.Value, CurrentCompany);
}
}
model.LocationList = LookupService.FindLocationListItemModel(model.CurrentCompany);
model.SupplierList = SupplierService.FindSupplierListItemModel(CurrentCompany);
model.POStatusList = LookupService.FindPurchaseOrderHeaderStatusListItemModel();
model.UserList = MembershipManagementService.FindUserListItemModel();
model.PaymentTermsList = LookupService.FindPaymentTermsListItemModel(model.CurrentCompany);
model.CommercialTermsList = LookupService.FindLOVItemsListItemModel(model.CurrentCompany, LOVName.CommercialTerms);
model.PortList = LookupService.FindPortsListItemModel();
model.ShipMethodList = LookupService.FindLOVItemsListItemModel(model.CurrentCompany, LOVName.ShippingMethod);
model.ContainerTypeList = LookupService.FindContainerTypeListItemModel();
model.FreightForwarderList = LookupService.FindFreightForwardersListItemModel(model.CurrentCompany);
model.CurrencyList = LookupService.FindCurrenciesListItemModel();
model.BrandCategoryList = ProductService.FindBrandCategoryListItemModel(model.CurrentCompany);
}
public void Add()
{
if (IsEdit == true)
{
toEdit.ShippedItem = ShippedItem;
toEdit.ItemQuantity = ItemQuantity;
toEdit.RecipientCompany = RecipientCompany;
toEdit.CityTown = CityTown;
toEdit.PostalCode = string.Format("{0}-{1}", PostalCode1, PostalCode2);
toEdit.StreetAddress = StreetAddress;
toEdit.Weight = Weight;
toEdit.Description = Description;
ShipmentService.Edit(toEdit);
}
else
{
var newShipment = new ShipmentDTO();
newShipment.ShippedItem = ShippedItem;
newShipment.ItemQuantity = ItemQuantity;
newShipment.RecipientCompany = RecipientCompany;
newShipment.CityTown = CityTown;
newShipment.PostalCode = string.Format("{0}-{1}", PostalCode1, PostalCode2);
newShipment.StreetAddress = StreetAddress;
newShipment.Weight = Weight;
newShipment.Description = Description;
ShipmentService.Add(newShipment);
}
TryClose();
}
public ActionResult Save(EditShipmentViewModel model, string command)
{
if (command.ToLower() == "save")
{
// Save the screen data back to the db and exit
adjustDates(model.Shipment, model.TZ);
var modelError = ShipmentService.InsertOrUpdateShipment(model.Shipment, CurrentUser, model.LGS);
if (modelError.IsError)
{
prepareEditModel(model, model.Shipment);
model.SetErrorOnField(ErrorIcon.Error,
modelError.Message,
"Shipment_" + modelError.FieldName);
return(View("Edit", model));
}
else
{
return(RedirectToAction("Shipments"));
}
}
else
{
return(RedirectToAction("Shipments"));
}
}
public void LockShipmentTest()
{
// Get a test user and test company
var testUser = GetTestUser();
var testCompany = GetTestCompany(testUser);
// Create a shipment
var model = GetTestShipment(testCompany, testUser);
// Get the current Lock
string lockGuid = ShipmentService.LockShipment(model);
Assert.IsTrue(!string.IsNullOrEmpty(lockGuid), "Error: Lock record was not found");
// Simulate another user updating the record
var otherUser = GetTestUser();
var error = ShipmentService.InsertOrUpdateShipment(model, otherUser, lockGuid);
Assert.IsTrue(!error.IsError, error.Message);
// Now get the first user to update the record
error = ShipmentService.InsertOrUpdateShipment(model, testUser, lockGuid);
Assert.IsTrue(error.IsError, "Error: The lock should have caused an error as it has changed");
// Try to update with the new lock
lockGuid = ShipmentService.LockShipment(model);
error = ShipmentService.InsertOrUpdateShipment(model, testUser, lockGuid);
Assert.IsTrue(!error.IsError, $"Error: {error.Message}");
}
public ActionResult GetShipmentDetails(int shipmentId, int index)
{
var model = createModel();
return(Json(ShipmentService.FindShipmentContentListModel(CurrentCompany, shipmentId, index),
JsonRequestBehavior.AllowGet));
}
private void dgvClientOrder_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
shipment_service = new ShipmentService();
price_present = shipment_service.GetPresentPrice(Convert.ToInt32(dgvClientOrder[12, dgvClientOrder.CurrentRow.Index].Value));
GridViewUtil.SetDgvTextBoxColor(dgvClientOrder, 9);
}
public static async Task <IActionResult> InsertFlown([HttpTrigger(AuthorizationLevel.Anonymous, "post")] HttpRequestMessage req, ILogger log)
{
log.LogInformation("C# HTTP trigger function InsertFlown processed a request.");
dynamic data = await req.Content.ReadAsAsync <object>();
string shipmentAddr = data?.shipmentAddr;
string flightCarrier = data?.flightCarrier;
string flightNumber = data?.flightNumber;
BigInteger flightDate = data?.flightDate;
string boardPoint = data?.boardPoint;
string offPoint = data?.offPoint;
string uldInfo = data?.uldInfo;
var svc = new ShipmentService(GetWeb3(), shipmentAddr);
await svc.InsertFlownRequestAsync(
flightCarrier,
flightNumber,
flightDate,
boardPoint,
offPoint,
uldInfo
);
return(new OkObjectResult("Flown is inserted."));
}
private void Main_Load(object sender, EventArgs e)
{
Login login = new Login(UserService);
if (login.ShowDialog() != DialogResult.OK)
{
this.Close();
}
GroupBox.Visible = true;
ShipmentsGrid.Visible = true;
MainPanel.Visible = true;
AnswerClose = true;
Admin = login.Admin;
LoginUser = login.LoginUser;
menuStrip1.Visible = true;
if (!Admin)
{
administeringToolStripMenuItem.Visible = false;
}
ShipmentsGrid.EnableHeadersVisualStyles = false;
ShipmentsGrid.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
ShipmentsGrid.DataSource = ShipmentService.GetShipments();
SetupGrid();
}
public void FindShipmentContentByPONoModelTest()
{
var testUser = GetTestUser();
var testCompany = GetTestCompany(testUser, true);
var testShipment = GetTestShipment(testCompany, testUser, 10);
var newPoh = GetTestPurchaseOrderHeader(testCompany, testUser, RandomInt(10, 20));
var newItem = ShipmentService.AddPurchaseOrder(testCompany, testUser, testShipment, newPoh);
var checkContent = ShipmentService.FindShipmentContentByPONoModel(testCompany, newPoh.OrderNumber.Value, false);
Assert.IsTrue(checkContent != null, "Error: A NULL value was returned when an object was expected");
var checkPoh = PurchasingService.FindPurchaseOrderHeaderModel(checkContent.PurchaseOrderHeaderId.Value, testCompany, false);
var excludes = new List <string>();
excludes.Add("OrderNumberUrl"); // Because it isn't known at test prep
AreEqual(newPoh, checkPoh, excludes);
db.DeletePurchaseOrderHeader(newPoh.Id);
// Check that it has gone
checkContent = ShipmentService.FindShipmentContentByPONoModel(testCompany, newPoh.OrderNumber.Value, false);
Assert.IsTrue(checkContent == null, "Error: A non-NULL value was returned when a NULL value was expected");
checkPoh = PurchasingService.FindPurchaseOrderHeaderModel(newPoh.Id, testCompany, false);
Assert.IsTrue(checkPoh == null, "Error: An object was returned when NULL was expected");
}
public void LoadShipmentProduct()
{
var svShipment = new ShipmentService();
var ShipmentProduct = svShipment.SelectData <View_ShipmentProduct>("*", "IsDelete = 0 and CompID =" + LogonCompID);
ViewBag.ShipmentProduct = ShipmentProduct;
}
public void ShipListBind()
{
ShipmentService service = new ShipmentService();
ShipList = service.ShipmentList();
dgvShipment.DataSource = ShipList;
}
public void SOListBind()
{
ShipmentService service = new ShipmentService();
SOList = service.ShipmentSOList();
dgvList.DataSource = SOList;
}
/// <summary>
/// Получение/формирование параметров отчёта, DataSource (список сущностей для таблицы), пути файла и заголовка
/// </summary>
/// <inheritdoc />
public void AdditionalInitializeComponent()
{
_reportFile = Common.GetReportFilePath(ReportFileName); // Путь к файлу отчёта
// Запрос параметров отчёта в отдельном окне
const bool isPeriod = false;
const bool isMounthOrYeath = true;
const bool isWarehouse = false;
const bool isWorkGuild = false;
const bool isDate = true;
const bool isDatePeriod = false;
const bool isMonthYear = false;
const bool isProduct = false;
const bool isCompany = false;
const bool isTypeProduct = false;
const bool isFormaPayment = false;
const bool isAbroad = false;
const string message = "Выберите период выборки и дату";
var parametersWindow = new ReportParametersWindow(isPeriod, isMounthOrYeath, isWarehouse,
isWorkGuild, isDate, isDatePeriod, isMonthYear, isProduct, isCompany, isTypeProduct, isFormaPayment,
isAbroad, message)
{
Owner = Common.GetOwnerWindow()
};
parametersWindow.ShowDialog();
if (!parametersWindow.DialogResult.HasValue || parametersWindow.DialogResult != true)
{
return;
}
// Получение введённых пользователем параметров
var monthOrYear = parametersWindow.SelectedMonthOrYear();
var nullableLoadDateTime = parametersWindow.SelectedDateTime();
if (nullableLoadDateTime == null)
{
const string errorMessage = "Дата не указана";
const MessageBoxButton buttons = MessageBoxButton.OK;
const MessageBoxImage messageType = MessageBoxImage.Error;
MessageBox.Show(errorMessage, PageLiterals.HeaderValidation, buttons, messageType);
return;
}
var loadDateTime = (DateTime)nullableLoadDateTime;
// Формирование одиночных строковых параметров отчёта
_reportParameters = new[] { new ReportParameter("Date", loadDateTime.ToShortDateString()) };
try
{
var resultReportList = ShipmentService.GetShipments(monthOrYear, loadDateTime);
const string dataSourceName = "Shipment";
_reportDataSource = new ReportDataSource(dataSourceName, resultReportList);
ReportViewer.Load += ReportViewer_Load; // Подписка на метод загрузки и отображения отчёта
}
catch (StorageException ex)
{
Common.ShowDetailExceptionMessage(ex);
}
}
public ShipmentController(IConfiguration Configuration, IHostingEnvironment HostingEnvironment, IQuincusAddressTranslationRequest QuincusAddressTranslationRequest)
{
this.configuration = Configuration;
this.hostingEnvironment = HostingEnvironment;
shipmentService = new ShipmentService();
workflowService = new WorkflowService();
_quincusAddressTranslationRequest = QuincusAddressTranslationRequest;
}
public ShipmentController()
{
svBizType = new BizTypeService();
svMember = new MemberService();
svAddress = new AddressService();
svCompany = new CompanyService();
svProduct = new ProductService();
svShipment = new ShipmentService();
}
public ShipmentController()
{
CargoService cargoService = new CargoService();
_cargoService = cargoService;
_shipmentService = new ShipmentService();
_huotService = new HuotService();
_huom2Service = new Huom2Service();
}
