public ActionResult Add()
{
var model = new MyProduct();
Reload(model);
return(View(model));
}
public ActionResult GetUpdate(int id)
{
var data = c.Product.Find(id);
var product = new MyProduct();
product.ProductId = data.ProductId;
product.CategoryId = data.CategoryId;
product.BrandId = data.BrandId;
product.ProductName = data.ProductName;
product.BarcodeNo = data.BarcodeNo;
product.PurchasePrice = data.PurchasePrice;
product.SellingPrice = data.SellingPrice;
product.Quantity = data.Quantity;
product.Vat = data.Vat;
product.UnitId = data.UnitId;
product.Date = data.Date;
product.Description = data.Description;
Reload(product);
List <Brand> brandList =
c.Brand.Where(x => x.CategoryId == data.CategoryId).
OrderBy(x => x.Brand1).ToList();
product.BrandList = (from x in brandList
select new SelectListItem
{
Text = x.Brand1,
Value = x.BrandId.ToString()
}).ToList();
return(View(product));
}
public async Task <IActionResult> PutMyProduct([FromRoute] int id, [FromBody] MyProduct myProduct)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != myProduct.Id)
{
return(BadRequest());
}
_context.Entry(myProduct).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!MyProductExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
private void frmMain_Load(object sender, EventArgs e)
{
#region Login User
var loginFrm = new frmLogin();
if (loginFrm.ShowDialog() != DialogResult.OK)
{
btnExit_Click(sender, e);
return;
}
userLogin = loginFrm.Tag as UserLogin;
if (userLogin == null)
{
btnExit_Click(sender, e);
return;
}
#endregion
Helper.CreatePath();
myProducts = ManageData.myProducts(userLogin);
fillMyProducts();
fillUserInfo();
}
public async Task QueryableSql_Should_Allow_Composition()
{
// Arrange
var comparer = new MyProductComparer();
var expected1 = new MyProduct {
Id = 1, Name = "Chai", Price = 18m, Category = "Beverages"
};
var expected2 = new MyProduct {
Id = 2, Name = "Chang", Price = 19m, Category = "Beverages"
};
var expected3 = new MyProduct {
Id = 35, Name = "Steeleye Stout", Price = 18m, Category = "Beverages"
};
var repository = new Repository <Product>(_fixture.Context);
// Act
var query = repository.QueryableSql("SELECT * FROM Products");
var products = await query
.Include(p => p.Category)
.Where(p => (new int[] { 1, 2, 35 }).Contains(p.ProductId))
.Select(p => new MyProduct
{
Id = p.ProductId,
Name = p.ProductName,
Price = p.UnitPrice,
Category = p.Category.CategoryName
})
.ToListAsync();
// Assert
Assert.Collection(products.Take(3),
p => Assert.Equal(expected1, p, comparer),
p => Assert.Equal(expected2, p, comparer),
p => Assert.Equal(expected3, p, comparer));
}
public static void Main()
{
var p = new MyProduct();
p.Name = "test";
Console.WriteLine(p.GetName());
}
public async Task Queryable_Should_Allow_Composition()
{
// Arrange
var comparer = new MyProductComparer();
var expected1 = new MyProduct {
Id = 1, Name = "Chai", Price = 18.00m, Category = "Beverages"
};
var expected2 = new MyProduct {
Id = 2, Name = "Chang", Price = 19.00m, Category = "Beverages"
};
var repository = new Repository <Product>(_fixture.Context);
// Act
var query = repository.Queryable();
var products = await query
.Take(2)
.Include(p => p.Category)
.Where(p => p.UnitPrice.CompareTo(15.00m) > 0)
.Select(p => new MyProduct
{
Id = p.ProductId,
Name = p.ProductName,
Price = p.UnitPrice,
Category = p.Category.CategoryName
})
.ToListAsync();
// Assert
Assert.Collection(products,
p => Assert.Equal(expected1, p, comparer),
p => Assert.Equal(expected2, p, comparer));
}
public WoksViewModel()
{
main = new ObservableCollectionFast <AppItem>();
sauce = new ObservableCollectionFast <AppItem>();
meat = new ObservableCollectionFast <AppItem>();
toppings = new ObservableCollectionFast <AppItem>();
wok = new MyProduct();
tabs = new string[2] {
"СОБРАТЬ ВОК", "МОИ ВОКИ"
};
CreateWok = new Command((product) =>
{
DataBase.WriteItem <MyProduct>("Woks", (MyProduct)product as MyProduct);
});
LoadSubcatsCommand = new Command(async() =>
{
fullPrice = 0;
mainPrice = 0;
saucePrice = 0;
meatPrice = 0;
toppingPrice = 0;
var main = await DataBase.GetByQueryEnumerableAsync <AppItem>("Items", Query.Where("category", x => x.AsArray.Contains(mainCateg)));
this.main.Clear();
this.main.AddRange(main);
var sauce = await DataBase.GetByQueryEnumerableAsync <AppItem>("Items", Query.Where("category", y => y.AsArray.Contains(229)));
this.sauce.Clear();
this.sauce.AddRange(sauce);
var meat = await DataBase.GetByQueryEnumerableAsync <AppItem>("Items", Query.Where("category", z => z.AsArray.Contains(meatCateg)));
this.meat.Clear();
this.meat.AddRange(meat);
var toppings = await DataBase.GetByQueryEnumerableAsync <AppItem>("Items", Query.Where("category", w => w.AsArray.Contains(toppingsCateg)));
this.toppings.AddRange(toppings);
});
}
public async Task <IActionResult> Edit(int id, [Bind("Id,Name,Quantity,Price,CreatedDate")] MyProduct myProduct)
{
if (id != myProduct.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(myProduct);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!MyProductExists(myProduct.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(myProduct));
}
static void InsertInLiteDB(MyProduct p) //в nosql проверяем наличие товара и печатаем инфу, если есть
{
using (var db = new LiteDatabase(@"D:\MyData.db"))
{
var col = db.GetCollection <MyProduct>("product");
col.Insert(p); //liteDB
}
}
// Use this for initialization
void Start()
{
productList = new MyProduct();
gameObject.AddComponent <httpRequest>();
myApi = gameObject.GetComponent <httpRequest>();
myApi.GET("http://ec2-52-15-84-235.us-east-2.compute.amazonaws.com/myFYP/public/api/getAllProduct");
StartCoroutine(Requesting());
}
private IEnumerator Requesting()
{
yield return(myApi.httpResponse);
//Debug.Log(myApi.getResult());
productList = MyProduct.CreateFromJSON(myApi.getResult());
Debug.Log(productList.product[0].cost);
}
public void ShowOrderDetails() //显示订单细节
{
Console.WriteLine();
MyProduct.ShowProduct();
Console.WriteLine("{0,-15}", "x" + ProductNum);
Console.WriteLine();
Console.WriteLine("商品总价：" + GetProductPriceSum());
}
public void GetTest()
{
ProductService ps = new ProductService();
MyProduct p = ps.Read(1);
Assert.AreEqual(p.Name, "Adjustable Race");
Assert.AreEqual(p.ProductNumber, "AR-5381");
}
public void ProductRepository_GetAsync_ReturnsRequestedProduct(string productName)
{
var optionsMock = new Mock <IOptions <ServiceDependenciesConfig> >();
IMyProductRepository productRepository = new MyProductRepository(null, optionsMock.Object);
MyProduct product = productRepository.GetAsync(productName).Result;
Assert.Equal(product.MyProductId, productName);
}
public void _Create_Should_Reserve_A_Card_Number() {
//Arrange
var toCreate = new MyProduct();
nativeRepositoryMock.Setup(r => r.ReserveCardNumber()).Verifiable();
//Act
sut.Create(toCreate);
//Asert
nativeRepositoryMock.Verify(r => r.ReserveCardNumber());
}
public MainViewModel(DataService dataService)
{
this.dataService = dataService;
myProducts = this.dataService.products;
myProduct = myProducts[0];
AddProduct = new Command(() => { Task.Run(_AddProduct); });
UpdateProduct = new Command(() => { Task.Run(_UpdateProduct); });
RemoveProduct = new Command(() => { Task.Run(_RemoveProduct); });
}
public MainViewModel()
{
dataService = new DataService();
myProducts = dataService.products;
myProduct = myProducts[0];
AddProduct = new Command(() => { Task.Run(_AddProduct); });
UpdateProduct = new Command(() => { Task.Run(_UpdateProduct); });
RemoveProduct = new Command(() => { Task.Run(_RemoveProduct); });
}
public async Task <IActionResult> Create([Bind("Id,Name,Quantity,Price,CreatedDate")] MyProduct myProduct)
{
if (ModelState.IsValid)
{
myProduct.CreatedDate = DateTime.Now;
_context.Add(myProduct);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(myProduct));
}
public ActionResult Add(Product product)
{
if (!ModelState.IsValid)
{
var model = new MyProduct();
Reload(model);
return(View(model));
}
c.Product.Add(product);
c.SaveChanges();
return(RedirectToAction("Index"));
}
public async Task <IActionResult> PostMyProduct([FromBody] MyProduct myProduct)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_context.MyProducts.Add(myProduct);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetMyProduct", new { id = myProduct.Id }, myProduct));
}
/// <summary>
/// 修改我的产品
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Edit(MyProduct model)
{
if (string.IsNullOrEmpty(model.ID))
{
LogService.WriteInfoLog(logTitle, "试图修改为空的MyProduct实体!");
throw new KeyNotFoundException();
}
using (DbContext db = new CRDatabase())
{
db.Entry(ModelToEntity(model)).State = EntityState.Modified;
return(db.SaveChanges() > 0);
}
}
/// <summary>
/// 新增我的产品
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public string Add(MyProduct model)
{
if (model == null)
{
return(string.Empty);
}
using (DbContext db = new CRDatabase())
{
db.Set <CTMS_MYPRODUCT>().Add(ModelToEntity(model));
db.SaveChanges();
return(model.ID);
}
}
public string removeProduct(String name)
{
try
{
MyProduct foundProduct = dataContext.Find(p => p.Name.Equals(name));
dataContext.Remove(foundProduct);
}
catch (Exception e)
{
return("Product doesn't exists");
}
return("Product removed");
}
public async Task <IActionResult> Post([FromBody] MyProduct value)
{
// Sample simple sanity check
// In reality, validation should be in the model layer and not controller
if (!string.IsNullOrEmpty(value.MyProductId))
{
return(BadRequest("MyProductId should not be provided for a POST!"));
}
var createdValue = await MyProductRepository.CreateAsync(value);
// Construct the response
return(Created(Url.Action("GetById", new { myProductId = createdValue.MyProductId }), createdValue));
}
public string addProduct(string name, string productNumber, string color, short safetyStockLevel, decimal standardCost, string size, decimal?weight)
{
MyProduct p = new MyProduct(random.Next(10000), name, productNumber, color, safetyStockLevel, standardCost, size, weight);
try
{
dataContext.Add(p);
}
catch (Exception e)
{
return("Product already exists in database");
}
return("Product sucessfuly added");
}
public async Task <IActionResult> Put([FromBody] MyProduct value)
{
// Sample validation on the model
// In reality, validation should be in the model layer and not controller
if (string.IsNullOrEmpty(value.MyProductId))
{
return(BadRequest("MyProductId is required!"));
}
// First try get the resource to update
var toUpdate = AllMyProducts.FirstOrDefault(p => p.MyProductId == value.MyProductId);
if (toUpdate == null)
{
return(NotFound());
}
// Generate a etag for the entity to update
var originalETag = new ETagBuilder()
.WithToken(toUpdate.MyProductId)
.WithToken(toUpdate.Name)
.WithToken(toUpdate.Description)
.Build();
// Check for conditions from request headers
var action = RequestPreconditionCheck()
.WithETag(originalETag)
.WithLastModified(toUpdate.Modified)
.GetRecommendedAction();
if (action != null)
{
return(action);
}
// Now update the resource (fake it here by removing and adding)
AllMyProducts.Remove(toUpdate);
AllMyProducts.Add(value);
// Generate a etag for the new entity
var eTag = new ETagBuilder()
.WithToken(value.MyProductId)
.WithToken(value.Name)
.WithToken(value.Description)
.Build();
// Construct the response as 200 OK (or 204 No Content), with right headers attached
return(Json(value).WithETag(eTag).WithLastModified(value.Modified));
}
static void Main(string[] args)
{
Console.WriteLine("Exemplo de Factory Method");
var app = new MyApplication();
// var doc = app.CreateDocument();
var doc = app.NewDocument();
Console.WriteLine(doc.ToString());
var app2 = new MyProduct();
Console.ReadKey();
}
public async Task <MyProduct> CreateAsync(MyProduct objectToCreate)
{
if (!string.IsNullOrEmpty(objectToCreate.MyProductId))
{
throw new ArgumentException($"The given '{nameof(objectToCreate)}' already has an ID!");
}
// "Create" the new Entity
// Generate a GUID to serve as the object ID
objectToCreate.MyProductId = Guid.NewGuid().ToString();
objectToCreate.Created = objectToCreate.Modified = DateTime.UtcNow;
AllMyProducts.Add(objectToCreate);
return(await Task.FromResult(objectToCreate));
}
public InitData()
{
myProducts = new List <MyProduct>();
MyProduct p1 = new MyProduct(random.Next(10000), "Bike Fast", "XX-2115", "Red", 21, 210.2m, "standard", 8.2m);
MyProduct p2 = new MyProduct(random.Next(10000), "Pedal", "AS-2138", "Gray", 5, 30.5m, "small", 2.4m);
MyProduct p3 = new MyProduct(random.Next(10000), "Monocycle", "XR-1468", "Purple", 13, 94.2m, "standard", 6.3m);
MyProduct p4 = new MyProduct(random.Next(10000), "Wheel", "AC-3333", "Black", 30, 30.2m, "standard", 1.2m);
MyProduct p5 = new MyProduct(2137, "Motorbike Fast", "XY-2137", "Blue", 11, 1210.2m, "enormous", 48.3m);
myProducts.Add(p1);
myProducts.Add(p2);
myProducts.Add(p3);
myProducts.Add(p4);
myProducts.Add(p5);
}
public static IList<MyProduct> SearchMyProduct(SearchCriteria crit, int pageIndex, int pageSize)
{
var ret = new List<MyProduct>();
var mp = new MyProduct
{
Id = 1,
ProductId = 4,
NotesCount = 1,
ProductName = "$100 Physical Gift Card",
CustomerId = 1
};
mp.Items.Add(new MyProductNote { Id = 1, FirstName = "John", MiddleName = "A.", LastName = "Doe", Note = "This is a note" });
ret.Add(mp);
return ret;
}
