/// <summary>
/// Moves the gun smiths.
/// </summary>
/// <param name="databasePath">The database path.</param>
/// <param name="errOut">The error out.</param>
/// <returns><c>true</c> if XXXX, <c>false</c> otherwise.</returns>
/// <exception cref="System.Exception"></exception>
/// <exception cref="System.Exception"></exception>
internal static bool MoveGunSmiths(string databasePath, out string errOut)
{
errOut = "";
bool bAns = false;
string sql = "";
try
{
List <GunSmithWorkDone> lst = GunSmithDetails.Lists(databasePath, out errOut, true);
if (errOut.Length > 0)
{
throw new Exception(errOut);
}
BSOtherObjects obj = new BSOtherObjects();
foreach (GunSmithWorkDone l in lst)
{
string name = obj.FC(l.GunSmithName);
if (!ValueDoesExist(databasePath, "GunSmith_Contact_Details", "gName", name, out errOut))
{
if (!PeopleAndPlaces.GunSmiths.Add(databasePath, name, out errOut))
{
throw new Exception(errOut);
}
}
}
bAns = true;
}
catch (Exception e)
{
errOut = $"{ErrorMessage("MoveGunSmiths", e)}. {Environment.NewLine} {Environment.NewLine}SQL - {sql}";
}
return(bAns);
}
public void GetIdTest()
{
VerifyExists();
long gsid = MGC.PeopleAndPlaces.GunSmiths.GetId(_databasePath, _gunSmithName, out _errOut);
long id = GunSmithDetails.GetId(_databasePath, _gunId, gsid, _gunDetailsOrderDetails, out _errOut);
General.HasTrueValue(id > 0, _errOut);
}
public void ExistsTest()
{
VerifyExists();
bool value = GunSmithDetails.Exists(_databasePath, _gunId, _gunSmithName, _gunDetailsOrderDetails,
out _errOut);
General.HasTrueValue(value, _errOut);
}
public void ListByGunTest()
{
VerifyExists();
List <GunSmithWorkDone> value = GunSmithDetails.Lists(_databasePath, _gunId, out _errOut);
PrintList(value);
General.HasTrueValue(value.Count > 0, _errOut);
}
public void UpdateTest()
{
VerifyExists();
long gsid = MGC.PeopleAndPlaces.GunSmiths.GetId(_databasePath, _gunSmithName, out _errOut);
long id = GunSmithDetails.GetId(_databasePath, _gunId, gsid, _gunDetailsOrderDetails, out _errOut);
bool value = GunSmithDetails.Update(_databasePath, id, _gunId, _gunSmithName, gsid, _gunDetailsOrderDetails, $"UPDATED {_gunDetailsNotes}", _gunDetailsStartDate, _gunDetailsReturnDate, out _errOut);
General.HasTrueValue(value, _errOut);
}
public void AddTest()
{
VerifyDoesntExist();
VerifyContactExists();
long gsid = MGC.PeopleAndPlaces.GunSmiths.GetId(_databasePath, _gunSmithName, out _errOut);
bool value = GunSmithDetails.Add(_databasePath, _gunId, _gunSmithName, gsid, _gunDetailsOrderDetails, _gunDetailsNotes, _gunDetailsStartDate, _gunDetailsReturnDate, out _errOut);
General.HasTrueValue(value, _errOut);
}
/// <summary>
/// Verifies the doesnt exist.
/// </summary>
private void VerifyDoesntExist()
{
if (GunSmithDetails.Exists(_databasePath, _gunId, _gunSmithName, _gunDetailsOrderDetails, out _errOut))
{
VerifyContactExists();
long gsid = MGC.PeopleAndPlaces.GunSmiths.GetId(_databasePath, _gunSmithName, out _errOut);
long value = GunSmithDetails.GetId(_databasePath, _gunId, gsid, _gunDetailsOrderDetails, out _errOut);
GunSmithDetails.Delete(_databasePath, value, out _errOut);
}
}
/// <summary>
/// Verifies the exists.
/// </summary>
private void VerifyExists()
{
if (!GunSmithDetails.Exists(_databasePath, _gunId, _gunSmithName, _gunDetailsOrderDetails, out _errOut))
{
VerifyContactExists();
long gsid = MGC.PeopleAndPlaces.GunSmiths.GetId(_databasePath, _gunSmithName, out _errOut);
GunSmithDetails.Add(_databasePath, _gunId, _gunSmithName, gsid, _gunDetailsOrderDetails, _gunDetailsNotes, _gunDetailsStartDate, _gunDetailsReturnDate, out _errOut);
}
}