public static void ImportFromExcel(string path)
{
List <ArticleModel> ArticlesFromExcel = ExcelEditor.ArticlesFromExcel(path);
CheckAndCreateReferences(ArticlesFromExcel);
SQLiteConnection con = new SQLiteConnection(InventoryDBSqliteConnection.LoadConnectionString());
string query = "INSERT INTO Articles (ArticleID, Description, ID_Category, Pricing, Quantity, ID_Project, SupplierPartNumber, ManufacturerPartNumber, ID_Manufacturer, ID_Supplier, ID_Status, Created, LastUpdate, ID_Location) VALUES (@ArticleID, @Description, @ID_Category, @Pricing, @Quantity, @ID_Project, @SupplierPartNumber, @ManufacturerPartNumber, @ID_Manufacturer, @ID_Supplier, @ID_Status, @Created, @LastUpdate, @ID_Location)";
SQLiteCommand cmd = new SQLiteCommand(query, con);
con.Open();
foreach (ArticleModel article in ArticlesFromExcel)
{
if (ArticleController.checkSupplierAndManufacturerPartNumber(article.ManufacturerPartNumber, article.SupplierPartNumber).Count == 0)
{
cmd.Parameters.AddWithValue("@ArticleID", article.ArticleID);
cmd.Parameters.AddWithValue("@Description", article.Description);
cmd.Parameters.AddWithValue("@ID_Category", getThreeDigits(article.ArticleID.ToString()));
cmd.Parameters.AddWithValue("@Pricing", article.Pricing);
cmd.Parameters.AddWithValue("@Quantity", article.Quantity);
cmd.Parameters.AddWithValue("@ID_Project", article.ID_Project);
cmd.Parameters.AddWithValue("@SupplierPartNumber", article.SupplierPartNumber);
cmd.Parameters.AddWithValue("@ManufacturerPartNumber", article.ManufacturerPartNumber);
cmd.Parameters.AddWithValue("@ID_Manufacturer", ManufacturerController.getManufacturerID(article.Manufacturer));
cmd.Parameters.AddWithValue("@ID_Supplier", SupplierController.getSupplierID(article.Supplier));
cmd.Parameters.AddWithValue("@ID_Status", StatusController.getStatusID(article.Status));
cmd.Parameters.AddWithValue("@Created", article.Created);
cmd.Parameters.AddWithValue("@LastUpdate", DateTime.Now.ToString("dd/MM/yyyy"));
cmd.Parameters.AddWithValue("@ID_Location", LocationController.getLocationID(article.Location));
cmd.ExecuteNonQuery();
}
}
con.Close();
MessageBox.Show("Import done succesfully, Please restart the Application");
//MessageBox.Show(article.ArticleID + ": " + article.Description + " was added successfully");
}
public async Task Delete_manufacturer_response_bad_request_with_message_when_manufacturer_hooked_with_product()
{
var cancellationToken = new CancellationToken();
var expectedManufacturer =
await _catalogContextFixture.Context.Manufacturers.ToListAsync(cancellationToken);
if (expectedManufacturer.IsNullOrEmpty())
{
expectedManufacturer = await SeedManufacturer(cancellationToken);
}
Assert.NotEmpty(expectedManufacturer);
var id = (await _catalogContextFixture.Context.Manufacturers.FirstOrDefaultAsync(
cancellationToken)).Id;
// Act
var manufacturerController = new ManufacturerController(_catalogContextFixture.Context,
_fileUtilityFixture.FileUtility, _settings);
var response = await manufacturerController.DeleteManufacturerAsync(id, cancellationToken);
var responseMessage = Assert.IsType <BadRequestObjectResult>(response);
Assert.Contains("Message", responseMessage.Value.ToString());
}
public async Task Should_AttachPicture_Returns200()
{
//arrange
var addedPicture = await AddPicture();
var manufacturerBeforeAttachedPicture = await CreateManufacturer();
//act
var attachResponse = await Client.PostAsJsonAsync(ManufacturerController.AttachPicture(manufacturerBeforeAttachedPicture.Id, addedPicture.Id),
new { });
var manufacturerAfterAttachedPicture = await GetManufacturer(manufacturerBeforeAttachedPicture.Id);
//assert
attachResponse.StatusCode.Should().Be(HttpStatusCode.OK);
manufacturerBeforeAttachedPicture.Id.Should().NotBeEmpty();
manufacturerBeforeAttachedPicture.Description.Should().NotBeEmpty();
manufacturerBeforeAttachedPicture.Name.Should().NotBeEmpty();
manufacturerBeforeAttachedPicture.Pictures.Should().HaveCount(0);
manufacturerAfterAttachedPicture.Id.Should().NotBeEmpty();
manufacturerAfterAttachedPicture.Description.Should().NotBeEmpty();
manufacturerAfterAttachedPicture.Name.Should().NotBeEmpty();
manufacturerAfterAttachedPicture.Pictures.Should().HaveCount(1);
var picture = manufacturerAfterAttachedPicture.Pictures.First();
picture.Id.Should().Be(addedPicture.Id);
picture.Description.Should().Be(addedPicture.Description);
picture.Url.Should().Be(addedPicture.Url);
picture.FileName.Should().Be(addedPicture.FileName);
picture.MimeTypeId.Should().Be(addedPicture.MimeTypeId);
picture.PictureAddedAt.Should().BeCloseTo(addedPicture.PictureAddedAt, TimeSpan.FromSeconds(1));
picture.FileStorageUploadId.Should().Be(addedPicture.FileStorageUploadId);
}
static void Main(string[] args)
{
var carController = new CarsController();
var detailController = new DetailsController();
var manufacturerController = new ManufacturerController();
var manufacturerService = new ManufacturerService();
//var allCars = carController.GetAll();
//var carById = carController.GetId(1);
var allDetails = detailController.GetAll();
//var detailById = detailController.GetId(2);
//detailController.Insert(null);
//detailController.Update(null);
//detailController.Delete(1002);
carController.Add(null);
//carController.Update(null);
//carController.Delete(6);
var allManufacturers = manufacturerController.GetAll();
//var richcars = manufacturerController.GetRich();
var mostexpensive = manufacturerService.GetMostExpensive();
Console.ReadKey();
}
Update_manufacturer_response_bad_request_with_message_when_item_image_url_or_image_name_is_not_provided()
{
var cancellationToken = new CancellationToken();
// Arrange
var expectedManufacturer =
await _catalogContextFixture.Context.Manufacturers.ToListAsync(cancellationToken);
if (expectedManufacturer.IsNullOrEmpty())
{
expectedManufacturer = await SeedManufacturer(cancellationToken);
}
Assert.NotEmpty(expectedManufacturer);
// ReSharper disable once PossibleNullReferenceException
var id = expectedManufacturer[0].Id;
expectedManufacturer[0].ImageName = "";
expectedManufacturer[0].ImageUrl = "";
// Act
var manufacturerController = new ManufacturerController(_catalogContextFixture.Context,
_fileUtilityFixture.FileUtility, _settings);
var response =
await manufacturerController.UpdateManufacturerAsync(id, expectedManufacturer[0], cancellationToken);
var responseMessage = Assert.IsType <BadRequestObjectResult>(response);
Assert.Contains("Message", responseMessage.Value.ToString());
}
public async Task Update_manufacturer_response_not_found_with_message_when_item_not_exists()
{
var cancellationToken = new CancellationToken();
// Arrange
var expectedManufacturer =
await _catalogContextFixture.Context.Manufacturers.ToListAsync(cancellationToken);
if (expectedManufacturer.IsNullOrEmpty())
{
expectedManufacturer = await SeedManufacturer(cancellationToken);
}
Assert.NotEmpty(expectedManufacturer);
// ReSharper disable once PossibleNullReferenceException
var id = expectedManufacturer.LastOrDefault().Id++;
// Act
var manufacturerController = new ManufacturerController(_catalogContextFixture.Context,
_fileUtilityFixture.FileUtility, _settings);
var response =
await manufacturerController.UpdateManufacturerAsync(id, expectedManufacturer[0], cancellationToken);
var responseMessage = Assert.IsType <NotFoundObjectResult>(response);
Assert.Contains("Message", responseMessage.Value.ToString());
}
public void CanGetListOfManufacturers_ReturnListOfManufaturers()
{
//Arrange
Mock <IManufacturerRepository> manufacturerMock = new Mock <IManufacturerRepository>();
manufacturerMock.Setup(m => m.Manufacturers).Returns(new Manufacturer[] {
new Manufacturer {
ManufacturerId = 1, Name = "Avon"
},
new Manufacturer {
ManufacturerId = 2, Name = "PJM"
},
new Manufacturer {
ManufacturerId = 1, Name = "Valvex"
}
}.AsQueryable <Manufacturer>());
ManufacturerController manufacturerController = new ManufacturerController(manufacturerMock.Object);
//Act
Manufacturer[] result = GetViewModel <IQueryable <Manufacturer> >(manufacturerController.List()).ToArray();
//Assert
Assert.Equal(3, result.Length);
Assert.Equal("Avon", result[0].Name);
Assert.Equal("PJM", result[1].Name);
Assert.Equal("Valvex", result[2].Name);
}
public ManufacturerControllerTests()
{
_mock.Setup(c => c.Manufacturers).Returns(new List <Manufacturer>()
{
new Manufacturer()
{
Id = 1,
Name = "Adidas",
Country = "England",
},
new Manufacturer()
{
Id = 2,
Name = "Nike",
Country = "China",
},
new Manufacturer()
{
Id = 3,
Name = "Reebok",
Country = "Germany",
},
}.AsQueryable());
_controller = new ManufacturerController(_mock.Object);
}
public void IndexExceptionCase()
{
#region
mockManufacturerRepository = new Mock <IManufacturerRepository>();
// Prepare the return data for GetAllQuotation() method.
var manufacturerList = new List <Manufacture>();
manufacturerList.Add(new Manufacture {
Manufacturer_Id = 1, Manufacturer_Name = "Sony"
});
// Mock up the GetAllQuotation() repository method with expected return values.
mockManufacturerRepository.Setup(m => m.GetAllManufacturer()).Returns(manufacturerList);
manufacturercontroller = new ManufacturerController(mockManufacturerRepository.Object);
#endregion
// Now invoke the Index action.
var actionResult = manufacturercontroller.Index("test", "test") as ViewResult;
// Validate the expected result.
ViewResult expectedResult = new ViewResult();
Assert.IsNotNull("Error", actionResult.ViewName);
}
//Fill the full suggestion list with manufacturer names
private void OnFocus_ManufacturerShowFullSuggestionList(object sender, RoutedEventArgs e)
{
tvrCategory.Visibility = Visibility.Hidden;
listfullSuggestions.Visibility = Visibility.Visible;
listfullSuggestions.DisplayMemberPath = "Name";
listfullSuggestions.SelectedValuePath = "Name";
listfullSuggestions.ItemsSource = ManufacturerController.getManufacturerList();
itsME = "Manufacturer";
}
/// <summary>
/// Loads the manufacturer.
/// </summary>
private void LoadManufacturer()
{
ManufacturerCollection manufacturerCollection = new ManufacturerController().FetchAll();
manufacturerCollection.OrderByAsc(Manufacturer.Columns.Name);
ddlManufacturer.DataSource = manufacturerCollection;
ddlManufacturer.DataTextField = Manufacturer.Columns.Name;
ddlManufacturer.DataValueField = Manufacturer.Columns.ManufacturerId;
ddlManufacturer.DataBind();
}
public void firstTest()
{
var manufacturerRepo = new ManufacturerRepo(db);
var controller = new ManufacturerController(db);
int expected = 3;
var viewResult = Assert.IsType <ViewResult>(controller.Index());
var model = Assert.IsType <List <Manufacturer> >(viewResult.Model);
int actual = model.Count;
Assert.Equal(expected, actual);
}
private async Task <ManufacturerViewModel> GetManufacturer(Guid id)
{
var httpResponse = await Client.GetAsync(ManufacturerController.Get(id));
var manufacturer = await httpResponse
.Content
.ReadAsJsonAsync <ManufacturerViewModel>();
httpResponse.StatusCode.Should().Be(HttpStatusCode.OK);
return(manufacturer);
}
Get_manufacturer_list_response_bad_request_with_message_when_pagination_index_is_negative_or_page_size_zero_or_negative()
{
var cancellationToken = new CancellationToken();
// Act
var manufacturerController = new ManufacturerController(_catalogContextFixture.Context,
_fileUtilityFixture.FileUtility, _settings);
var response = await manufacturerController.GetListManufacturersAsync(cancellationToken, 0, -10);
var responseMessage = Assert.IsType <BadRequestObjectResult>(response);
Assert.Contains("Message", responseMessage.Value.ToString());
}
public async Task Post_manufacturer_response_bad_request_with_message_when_manufacturer_null()
{
var cancellationToken = new CancellationToken();
// Act
var manufacturerController = new ManufacturerController(_catalogContextFixture.Context,
_fileUtilityFixture.FileUtility, _settings);
var response = await manufacturerController.AddNewManufacturerAsync(null, cancellationToken);
var badRequestResponse = Assert.IsType <BadRequestObjectResult>(response);
Assert.Contains("Message", badRequestResponse.Value.ToString());
}
/// <summary>
/// Loads the manufacturers.
/// </summary>
private void LoadManufacturers()
{
ManufacturerCollection manufacturerCollection = new ManufacturerController().FetchAll();
if (manufacturerCollection.Count > 0)
{
dgManufacturers.DataSource = manufacturerCollection;
dgManufacturers.ItemDataBound += new DataGridItemEventHandler(dgManufacturers_ItemDataBound);
dgManufacturers.Columns[0].HeaderText = LocalizationUtility.GetText("hdrDelete");
dgManufacturers.Columns[1].HeaderText = LocalizationUtility.GetText("hdrName");
dgManufacturers.DataBind();
}
}
public async Task Get_manufacturer_image_by_id_response_bad_request_with_message_when_id_less_or_equals_zero()
{
var id = 0;
var cancellationToken = new CancellationToken();
// Act
var manufacturerController = new ManufacturerController(_catalogContextFixture.Context,
_fileUtilityFixture.FileUtility, _settings);
var response = await manufacturerController.GetManufacturerImageAsync(id, cancellationToken);
var responseMessage = Assert.IsType <BadRequestObjectResult>(response);
Assert.Contains("Message", responseMessage.Value.ToString());
}
private async Task <ManufacturerViewModel> CreateManufacturer()
{
var name = Guid.NewGuid().ToString();
var description = Guid.NewGuid().ToString();
var command = new CreateManufacturerCommand(name, description);
const HttpStatusCode expectedStatusCode = HttpStatusCode.Created;
var response = await Client.PostAsJsonAsync(ManufacturerController.Create(), command);
response.StatusCode.Should().Be(expectedStatusCode);
return(await response.Content.ReadAsJsonAsync <ManufacturerViewModel>());
}
public void SetupContext()
{
MockHelpers.MockUserManager <ApplicationUser>();
_mockRepositoryManufacturer = new Mock <IManufacturRepository>();
_manufacturerController = new ManufacturerController(_dbContext, _mockRepositoryManufacturer.Object);
_manufacturers = new List <Manufacturer>
{
new Manufacturer {
ManufacturerId = 1, Name = "DJI", IsActive = true
},
new Manufacturer {
ManufacturerId = 2, Name = "GoPro", IsActive = false
}
};
}
public async Task Should_GetList_Returns200()
{
//arrange
const int pageSize = 25;
const int pageIndex = 0;
//act
var httpResponse = await Client.GetAsync(ManufacturerController.GetList());
var manufacturers = await httpResponse
.Content
.ReadAsJsonAsync <PaginatedItems <CategoryViewModel> >();
//assert
manufacturers.PageSize.Should().Be(pageSize);
manufacturers.PageIndex.Should().Be(pageIndex);
manufacturers.Data.Should().HaveCount(GlobalConstants.ProductServiceManufacturersSeeded);
}
//Fill the autocomple suggestion list and fill it with manufacturer
private void AutoCompleteManufacturer(object sender, KeyEventArgs e)
{
if (txtManufacturer.Text != "" && ManufacturerController.searchManufacturer(txtManufacturer.Text).Count > 0)
{
listSuggestions.ItemsSource = ManufacturerController.searchManufacturer(txtManufacturer.Text);
itsME = "Manufacturer";
Thickness margin = listSuggestions.Margin;
margin.Top = 95;
listSuggestions.Margin = margin;
listSuggestions.Visibility = Visibility.Visible;
if (e.Key == Key.Down)
{
listSuggestions.Focus();
}
}
else
{
listSuggestions.Visibility = Visibility.Hidden;
}
}
public void TestManufacturerDelete()
{
// Arrange
var fakeManufacturer = FakeManufacturers().First();
var mockBusinessLogic = new Mock <ISportStoreBusinessLogic>();
mockBusinessLogic
.Setup(bl => bl.Manufacturer.DeleteById(fakeManufacturer.Id));
var controller = new ManufacturerController(mockBusinessLogic.Object);
// Act
var result = controller.Delete(fakeManufacturer.Id);
// Assert
mockBusinessLogic.VerifyAll();
Assert.IsInstanceOfType(result, typeof(OkResult));
}
public void TestManufacturerGetByIdNotFound()
{
// Arrange
var id = Guid.NewGuid();
var mockBusinessLogic = new Mock <ISportStoreBusinessLogic>();
mockBusinessLogic
.Setup(bl => bl.Manufacturer.GetById(id))
.Returns(null as Manufacturer);
var controller = new ManufacturerController(mockBusinessLogic.Object);
// Act
var result = controller.Get(id);
// Assert
mockBusinessLogic.VerifyAll();
Assert.IsInstanceOfType(result, typeof(NotFoundResult));
}
public async Task Should_GetCount_Returns200()
{
//arrange
var httpResponseList = await Client.GetAsync(ManufacturerController.GetList());
var manufacturers = await httpResponseList
.Content
.ReadAsJsonAsync <PaginatedItems <ManufacturerViewModel> >();
var listCount = manufacturers.Data.Count();
//act
var httpResponseCount = await Client.GetAsync(ManufacturerController.Count());
var manufacturersCount = await httpResponseCount
.Content
.ReadAsJsonAsync <int>();
//assert
manufacturersCount.Should().Be(listCount);
}
static void Main(string[] args)
{
var detailController = new DetailsController();
var carsController = new CarsController();
var manufacturerController = new ManufacturerController();
var det = detailController.GetDetails();
var vehicles = carsController.GetСars();
var carViewModel = new CarViewModel()
{
Id = 6,
Name = "PAZIK",
};
var hz = detailController.GetDetails();
var getmanufacturer = manufacturerController.GetAll();
var getall = manufacturerController.GetCarManufacturerModels();
}
public static void CheckAndCreateReferences(List <ArticleModel> ArticlesFromExcel)
{
foreach (ArticleModel article in ArticlesFromExcel)
{
if (ManufacturerController.getManufacturerID(article.Manufacturer) == 0)
{
ManufacturerModel manufacturer = new ManufacturerModel()
{
Name = article.Manufacturer
};
ManufacturerController.addManufacturer(manufacturer);
}
if (SupplierController.getSupplierID(article.Supplier) == 0)
{
SupplierModel supplier = new SupplierModel()
{
Name = article.Supplier
};
SupplierController.addSupplier(supplier);
}
if (LocationController.getLocationID(article.Location) == 0)
{
LocationModel location = new LocationModel()
{
Location = article.Location
};
LocationController.addLocation(location);
}
if (StatusController.getStatusID(article.Status) == 0)
{
StatusModel status = new StatusModel()
{
Status = article.Status
};
StatusController.addStatus(status);
}
}
}
public void TestManufacturerAll()
{
// Arrange
var expectedManufacturers = FakeManufacturers();
var mockBusinessLogic = new Mock <ISportStoreBusinessLogic>();
mockBusinessLogic
.Setup(bl => bl.Manufacturer.All())
.Returns(expectedManufacturers);
var controller = new ManufacturerController(mockBusinessLogic.Object);
// Act
var obtainedManufacturers = controller.Get();
// Assert
mockBusinessLogic.VerifyAll();
Assert.IsNotNull(obtainedManufacturers);
Assert.AreEqual(expectedManufacturers.Count(), obtainedManufacturers.Count());
}
public async Task Post_manufacturer_response_bad_request_with_message_when_manufacturer_exists()
{
var cancellationToken = new CancellationToken();
//Arrange
var expectedManufacturer =
await _catalogContextFixture.Context.Manufacturers.ToListAsync(cancellationToken);
if (expectedManufacturer.IsNullOrEmpty())
{
expectedManufacturer = await SeedManufacturer(cancellationToken);
}
// Act
var manufacturerController = new ManufacturerController(_catalogContextFixture.Context,
_fileUtilityFixture.FileUtility, _settings);
var response =
await manufacturerController.AddNewManufacturerAsync(expectedManufacturer[0], cancellationToken);
var badRequestResponse = Assert.IsType <BadRequestObjectResult>(response);
Assert.Contains("Message", badRequestResponse.Value.ToString());
}
public void TestManufacturerCreate()
{
// Arrange
var fakeManufacturer = FakeManufacturers().First();
var mockBusinessLogic = new Mock <ISportStoreBusinessLogic>();
mockBusinessLogic
.Setup(bl => bl.Manufacturer.Create(fakeManufacturer))
.Returns(fakeManufacturer.Id);
var controller = new ManufacturerController(mockBusinessLogic.Object);
// Act
var result = controller.Post(fakeManufacturer);
var createdManufacturerCode = (result as OkNegotiatedContentResult <Guid>).Content;
// Assert
mockBusinessLogic.VerifyAll();
Assert.IsNotNull(createdManufacturerCode);
Assert.AreEqual(fakeManufacturer.Id, createdManufacturerCode);
}
public void TestManufacturerGetById()
{
// Arrange
var expectedManufacturer = FakeManufacturers().First();
var mockBusinessLogic = new Mock <ISportStoreBusinessLogic>();
mockBusinessLogic
.Setup(bl => bl.Manufacturer.GetById(expectedManufacturer.Id))
.Returns(expectedManufacturer);
var controller = new ManufacturerController(mockBusinessLogic.Object);
// Act
var result = controller.Get(expectedManufacturer.Id);
var obtainedManufacturer = (result as OkNegotiatedContentResult <Manufacturer>).Content;
// Assert
mockBusinessLogic.VerifyAll();
Assert.IsNotNull(obtainedManufacturer);
Assert.AreEqual(expectedManufacturer.Id, obtainedManufacturer.Id);
}
