// 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");
}
