public JsonResultEntity Create([FromBody] ParkingSpaceEntity parkingspaceEntity)
{
ParkingSpaceBL parkingspaceBL = new ParkingSpaceBL();
JsonResultEntity response = new JsonResultEntity();
try
{
var result = parkingspaceBL.Create(parkingspaceEntity);
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 ParkingSpaceEntity Create(ParkingSpaceEntity parkingspaceEntity)
{
var query = @"INSERT INTO ""ParkingSpace""(""PlaceID"",""Floor"",""Spot"",""IsActive"",""IsVIP"",""Price"",""CreatedDate"",""ModifiedDate"",""ContributorID"") VALUES(@PlaceID,@Floor,@Spot,@IsActive,@IsVIP,@Price,@CreatedDate,@ModifiedDate,@ContributorID) RETURNING ""ID"";";
int id = DbConnection.Query <int>(query, parkingspaceEntity).Single();
parkingspaceEntity.ID = id;
return(parkingspaceEntity);
}
public ResultEntity <ParkingSpaceEntity> Create(ParkingSpaceEntity parkingspaceEntity)
{
var validationResult = new ResultEntity <ParkingSpaceEntity>();
using (var parkingspaceDA = new ParkingSpaceDA())
{
validationResult.Value = parkingspaceDA.Create(parkingspaceEntity);
}
return(validationResult);
}
public int Update(ParkingSpaceEntity parkingspaceEntity)
{
int affectedRows = 0;
if (IsHaveId <ParkingSpaceEntity>(parkingspaceEntity) == false)
{
var query = @"UPDATE ""ParkingSpace"" SET ""PlaceID""=@PlaceID,""Floor""=@Floor,""Spot""=@Spot,""IsActive""=@IsActive,""IsVIP""=@IsVIP,""Price""=@Price,""CreatedDate""=@CreatedDate,""ModifiedDate""=@ModifiedDate,""ContributorID""=@ContributorID WHERE ""ID""=@ID";
affectedRows = DbConnection.Execute(query, parkingspaceEntity);
}
return(affectedRows);
}
public ResultEntity <ParkingSpaceEntity> Update(ParkingSpaceEntity parkingspaceEntity)
{
var validationResult = new ResultEntity <ParkingSpaceEntity>();
using (var parkingspaceDA = new ParkingSpaceDA())
{
var resultUpdate = parkingspaceDA.Update(parkingspaceEntity);
if (resultUpdate <= 0)
{
validationResult.Warning.Add("Failed Updating ParkingSpace!");
return(validationResult);
}
validationResult.Value = parkingspaceEntity;
}
return(validationResult);
}
