public List <ProductAttributeResponse.InsertData> InsertProductAttribute(ProductAttributeTable objProductAttributeTable)
{
List <ProductAttributeResponse.InsertData> getProductCategoryList = new List <ProductAttributeResponse.InsertData>();
try
{
var values = new { AttributeId = objProductAttributeTable.AttributeId, ProductId = objProductAttributeTable.ProductId, AttributeValue = objProductAttributeTable.AttributeValue, Action = "1" };
using (IDbConnection con = new SqlConnection(ConString.GetConnectionString))
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
getProductCategoryList = con.Query <ProductAttributeResponse.InsertData>("[dbo].[InsertOrUpdateOrDeleteProductAttribute]", values, commandType: CommandType.StoredProcedure).ToList();
}
return(getProductCategoryList);
}
catch (Exception)
{
return(getProductCategoryList);
}
}
public ActionResult Put(ProductAttributeUpdateParam objProductUpdateParam)
{
try
{
if (objAutorized.ValidateTokenResult == null)
{
return(Ok(new CommonResponse()
{
error_code = Convert.ToInt32(ErrorCode.Failure), message = "Invalid access."
}));
}
if (objAutorized.ValidateTokenResult.isValid == false)
{
return(Ok(new CommonResponse()
{
error_code = Convert.ToInt32(ErrorCode.Failure), message = objAutorized.ValidateTokenResult.error_message
}));
}
ProductAttributeTable objProduct = new ProductAttributeTable();
objProduct.AttributeId = objProductUpdateParam.AttributeId;
objProduct.ProductId = objProductUpdateParam.ProductId;
objProduct.AttributeValue = objProductUpdateParam.AttributeValue;
ValidationContext vc = new ValidationContext(objProduct);
var validationsResults = new List <ValidationResult>();
bool correct = Validator.TryValidateObject(objProduct, vc, validationsResults, true);
if (!correct)
{
string errorMessage = "";
foreach (var item in validationsResults.Select(ov => ov.ErrorMessage))
{
errorMessage = string.Concat(errorMessage, item);
}
return(Ok(new CommonResponse()
{
error_code = Convert.ToInt32(ErrorCode.Failure), message = errorMessage
}));
}
ProductAttributeDBAccess obj = ProductAttributeDBAccess.getInstance;
List <ProductAttributeResponse.UpdateData> objListData = obj.UpdateProductAttribute(objProduct);
if (objListData.Count == 0)
{
return(Ok(new CommonResponse()
{
error_code = Convert.ToInt32(ErrorCode.Failure), message = "No data update."
}));
}
if (objListData[0].RowEffect == 0)
{
return(Ok(new CommonResponse()
{
error_code = Convert.ToInt32(ErrorCode.Failure), message = objListData[0].message
}));
}
return(Ok(new ProductAttributeResponse.UpdateData()
{
error_code = Convert.ToInt32(ErrorCode.Success),
message = objListData[0].message,
RowEffect = objListData[0].RowEffect
}));
}
catch (Exception ex)
{
return(Ok(new CommonResponse()
{
error_code = Convert.ToInt32(ErrorCode.Failure), message = ex.Message
}));
}
}
