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