// POST: odata/ProductModelProductDescriptions public async Task <IHttpActionResult> Post(ProductModelProductDescription productModelProductDescription) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.ProductModelProductDescriptions.Add(productModelProductDescription); try { await db.SaveChangesAsync(); } catch (DbUpdateException) { if (ProductModelProductDescriptionExists(productModelProductDescription.ProductModelID)) { return(Conflict()); } else { throw; } } return(Created(productModelProductDescription)); }
public ActionResult ProductDetails(int id) { ProductModelProductDescription prodModProdDes = new ProductModelProductDescription(); prodModProdDes = _prodModProdDesService.Get("ProductModelProductDescription", "GetProductModelProductDescriptionByProductModelID", id); return(View(prodModProdDes)); }
public async Task <IActionResult> PostProductModelProductDescription([FromBody] ProductModelProductDescription productModelProductDescription) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } _context.ProductModelProductDescription.Add(productModelProductDescription); try { await _context.SaveChangesAsync(); } catch (DbUpdateException) { if (ProductModelProductDescriptionExists(productModelProductDescription.ProductModelId)) { return(new StatusCodeResult(StatusCodes.Status409Conflict)); } else { throw; } } return(CreatedAtAction("GetProductModelProductDescription", new { id = productModelProductDescription.ProductModelId }, productModelProductDescription)); }
// POST: odata/ProductModelProductDescriptions public async Task <IHttpActionResult> Post(ProductModelProductDescription entity) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } await collection.InsertOneAsync(entity); return(Created(entity)); }
// DELETE: odata/ProductModelProductDescriptions(5) public async Task <IHttpActionResult> Delete([FromODataUri] int key) { ProductModelProductDescription productModelProductDescription = await db.ProductModelProductDescriptions.FindAsync(key); if (productModelProductDescription == null) { return(NotFound()); } db.ProductModelProductDescriptions.Remove(productModelProductDescription); await db.SaveChangesAsync(); return(StatusCode(HttpStatusCode.NoContent)); }
// DELETE: odata/ProductModelProductDescriptions(5) public async Task <IHttpActionResult> Delete([FromODataUri] int key) { var filter = Builders <ProductModelProductDescription> .Filter.Eq(a => a.ProductModelID, key); ProductModelProductDescription entity = collection.Find(filter).FirstOrDefault(); if (entity == null) { return(NotFound()); } var result = await collection.DeleteOneAsync(filter); return(StatusCode(HttpStatusCode.NoContent)); }
// PUT: odata/ProductModelProductDescriptions(5) public async Task <IHttpActionResult> Put([FromODataUri] int key, Delta <ProductModelProductDescription> patch) { Validate(patch.GetEntity()); if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var filter = Builders <ProductModelProductDescription> .Filter.Eq(a => a.ProductModelID, key); ProductModelProductDescription entity = collection.Find(filter).FirstOrDefault(); ObjectId objectId; if (entity == null) { return(NotFound()); } else { objectId = entity._id; } patch.Put(entity); entity._id = objectId; try { filter = Builders <ProductModelProductDescription> .Filter.Eq(a => a._id, entity._id); await collection.ReplaceOneAsync(filter, entity); } catch (DbUpdateConcurrencyException) { if (!EntityExists(key)) { return(NotFound()); } else { throw; } } return(Updated(entity)); }
public List <ProductModelProductDescription> GetProductModelProductDescription() { //variables List <ProductModelProductDescription> prodModelProductDescriptionList = new List <ProductModelProductDescription>(); //DB Command SqlCommand cmd = GetDbCommand(); cmd.CommandText = @" SELECT * FROM SalesLT.ProductModelProductDescription "; //DataReader try { //open Database Connection cmd.Connection.Open(); SqlDataReader reader = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection); //loop through rows - create while (reader.Read()) { //temporary ProductCategory ProductModelProductDescription prodMPD = new ProductModelProductDescription(); //data values for ProductCategory prodMPD.ProductModelID = (int)reader["ProductModelID"]; prodMPD.ProductDescriptionID = (int)reader["ProductDescriptionID"]; prodMPD.Culture = (string)reader["Culture"]; prodMPD.rowguid = (Guid)reader["rowguid"]; prodMPD.ModifiedDate = (DateTime)reader["ModifiedDate"]; //add customer to list for viewing prodModelProductDescriptionList.Add(prodMPD); } //close the data connection reader.Close(); } catch (Exception ex) { throw ex; } //return ProductCategory List return(prodModelProductDescriptionList); }
// PUT: odata/ProductModelProductDescriptions(5) public async Task <IHttpActionResult> Put([FromODataUri] int key, Delta <ProductModelProductDescription> patch) { Validate(patch.GetEntity()); if (!ModelState.IsValid) { return(BadRequest(ModelState)); } ProductModelProductDescription productModelProductDescription = await db.ProductModelProductDescriptions.FindAsync(key); if (productModelProductDescription == null) { return(NotFound()); } patch.Put(productModelProductDescription); try { await db.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ProductModelProductDescriptionExists(key)) { return(NotFound()); } else { throw; } } return(Updated(productModelProductDescription)); }
public async Task <IActionResult> PutProductModelProductDescription([FromRoute] int id, [FromBody] ProductModelProductDescription productModelProductDescription) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != productModelProductDescription.ProductModelId) { return(BadRequest()); } _context.Entry(productModelProductDescription).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ProductModelProductDescriptionExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public void AddToProductModelProductDescriptions(ProductModelProductDescription productModelProductDescription) { base.AddObject("ProductModelProductDescriptions", productModelProductDescription); }
public static ProductModelProductDescription CreateProductModelProductDescription(int productModelID, int productDescriptionID, string culture, global::System.Guid rowguid, global::System.DateTime modifiedDate) { ProductModelProductDescription productModelProductDescription = new ProductModelProductDescription(); productModelProductDescription.ProductModelID = productModelID; productModelProductDescription.ProductDescriptionID = productDescriptionID; productModelProductDescription.Culture = culture; productModelProductDescription.rowguid = rowguid; productModelProductDescription.ModifiedDate = modifiedDate; return productModelProductDescription; }
partial void DeleteProductModelProductDescription(ProductModelProductDescription instance);
public void SaveToProductModelProductDescription(ProductModelProductDescription productModelProductDescription) { _context.Entry(ProductModelProductDescriptions).State = EntityState.Unchanged; _context.SaveChanges(); }
private void attach_ProductModelProductDescription(ProductModelProductDescription entity) { this.SendPropertyChanging(); entity.ProductModel = this; }
private void detach_ProductModelProductDescriptions(ProductModelProductDescription entity) { this.SendPropertyChanging(); entity.ProductModel = null; }
partial void UpdateProductModelProductDescription(ProductModelProductDescription instance);
partial void InsertProductModelProductDescription(ProductModelProductDescription instance);
//Если продукт новый, то нужно добавить ему описание и все это дело связать с моделью public ActionResult CreateProductDescription(int productId, int productModelId) { var product = _repository.Products.FirstOrDefault(x => x.ProductID == productId); var productModel = _productModelRepository.ProductModels.FirstOrDefault(x => x.ProductModelID == productModelId); //модель var productDescription = new ProductDescription { Description = String.Empty, ModifiedDate = DateTime.Now, rowguid = Guid.NewGuid() }; // создадим новое описание _productDescription.SaveToProductDescription(productDescription); //сохраним его var productModelProductDescription = new ProductModelProductDescription { Culture = "en ", ModifiedDate = DateTime.Now, ProductDescriptionID = productDescription.ProductDescriptionID, ProductModelID = productModel.ProductModelID, rowguid = Guid.NewGuid() }; productModel.ProductModelProductDescription.Add(productModelProductDescription); _productModelRepository.SaveToProductModel(productModel); return RedirectToAction("Index"); }