public async Task <ActionResult> CreateOwner([FromBody] OwnerRequest ownerRequest, CancellationToken cancellationToken)
{
_logger.LogInformation($"Saving owner {ownerRequest}");
var owner = await _ownersRepo.Save(ownerRequest.ToOwner(), cancellationToken);
return(Created($"owners/{owner.Id}", OwnerDetails.FromOwner(owner)));
}
public OwnerDetails GetUser(Logindetails logindetails)
{
OwnerDetails ownerdetail = new OwnerDetails();
using (DbDataReader datareader = _ExamAcces.GetUser(logindetails))
{
ownerdetail = datareader.ToCustomEntity <OwnerDetails>();
return(ownerdetail);
}
}
public async Task <ActionResult <List <OwnerDetails> > > FindAll(CancellationToken cancellationToken)
{
var owners = await _ownersRepo.FindAll(cancellationToken);
var ret = new List <OwnerDetails>();
foreach (var owner in owners)
{
ret.Add(OwnerDetails.FromOwner(owner));
}
return(Ok(ret));
}
private OwnerInfoViewModel GetOwnerDetails(OwnerDetails ownerDetails)
{
return(new OwnerInfoViewModel
{
FullName = HttpUtility.HtmlDecode(ownerDetails.FullName),
ProfileImageUrl = ownerDetails.ProfileImageUrl,
Email = ownerDetails.Email,
PhoneNumber1 = HttpUtility.HtmlDecode(ownerDetails.PhoneNumber1),
PhoneNumber2 = HttpUtility.HtmlDecode(ownerDetails.PhoneNumber2),
Address1 = HttpUtility.HtmlDecode(ownerDetails.Address1),
Address2 = HttpUtility.HtmlDecode(ownerDetails.Address2)
});
}
private void printLicenseNumberListByStatus()
{
OwnerDetails.eVehicleStatus status = default(OwnerDetails.eVehicleStatus);
List <string> licenses;
bool needAllLicenses = r_UI.NeedPrintAllLicense();
if (!needAllLicenses)
{
status = r_UI.GetStatus(OwnerDetails.GetStatusOptions());
}
licenses = r_Garage.GetVehicleListByStatus(status, needAllLicenses);
r_UI.PrintLicenseList(licenses, status, needAllLicenses);
}
private void changeVehicleStatus()
{
string licenseNumber = r_UI.GetLicenseNumber();
OwnerDetails.eVehicleStatus status = r_UI.GetStatus(OwnerDetails.GetStatusOptions());
try
{
r_Garage.ChangeStatus(licenseNumber, status);
r_UI.PrintMessage("The vehicle status changed");
}
catch (ArgumentException ex)
{
r_UI.PrintMessage(ex.Message);
}
}
public int CreateUser(OwnerDetails newuser)
{
string procedure = "[dbo].[CreateUser]";
List <DbParameter> DbParameter = new List <DbParameter>();
DbParameter.Add(new SqlParameter {
ParameterName = "@firstname", Value = newuser.firstname, SqlDbType = SqlDbType.VarChar
});
DbParameter.Add(new SqlParameter {
ParameterName = "@lastname", Value = newuser.lastname, SqlDbType = SqlDbType.VarChar
});
DbParameter.Add(new SqlParameter {
ParameterName = "@employee_Id", Value = newuser.employee_Id, SqlDbType = SqlDbType.VarChar
});
DbParameter.Add(new SqlParameter {
ParameterName = "@email", Value = newuser.email, SqlDbType = SqlDbType.VarChar
});
DbParameter.Add(new SqlParameter {
ParameterName = "@mobileNumber", Value = newuser.mobileNumber, SqlDbType = SqlDbType.VarChar
});
DbParameter.Add(new SqlParameter {
ParameterName = "@roleKey", Value = newuser.roleKey, SqlDbType = SqlDbType.Int
});
DbParameter.Add(new SqlParameter {
ParameterName = "@permission", Value = newuser.permission, SqlDbType = SqlDbType.VarChar
});
DbParameter.Add(new SqlParameter {
ParameterName = "@genderkey", Value = newuser.genderkey, SqlDbType = SqlDbType.Int
});
DbParameter.Add(new SqlParameter {
ParameterName = "@displaypicture", Value = newuser.displaypicture, SqlDbType = SqlDbType.VarBinary
});
DbParameter.Add(new SqlParameter {
ParameterName = "@createdBy", Value = newuser.createdBy, SqlDbType = SqlDbType.Int
});
DbParameter.Add(new SqlParameter {
ParameterName = "@password", Value = newuser.password, SqlDbType = SqlDbType.VarChar
});
return(ExecuteNonQuery(1, procedure, DbParameter, CommandType.StoredProcedure));
}
public async Task <ActionResult <OwnerDetails> > FindOwner(int ownerId, CancellationToken cancellationToken)
{
var owner = await _ownersRepo.FindById(ownerId, cancellationToken);
return(Ok(OwnerDetails.FromOwner(owner)));
}
public IActionResult CreateUser([FromBody] OwnerDetails newuser)
{
return(Ok(_ExamOrchetration.CreateUser(newuser)));
}
public async Task <PetAlertDetails> GetPetAlertDetailsAsync(PetAlertDetailsRequest request)
{
PetAlertDetails petAlertDetails = null;
PetAlertTableModel petAlertTable = null;
using (var dbConnection = _dbConnectionFactory.Open())
{
petAlertTable = await dbConnection.SingleAsync <PetAlertTableModel>(pa => pa.Code == request.AlertCode &&
pa.AlertStatus == (int)AlertStatusEnum.Active)
.ConfigureAwait(false);
if (petAlertTable != null)
{
petAlertDetails = new PetAlertDetails();
petAlertDetails.PetInfo = new PetDetails();
petAlertDetails.OwnersInfo = new List <OwnerDetails>();
OwnerDetails ownerDetails;
// --- Pet Details ---
if (petAlertTable.PetId.HasValue && petAlertTable.PetId > 0)
{
var petQuery = dbConnection.From <PetTableModel>()
.Join <PetTableModel, PetAlertTableModel>((p, pa) => p.Id == pa.PetId &&
pa.Code == petAlertTable.Code);
var petResult = await dbConnection.SelectMultiAsync <PetTableModel, PetAlertTableModel>(petQuery)
.ConfigureAwait(false);
var petImages = await dbConnection.SelectAsync <PetImageTableModel>(pi => pi.PetTableModelId == petAlertTable.PetId.Value)
.ConfigureAwait(false);
foreach (var item in petResult)
{
petAlertDetails.PetInfo.Name = item.Item1.Name;
petAlertDetails.PetInfo.ProfileImageUrl = petImages.Where(pi => pi.IsProfileImage).FirstOrDefault()?.ImageUrl;
petAlertDetails.PetInfo.DateOfBirth = item.Item1.DateOfBirth;
petAlertDetails.PetInfo.Description = item.Item1.Description;
petAlertDetails.PetInfo.LostComment = item.Item2.Comment;
petAlertDetails.PetInfo.LostDateTime = item.Item2.CreatedOn;
petAlertDetails.PetInfo.PositionImageUrl = item.Item2.PositionImageUrl;
petAlertDetails.PetInfo.Images = petImages.Select(pi => pi.ImageUrl).ToList();
}
}
else
{
var petImages = await dbConnection.SelectAsync <PetAlertImageTableModel>(pi => pi.PetAlertTableModelId == petAlertTable.Id)
.ConfigureAwait(false);
petAlertDetails.PetInfo.Name = GeneralHelper.GetAnonymousTitle(petAlertTable.AlertType);
petAlertDetails.PetInfo.LostComment = petAlertTable.Comment;
petAlertDetails.PetInfo.LostDateTime = petAlertTable.CreatedOn;
petAlertDetails.PetInfo.PositionImageUrl = petAlertTable.PositionImageUrl;
petAlertDetails.PetInfo.Images = petImages.Select(x => x.ImageUrl).ToList();
}
// --- Owner Details ---
if (petAlertTable.OwnerTableModelId.HasValue && petAlertTable.OwnerTableModelId > 0)
{
// --- Owner's Pet --
if (petAlertTable.PetId.HasValue && petAlertTable.PetId.Value > 0)
{
var ownersQuery = dbConnection.From <OwnerPetTableModel>()
.Join <OwnerPetTableModel, OwnerTableModel>((op, o) => op.OwnerTableModelId == o.Id)
.Join <OwnerPetTableModel, OwnerSettingTableModel>((op, os) => op.OwnerTableModelId == os.OwnerTableModelId)
.Where(op => op.PetTableModelId == petAlertTable.PetId.Value);
var ownersResult = await dbConnection.SelectMultiAsync <OwnerPetTableModel, OwnerTableModel, OwnerSettingTableModel>(ownersQuery)
.ConfigureAwait(false);
foreach (var item in ownersResult)
{
ownerDetails = new OwnerDetails
{
FullName = $"{item.Item2.FirstName} {item.Item2.LastName}",
ProfileImageUrl = item.Item2.ProfileImageUrl,
Email = item.Item3.ShowEmailForAlerts ? item.Item2.Email : string.Empty,
PhoneNumber1 = item.Item3.ShowPhoneNumberForAlerts ? item.Item2.PhoneNumber1 : string.Empty,
PhoneNumber2 = item.Item3.ShowPhoneNumberForAlerts ? item.Item2.PhoneNumber2 : string.Empty,
Address1 = item.Item3.ShowAddressForAlerts ? item.Item2.Address1 : string.Empty,
Address2 = item.Item3.ShowAddressForAlerts ? item.Item2.Address2 : string.Empty
};
petAlertDetails.OwnersInfo.Add(ownerDetails);
}
}
else // --- Other Pet ---
{
var ownersQuery = dbConnection.From <OwnerTableModel>()
.Join <OwnerTableModel, OwnerSettingTableModel>((o, os) => o.Id == os.OwnerTableModelId)
.Where(o => o.Id == petAlertTable.OwnerTableModelId);
var ownersResult = await dbConnection.SelectMultiAsync <OwnerTableModel, OwnerSettingTableModel>(ownersQuery)
.ConfigureAwait(false);
foreach (var item in ownersResult)
{
ownerDetails = new OwnerDetails
{
FullName = $"{item.Item1.FirstName} {item.Item1.LastName}",
ProfileImageUrl = item.Item1.ProfileImageUrl,
Email = item.Item2.ShowEmailForAlerts ? item.Item1.Email : string.Empty,
PhoneNumber1 = item.Item2.ShowPhoneNumberForAlerts ? item.Item1.PhoneNumber1 : string.Empty,
PhoneNumber2 = item.Item2.ShowPhoneNumberForAlerts ? item.Item1.PhoneNumber2 : string.Empty,
Address1 = item.Item2.ShowAddressForAlerts ? item.Item1.Address1 : string.Empty,
Address2 = item.Item2.ShowAddressForAlerts ? item.Item1.Address2 : string.Empty
};
petAlertDetails.OwnersInfo.Add(ownerDetails);
}
}
}
}
}
return(petAlertDetails);
}
public async Task <PetLostDetails> GetPetLostDetails(PetLostDetailsRequest request)
{
var result = new PetLostDetails
{
PetInfo = new PetDetails(),
OwnersInfo = new List <OwnerDetails>()
};
PetTableModel pet = null;
using (var dbConnection = _dbConnectionFactory.Open())
{
if (request.PetId.HasValue)
{
pet = await dbConnection.SingleByIdAsync <PetTableModel>(request.PetId.Value)
.ConfigureAwait(false);
}
else
{
pet = await dbConnection.SingleAsync <PetTableModel>(p => p.Code == request.PetCode.Value)
.ConfigureAwait(false);
}
if (pet != null)
{
var ownersQuery = dbConnection.From <OwnerPetTableModel>()
.Join <OwnerTableModel>((op, o) => op.OwnerTableModelId == o.Id)
.Join <OwnerSettingTableModel>((op, os) => op.OwnerTableModelId == os.OwnerTableModelId)
.Where(op => op.PetTableModelId == pet.Id);
var ownersResult = await dbConnection.SelectMultiAsync <OwnerPetTableModel, OwnerTableModel, OwnerSettingTableModel>(ownersQuery)
.ConfigureAwait(false);
var petQuery = dbConnection.From <PetTableModel>()
.Join <PetTableModel, PetAlertTableModel>((p, pa) => p.Id == pa.PetId && pa.AlertType == (int)AlertTypeEnum.Lost && pa.AlertStatus == (int)AlertStatusEnum.Active)
.Where(p => p.Id == pet.Id);
var petResult = await dbConnection.SelectMultiAsync <PetTableModel, PetAlertTableModel>(petQuery)
.ConfigureAwait(false);
var petImages = await dbConnection.SelectAsync <PetImageTableModel>(pi => pi.PetTableModelId == pet.Id)
.ConfigureAwait(false);
foreach (var item in petResult)
{
result.PetInfo.Name = item.Item1.Name;
result.PetInfo.ProfileImageUrl = petImages.Where(pi => pi.IsProfileImage).FirstOrDefault()?.ImageUrl;
result.PetInfo.DateOfBirth = item.Item1.DateOfBirth;
result.PetInfo.Description = item.Item1.Description;
result.PetInfo.LostComment = item.Item2.Comment;
result.PetInfo.LostDateTime = item.Item2.CreatedOn;
result.PetInfo.PositionImageUrl = item.Item2.PositionImageUrl;
result.PetInfo.Images = petImages.Select(pi => pi.ImageUrl).ToList();
}
OwnerDetails ownerDetails;
foreach (var item in ownersResult)
{
ownerDetails = new OwnerDetails
{
FullName = $"{item.Item2.FirstName} {item.Item2.LastName}",
ProfileImageUrl = item.Item2.ProfileImageUrl,
Email = item.Item3.ShowEmailForAlerts ? item.Item2.Email : string.Empty,
PhoneNumber1 = item.Item3.ShowPhoneNumberForAlerts ? item.Item2.PhoneNumber1 : string.Empty,
PhoneNumber2 = item.Item3.ShowPhoneNumberForAlerts ? item.Item2.PhoneNumber2 : string.Empty,
Address1 = item.Item3.ShowAddressForAlerts ? item.Item2.Address1 : string.Empty,
Address2 = item.Item3.ShowAddressForAlerts ? item.Item2.Address2 : string.Empty
};
result.OwnersInfo.Add(ownerDetails);
}
}
}
return(result);
}
/// <summary>
/// There are no comments for OwnerDetails in the schema.
/// </summary>
public void AddToOwnerDetails(OwnerDetails ownerDetails)
{
base.AddObject("OwnerDetails", ownerDetails);
}
/// <summary>
/// Create a new OwnerDetails object.
/// </summary>
/// <param name="detailId">Initial value of DetailId.</param>
public static OwnerDetails CreateOwnerDetails(int detailId)
{
OwnerDetails ownerDetails = new OwnerDetails();
ownerDetails.DetailId = detailId;
return ownerDetails;
}
public string CreateUser(OwnerDetails newuser)
{
int dataReader = _ExamAcces.CreateUser(newuser);
return("vxv");
}
public string CreateUser(OwnerDetails newuser)
{
return(_ExamRepository.CreateUser(newuser));
}
