public bool ModifyLicenseData(string userEmail, Guid loggedUsersAccessNumber, string newLicenseDataUserName, string newLicenseDataUserEmail, string oldLicenseDataUserName, string oldLicenseDataUserEmail)
{
// TODO: To REFACTOR along with AddNewLicenseData method.
sqlConnectionToDatabase.ConnectionString = connectionString;
UserDataProvider userDataProvider = new UserDataProvider(sqlConnectionToDatabase);
if (userDataProvider.CheckExistenceUserGuidInDatabase(userEmail, loggedUsersAccessNumber))
{
sqlConnectionToDatabase.ConnectionString = connectionString;
return(new LicensesDataProvider(sqlConnectionToDatabase).ModifyLicenseData(newLicenseDataUserName, newLicenseDataUserEmail, oldLicenseDataUserName, oldLicenseDataUserEmail));
}
return(false);
}
public LicensesContainer GetLicensesData(string userEmail, Guid loggedUsersAccessNumber, int pageNumber, int columnToSort, int numberOfRowsToDisplay, bool typeOfSorting)
{
sqlConnectionToDatabase.ConnectionString = connectionString;
UserDataProvider userDataProvider = new UserDataProvider(sqlConnectionToDatabase);
if (userDataProvider.CheckExistenceUserGuidInDatabase(userEmail, loggedUsersAccessNumber))
{
sqlConnectionToDatabase.ConnectionString = connectionString;
LicensesDataProvider licensesDataProvider = new LicensesDataProvider(sqlConnectionToDatabase);
Tuple <DataSet, int> queryResult = licensesDataProvider.GetLicensesData(pageNumber, columnToSort, numberOfRowsToDisplay, typeOfSorting);
LicensesContainer container = new LicensesContainer();
container.LicensesDataSet = queryResult.Item1;
container.NumberOfAllLicenses = queryResult.Item2;
return(container);
}
return(null);
}
