public List <ProductAttributeLookupResponse.InsertData> InsertProductAttributeLookup(ProductAttributeLookupTable objProductAttributeLookupTable)
{
List <ProductAttributeLookupResponse.InsertData> getProductCategoryList = new List <ProductAttributeLookupResponse.InsertData>();
try
{
var values = new { ProdCatId = objProductAttributeLookupTable.ProdCatId, AttributeName = objProductAttributeLookupTable.AttributeName, Action = "1" };
using (IDbConnection con = new SqlConnection(ConString.GetConnectionString))
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
getProductCategoryList = con.Query <ProductAttributeLookupResponse.InsertData>("[dbo].[InsertOrUpdateOrDeleteProductAttributeLookup]", values, commandType: CommandType.StoredProcedure).ToList();
}
return(getProductCategoryList);
}
catch (Exception)
{
return(getProductCategoryList);
}
}
public ActionResult Put(ProductAttributeLookupUpdateParam 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
}));
}
ProductAttributeLookupTable objProduct = new ProductAttributeLookupTable();
objProduct.AttributeId = objProductUpdateParam.AttributeId;
objProduct.ProdCatId = objProductUpdateParam.ProdCatId;
objProduct.AttributeName = objProductUpdateParam.AttributeName;
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
}));
}
ProductAttributeLookupDBAccess obj = ProductAttributeLookupDBAccess.getInstance;
List <ProductAttributeLookupResponse.UpdateData> objListData = obj.UpdateProductAttributeLookup(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 ProductAttributeLookupResponse.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
}));
}
}