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