public void InitializeLicensesTTR() // Determine if licenses are up for renewal
{
List <License> AllLicenses = new List <License>();
DataAccess_GDataTable db = new DataAccess_GDataTable();
try
{
AllLicenses = db.GetAllData(Config.DBDir_Name);
}
catch (Exception err) // GetAllData failed
{
}
foreach (License _License in AllLicenses)
{
//DateTime ExpDate = DateTime.Parse(_License.ExpirationDate);
if (DateTime.Now >= _License.ExpirationDate.AddDays(-(Convert.ToInt32(Config.TimeToRenew))) && _License.Active == true && _License.RenewalStatus == "Renewed") // If it expires within 21 days and is currently active
{
_License.ReviewStatus = "Open";
_License.RenewalStatus = "";
db.UpdateLicenseData(_License, Config.DBDir_Name);
}
}
Utilities.CloseSQLConnection();
}
public static void GetMachineCount_UpdateDB(int idOfLicense, string DBDir_Name)
{
// get license
License SourceLicense = DataAccess_GDataTable.GetByID(idOfLicense, DBDir_Name);
// get license machines
List <LicensedMachines> sourceLicenseMachines = DataAccess_LicensedMachinesTable.GetByLicenseID(SourceLicense.Id, DBDir_Name);
// count license machines
SourceLicense.PCCount = sourceLicenseMachines.Count();
// update License in database with new count
DataAccess_GDataTable.UpdateLicenseData(SourceLicense, DBDir_Name);
}
private void ManagePCsForm_FormClosing(object sender, FormClosingEventArgs e)
{
//ConfigClass Updated_Config = Utilities.GetConfigData();
// Get Machine Count for Label
List <LicensedMachines> LM = DataAccess_LicensedMachinesTable.GetByLicenseID(InputLicense.Id, Config.DBDir_Name);
License ChangedLicense = new License();
InputLicense.CopyDataTo(ChangedLicense);
ChangedLicense.PCCount = LM.Count;
DataAccess_GDataTable.UpdateLicenseData(ChangedLicense, Config.DBDir_Name);
}
private void aButtonEdit_Click(object sender, EventArgs e)
{
License SelectedLicense = new License();
License SelectedLicense_Changed = new License();
EditForm _editForm = new EditForm();
// GET DATA
DataAccess_GDataTable db = new DataAccess_GDataTable();
try
{
// GET SELECTED LICENSE FROM DB VIA ID
SelectedLicense = db.GetByID(Convert.ToInt32(aDataGridViewLicenses[0, aDataGridViewLicenses.CurrentCell.RowIndex].FormattedValue), Config.DBDir_Name);
}
catch
{
MessageBox.Show("Please Select a row");
return;
}
// LAUNCH EDIT FORM
if (SelectedLicense != null)
{
_editForm.InputLicense = SelectedLicense; // Set License to be passed in
DialogResult _form = _editForm.ShowDialog();
if (_form == DialogResult.OK) // When editform.Savebutton is clicked
{
SelectedLicense_Changed = _editForm.OutputLicense(); // launch Edit form and return values to SelectedLicense_Changed
if (SelectedLicense_Changed != SelectedLicense)
{
// Update SQL DB using changed License
db.UpdateLicenseData(SelectedLicense_Changed, Config.DBDir_Name);
// FIND CHANGES
List <string> ChangesMade = Utilities.FindChanges(SelectedLicense, SelectedLicense_Changed);
// CREATE/SAVE LOGS
Utilities.CreateLog(ChangesMade, SelectedLicense.Id);
}
RefreshDashboard(this, e);
}
}
else
{
MessageBox.Show("No license selected to edit");
}
RefreshDashboard(this, e);
}
