//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)); }