public JsonResultEntity Create([FromBody] UserAdminParkingEntity useradminparkingEntity)
{
UserAdminParkingBL useradminparkingBL = new UserAdminParkingBL();
JsonResultEntity response = new JsonResultEntity();
try
{
var result = useradminparkingBL.Create(useradminparkingEntity);
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 UserAdminParkingEntity Create(UserAdminParkingEntity useradminparkingEntity)
{
var query = @"INSERT INTO ""UserAdminParking""(""UserProfileID"",""PlaceLocationID"",""StaffCode"",""CreatedDate"",""IsActive"") VALUES(@UserProfileID,@PlaceLocationID,@StaffCode,@CreatedDate,@IsActive) RETURNING ""ID"";";
int id = DbConnection.Query <int>(query, useradminparkingEntity).Single();
useradminparkingEntity.ID = id;
return(useradminparkingEntity);
}
public int Update(UserAdminParkingEntity useradminparkingEntity)
{
int affectedRows = 0;
if (IsHaveId <UserAdminParkingEntity>(useradminparkingEntity) == false)
{
var query = @"UPDATE ""UserAdminParking"" SET ""UserProfileID""=@UserProfileID,""PlaceLocationID""=@PlaceLocationID,""StaffCode""=@StaffCode,""IsActive""=@IsActive WHERE ""ID""=@ID";
affectedRows = DbConnection.Execute(query, useradminparkingEntity);
}
return(affectedRows);
}
public ResultEntity <UserAdminParkingEntity> Create(UserAdminParkingEntity useradminparkingEntity)
{
var validationResult = new ResultEntity <UserAdminParkingEntity>();
useradminparkingEntity.CreatedDate = DateTime.Now;
using (var useradminparkingDA = new UserAdminParkingDA())
{
validationResult.Value = useradminparkingDA.Create(useradminparkingEntity);
}
return(validationResult);
}
public ResultEntity <UserAdminParkingEntity> Update(UserAdminParkingEntity useradminparkingEntity)
{
var validationResult = new ResultEntity <UserAdminParkingEntity>();
using (var useradminparkingDA = new UserAdminParkingDA())
{
var resultUpdate = useradminparkingDA.Update(useradminparkingEntity);
if (resultUpdate <= 0)
{
validationResult.Warning.Add("Failed Updating UserAdminParking!");
return(validationResult);
}
validationResult.Value = useradminparkingEntity;
}
return(validationResult);
}
