//Update Products added in activity
public async Task <TranStatus> update_old_Products(int Aid, Update_products_in_ActivityModel model)
{
using (activityRepository = new ActivityRepository())
{
return(await activityRepository.update_old_Products(Aid, model));
}
}
//Update Products added in activity
public async Task <TranStatus> update_old_Products(int Aid, Update_products_in_ActivityModel model)
{
using (var connection = new SqlConnection(ConnectionString))
{
await connection.OpenAsync();
TranStatus transaction = new TranStatus();
DynamicParameters parameter = new DynamicParameters();
parameter.Add("@Activity_Id", Aid);
parameter.Add("@Order_Id", model.Order_Id);
parameter.Add("@ProductID", model.ProductID);
//parameter.Add("@Price", model.Price);
parameter.Add("@Quantity", model.Quantity);
parameter.Add("@Amount", model.Amount);
parameter.Add("@Discount_per", model.Discount_per);
parameter.Add("@Discount_amt", model.Discount_amt);
parameter.Add("@Total_price", model.Total_price);
parameter.Add("@Modifiedby", model.Modifiedby);
parameter.Add("@Message", dbType: DbType.String, direction: ParameterDirection.Output, size: 500);
parameter.Add("@Code", dbType: DbType.Int32, direction: ParameterDirection.Output);
await connection.QueryAsync("update_old_Products", parameter, commandType : CommandType.StoredProcedure);
transaction.returnMessage = parameter.Get <string>("@Message");
transaction.code = parameter.Get <int>("@Code");
return(transaction);
}
}
public async Task <IActionResult> update_old_Products(int Aid, [FromBody] Update_products_in_ActivityModel model)
{
Dictionary <String, Object> dctData = new Dictionary <string, object>();
HttpStatusCode statusCode = HttpStatusCode.OK;
TranStatus transaction = new TranStatus();
try
{
transaction = await iactivity.update_old_Products(Aid, model);
}
catch (Exception ex)
{
transaction = CommonHelper.TransactionErrorHandler(ex);
statusCode = HttpStatusCode.BadRequest;
}
dctData.Add("Status", transaction);
return(this.StatusCode(Convert.ToInt32(statusCode), dctData));
}
