/// <summary>
/// Get Product Attribute Details by ProductAttributeID
/// </summary>
/// <param name="ProductAttributeID"></param>
/// <returns></returns>
public IEnumerable <ProductSizeAndPriceViewModel> ProductAttributeDetails(int ProductAttributeID)
{
IList <ProductSizeAndPriceViewModel> _productSizeAndPrices = new List <ProductSizeAndPriceViewModel>();
using (var command = Context.Database.GetDbConnection().CreateCommand())
{
command.CommandText = "sp_getProductAttributeDetails";
command.CommandType = System.Data.CommandType.StoredProcedure;
var parameter = new SqlParameter("ProductAttributeID", ProductAttributeID);
command.Parameters.Add(parameter);
this.Context.Database.OpenConnection();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
ProductSizeAndPriceViewModel _productSizeAndPrice = new ProductSizeAndPriceViewModel
{
Description = Common.SafeGetString(reader, "Description"),
ProductThicknessName = Common.SafeGetString(reader, "ProductThicknessName"),
Column80 = Common.SafeGetString(reader, "80"),
Column84 = Common.SafeGetString(reader, "84"),
Column90 = Common.SafeGetString(reader, "90"),
Column96 = Common.SafeGetString(reader, "96"),
Column108 = Common.SafeGetString(reader, "108"),
};
_productSizeAndPrices.Add(_productSizeAndPrice);
}
}
this.Context.Database.CloseConnection();
}
return(_productSizeAndPrices);
}
public async Task <IActionResult> SaveProductSizeAndPrice(ProductSizeAndPriceViewModel model)
{
try
{
var response = false;
// Call Post Method to Create New Product Size and Price
if (model.FormAction.ToLower() == "create")
{
model = await generateAPIResponse.ProductSizeAndPriceViewRepo.SaveModel("ProductSizeAndPrice", model);
if (model.ProductSizeAndPriceID != 0)
{
response = true;
}
}
// Call Put Method to Update Existing Product Attribute Details
else
{
response = await generateAPIResponse.ProductSizeAndPriceViewRepo.Update("ProductSizeAndPrice/" + model.ProductSizeAndPriceID, model);
}
if (response)
{
return(Ok(model.ProductSizeAndPriceID));
}
else
{
ViewBag.Message = null;
}
}
catch (Exception ex)
{
ViewBag.Message = "Something went wrong: " + ex.Message;
}
return(StatusCode(500));
}
