public bool AddLendedObjectToLend(LendedObject lendedObjectToAddToDB)
{
bool success = false;
foreach (LendObject lendObject in lendedObjectToAddToDB.LendObjects)
{
try
{
SqlConnection.ConnectMySql();
MySqlCommand cmd = new MySqlCommand($"INSERT INTO lend (lend_itemmifare, lend_usermifare, lend_lenddate, lend_returndate) VALUES ('{lendObject.ItemObject.ItemMifare}', '{lendedObjectToAddToDB.UserObject.UserMifare}', '{FormatDateBackEnd(lendObject.LendDate.ToString())}', '{FormatDateBackEnd(lendObject.ReturnDate.ToString())}'), {SqlConnection.mySqlConnection}");
cmd.ExecuteNonQuery();
//MySqlDataReader rdr = cmd.ExecuteReader();
success = true;
}
catch (Exception ex)
{
SqlConnection.mySqlConnection.Close();
Debug.WriteLine("############################FAILED: " + ex);
success = false;
}
finally
{
SqlConnection.mySqlConnection.Close();
}
}
return(success);
}
public LendedObject GetUserData(string userMifare)
{
UserObject userObject = UserController.Instance.GetUserObject(userMifare);
List <LendObject> lendObjectList = DALLend.Instance.GetLendedByUserMifare(userMifare).Concat(DALLend.Instance.GetArchiveByUserMifare(userMifare)).ToList();
foreach (LendObject obj in lendObjectList)
{
if (obj.ReturnedDate == null && obj.ItemObject.Type == "Computer")
{
userObject.HasPC = true;
}
}
LendedObject lendedObject = new LendedObject(userObject, lendObjectList);
return(lendedObject);
}
public bool GenLendedObject(UserObject scannedUser, List <LendObject> scannedItems)
{
LendedObject lendedObjectToAddToDB = new LendedObject(scannedUser, scannedItems);
return(DALLend.Instance.AddLendedObjectToLend(lendedObjectToAddToDB));
}
