public static string GetActiveStudentLoanInfo(string uniLogin)
{
string activeLoanInfo = ExportSQLConnections.GetLoanInfo(uniLogin);
return(activeLoanInfo);
}
public static string GetActivePCNotInStockInfo(string qrId)
{
string pcNotInStockInfo = ExportSQLConnections.GetPCNotInStockInfo(qrId);
return(pcNotInStockInfo);
}
public static bool CheckLoanTableForQRID(string qrId)
{
bool pcInStock = ExportSQLConnections.CheckLoanTableForQR(qrId);
return(pcInStock);
}
public static int CheckIsStudentOrTeacher(int isStudent, string uniLogin)
{
isStudent = ExportSQLConnections.CheckDataBaseForIsStudent(isStudent, uniLogin);
return(isStudent);
}
public static bool CheckUniLogin(string uniLogin)
{
bool uniLoginExists = ExportSQLConnections.CheckDatabaseForLogin(uniLogin);
return(uniLoginExists);
}
public static void CreateLoan(string uniLogin, string qrId, DateTime startDate, DateTime endDate)
{
ObjectLoan addLoan = new ObjectLoan(uniLogin, qrId, startDate, endDate);
ExportSQLConnections.CreateLoan(addLoan.UNILogin, addLoan.QRID, addLoan.StartDate, addLoan.EndDate);
}
public static void CreateLoaner(string uniLogin, string name, string phone, int isStudent)
{
ObjectLoaner addLoaner = new ObjectLoaner(uniLogin, name, phone, isStudent);
ExportSQLConnections.CreateLoaner(addLoaner.UNILogin, addLoaner.Name, addLoaner.Phone, addLoaner.IsStudent);
}