public JsonResult PostInsertAdjustment(AdjustmentDTO oAdjustmentDTO) { AdjustmentsBO oAdjustmentsBO = new AdjustmentsBO(); // List<AdjustmentDTO> ocAdjustmentDTO = oAdjustmentsBO.GetTodaysAdjustments(LeagueName); return(Json(oAdjustmentsBO, JsonRequestBehavior.AllowGet)); }
private void populate_ocValuesForInsert(List <string> ocValues, object DTO) { AdjustmentDTO oAdjustmentDTO = (AdjustmentDTO)DTO; ocValues.Add(oAdjustmentDTO.LeagueName.ToString()); ocValues.Add(oAdjustmentDTO.StartDate.ToString()); ocValues.Add(oAdjustmentDTO.EndDate.ToString()); ocValues.Add(oAdjustmentDTO.Team.ToString()); ocValues.Add(oAdjustmentDTO.AdjustmentType.ToString()); ocValues.Add(oAdjustmentDTO.AdjustmentAmount.ToString()); ocValues.Add(oAdjustmentDTO.Player.ToString()); ocValues.Add(oAdjustmentDTO.Description.ToString()); ocValues.Add(oAdjustmentDTO.TS.ToString()); }
public async Task <IHttpActionResult> Post([FromBody] AdjustmentDTO adjustment) { var adjVoucher = new AdjVoucher { ItemNum = adjustment.ItemNum, CreateDate = DateTime.Today, Quantity = adjustment.Quantity, Reason = adjustment.Reason, Status = AdjustmentVoucherStatus.Pending, RequestEmpNum = adjustment.RequestEmpNum }; await _stockadjustmentRepo.AddAsync(adjVoucher); return(Ok(new { Message = "New adjusment sent" })); }
private void writeAdjustment(Row oAdjRow) { AdjustmentDTO oAdjustmentDTO = new AdjustmentDTO() { LeagueName = _oLeagueDTO.LeagueName , StartDate = _GameDate , EndDate = _GameDate , Team = oAdjRow.Team , AdjustmentType = oAdjRow.Type , AdjustmentAmount = oAdjRow.AdjAmt , Player = oAdjRow.Player , Description = oAdjRow.Desc , TS = (string.IsNullOrEmpty(oAdjRow.TS) ? _GameDate : Convert.ToDateTime(oAdjRow.TS)) }; // TableName ColNames (csv) DTO Insert DTO into ocValues Method SqlFunctions.DALInsertRow(TableName, TableColumns, oAdjustmentDTO, populate_ocValuesForInsert, _ConnectionString); }
static void populateDTOFromRdr(object oRow, SqlDataReader rdr) { AdjustmentDTO oAdjustmentDTO = new AdjustmentDTO(); oAdjustmentDTO.AdjustmentID = (int)rdr["AdjustmentID"]; oAdjustmentDTO.LeagueName = (string)rdr["LeagueName"]; oAdjustmentDTO.StartDate = (DateTime)rdr["StartDate"]; oAdjustmentDTO.EndDate = rdr["EndDate"] == DBNull.Value ? null : (DateTime?)rdr["EndDate"]; oAdjustmentDTO.Team = (string)rdr["Team"]; oAdjustmentDTO.AdjustmentType = (string)rdr["AdjustmentType"]; oAdjustmentDTO.AdjustmentAmount = (float)rdr["AdjustmentAmount"]; oAdjustmentDTO.Player = (string)rdr["Player"]; oAdjustmentDTO.Description = (string)rdr["Description"]; oAdjustmentDTO.TS = (DateTime)rdr["TS"]; List <AdjustmentDTO> ocAdjustmentDTO = (List <AdjustmentDTO>)oRow; ocAdjustmentDTO.Add(oAdjustmentDTO); }