public int DeleteCustomer(CustomerDeleteServiceInputModel data)
{
using (var con = new SqlConnection(configuration.GetValue <string>("ConnectionString:SQLConnection")))
{
try
{
var dbParams = new DynamicParameters();
con.Open();
dbParams.Add("@Id", data.Id);
var reader = con.ExecuteReader(
sql: "[dbo].[CustomerDeleteProcedure]",
param: dbParams,
commandType: CommandType.StoredProcedure);
return(1);
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
}
}
}
public int DeleteCustomerService(CustomerDeleteServiceInputModel data)
{
return(_customerRepository.DeleteCustomer(data));
}
public IActionResult Delete(CustomerDeleteServiceInputModel data)
{
return(Ok(_customerService.DeleteCustomerService(data)));
}
