public JsonResultEntity Create([FromBody] ParkingSpacePriceEntity parkingspacepriceEntity) { ParkingSpacePriceBL parkingspacepriceBL = new ParkingSpacePriceBL(); JsonResultEntity response = new JsonResultEntity(); try { var result = parkingspacepriceBL.Create(parkingspacepriceEntity); if (result.HasWarning()) { response.Message = String.Join(",", result.Warning); return(response); } response.Success = true; response.Data = result.Value; } catch (Exception ex) { response.Message = ex.Message; LoggerHelper.Error(ex); } return(response); }
public ParkingSpacePriceEntity Create(ParkingSpacePriceEntity parkingspacepriceEntity) { var query = @"INSERT INTO ""ParkingSpacePrice""(""ParkingSpaceID"",""StartDate"",""EndDate"",""Price"",""Category"",""CreatedDate"") VALUES(@ParkingSpaceID,@StartDate,@EndDate,@Price,@Category,@CreatedDate) RETURNING ""ID"";"; int id = DbConnection.Query <int>(query, parkingspacepriceEntity).Single(); parkingspacepriceEntity.ID = id; return(parkingspacepriceEntity); }
public int Update(ParkingSpacePriceEntity parkingspacepriceEntity) { int affectedRows = 0; if (IsHaveId <ParkingSpacePriceEntity>(parkingspacepriceEntity) == false) { var query = @"UPDATE ""ParkingSpacePrice"" SET ""ParkingSpaceID""=@ParkingSpaceID,""StartDate""=@StartDate,""EndDate""=@EndDate,""Price""=@Price,""Category""=@Category,""ModifiedDate""=@ModifiedDate WHERE ""ID""=@ID"; affectedRows = DbConnection.Execute(query, parkingspacepriceEntity); } return(affectedRows); }
public ResultEntity <ParkingSpacePriceEntity> Create(ParkingSpacePriceEntity parkingspacepriceEntity) { var validationResult = new ResultEntity <ParkingSpacePriceEntity>(); parkingspacepriceEntity.CreatedDate = DateTime.Now; using (var parkingspacepriceDA = new ParkingSpacePriceDA()) { validationResult.Value = parkingspacepriceDA.Create(parkingspacepriceEntity); } return(validationResult); }
public ResultEntity <ParkingSpacePriceEntity> Update(ParkingSpacePriceEntity parkingspacepriceEntity) { var validationResult = new ResultEntity <ParkingSpacePriceEntity>(); parkingspacepriceEntity.ModifiedDate = DateTime.Now; using (var parkingspacepriceDA = new ParkingSpacePriceDA()) { var resultUpdate = parkingspacepriceDA.Update(parkingspacepriceEntity); if (resultUpdate <= 0) { validationResult.Warning.Add("Failed Updating ParkingSpacePrice!"); return(validationResult); } validationResult.Value = parkingspacepriceEntity; } return(validationResult); }