/// <summary>
/// Get Product Thickness Details with ProductAttributeThicknessID
/// </summary>
/// <param name="ProductAttributeID"></param>
/// <returns></returns>
public IEnumerable <ProductThicknessViewModel> GetWithAttributeThicknessID(int?ProductAttributeID)
{
IList <ProductThicknessViewModel> _productThicknesses = new List <ProductThicknessViewModel>();
using (var command = Context.Database.GetDbConnection().CreateCommand())
{
command.CommandText = "sp_getWithAttributeThicknessID";
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())
{
ProductThicknessViewModel _productThickness = new ProductThicknessViewModel
{
ProductThicknessID = Common.SafeGetInt(reader, "ProductThicknessID"),
ProductThicknessName = Common.SafeGetString(reader, "ProductThicknessName"),
ProductCodeInitials = Common.SafeGetString(reader, "ProductCodeInitials"),
ProductAttributeThicknessID = Common.SafeGetInt(reader, "ProductAttributeThicknessID"),
Active = Common.SafeGetBoolean(reader, "Active"),
};
_productThicknesses.Add(_productThickness);
}
}
this.Context.Database.CloseConnection();
}
return(_productThicknesses);
}
/// <summary>
/// Edit Product Thickness
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public async Task <IActionResult> Edit(int id)
{
ProductThicknessViewModel model = await generateAPIResponse.ProductThicknessViewRepo.GetByID("productThickness", id);
if (model != null)
{
return(View("Create", model));
}
else
{
return(RedirectToAction("Index"));
}
}
/// <summary>
/// Save & Update Product Thickness Details with Post & Put Methods of the Web APIs.
/// </summary>
/// <param name="model"></param>
/// <param name="action"></param>
/// <returns></returns>
private async Task <IActionResult> SaveProductThicknessDetails(ProductThicknessViewModel model, String action)
{
try
{
var response = false;
// Call Post Method to Create New Product Thickness Details
if (action.ToLower() == "create")
{
response = await generateAPIResponse.ProductThicknessViewRepo.Save("productThickness", model);
ViewBag.Message = "Product Thickness record has been created successfully.";
}
// Call Put Method to Update Existing Product Thickness Details
else
{
response = await generateAPIResponse.ProductThicknessViewRepo.Update("productThickness/" + model.ProductThicknessID, model);
ViewBag.Message = "Product Thickness record has been updated successfully.";
}
if (response)
{
ViewBag.Class = "text-success";
return(await RedirectToIndex());
}
else
{
ViewBag.Message = null;
return(View("Create", model));
}
}
catch (Exception ex)
{
ViewBag.Message = "Something went wrong: " + ex.Message;
}
return(View("Create", model));
}
public async Task <IActionResult> Create(ProductThicknessViewModel model)
{
return(await SaveProductThicknessDetails(model, "Create"));
}
