public IActionResult AddorEditSubCategoryByAdmin([FromBody] Products_SubCategory model)
{
IARresponse = Unauthorized();
Products_SubCategory product_subcategory = new Products_SubCategory();
try
{
product_subcategory.prod_subcat_id = model.prod_subcat_id;
product_subcategory.pscName = model.pscName;
product_subcategory.prod_cat_id = model.prod_cat_id;
product_subcategory.IsActive = 1;
if (objadmindb.AddorEditSubCategoryByAdmin(product_subcategory) == "")
{
IARresponse = Ok(new { res = "Products Added / Updated Successfully" });
}
else
{
IARresponse = BadRequest(new { res = "Products not Added / Updated... try again later!.." + objadmindb.AddorEditSubCategoryByAdmin(product_subcategory) });
}
}
catch (Exception ex)
{
IARresponse = BadRequest(new { res = ex.Message });
}
return(IARresponse);
}
public string AddorEditSubCategoryByAdmin(Products_SubCategory product_subcategory)
{
CmdCAP = new SqlCommand();
CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@prod_subcat_id", SqlDbType.Int, 0, product_subcategory.prod_subcat_id));
CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@pscName", SqlDbType.VarChar, 100, string.IsNullOrEmpty(product_subcategory.pscName) ? SqlString.Null : product_subcategory.pscName));
CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@prod_cat_id", SqlDbType.Int, 0, product_subcategory.prod_cat_id));
CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@IsActive", SqlDbType.Bit, 0, product_subcategory.IsActive));
ErrorMessage = CommonDbFunctions.SqlCommandExecution(CommandType.StoredProcedure, "spAddorEditSubCategoryByAdmin", CmdCAP);
return(ErrorMessage);
}
