// Sales List in dropdown
public async Task <List <SalesList_DropdownModel> > SalesList_dropdown(SalesList_DropdownModel model)
{
using (salesRepository = new SalesRepository())
{
return(await salesRepository.SalesList_dropdown(model));
}
}
// Sales list in dropdown
public async Task <List <SalesList_DropdownModel> > SalesList_dropdown(SalesList_DropdownModel model)
{
using (var connection = new SqlConnection(ConnectionString))
{
connection.Open();
TranStatus transaction = new TranStatus();
DynamicParameters parameter = new DynamicParameters();
parameter.Add("@AdminID", model.UserId);
var result = await connection.QueryAsync <SalesList_DropdownModel>("SalesList_dropdown", parameter, commandType : CommandType.StoredProcedure);
return(result.ToList());
}
}
public async Task <IActionResult> SalesList_dropdown([FromBody] SalesList_DropdownModel model)
{
TranStatus transaction = new TranStatus();
Dictionary <String, Object> dctData = new Dictionary <string, object>();
HttpStatusCode statusCode = HttpStatusCode.OK;
try
{
var registerList = await isales.SalesList_dropdown(model);
dctData.Add("SalesList_dropdown", registerList);
}
catch (Exception ex)
{
transaction = CommonHelper.TransactionErrorHandler(ex);
statusCode = HttpStatusCode.BadRequest;
}
dctData.Add("Status", transaction);
return(this.StatusCode(Convert.ToInt32(statusCode), dctData));
}
