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(); }
private void aComboboxSortBy_SelectedIndexChanged(object sender, EventArgs e) { DataAccess_GDataTable db = new DataAccess_GDataTable(); Class_Library.DataGridView.DGVSortInfo SavedSortation = new Class_Library.DataGridView.DGVSortInfo(); SavedSortation = DGVUtilities.GetSortation(aDataGridViewLicenses); if (aComboboxSortBy.SelectedItem.ToString() == "Opened Licenses") { Utilities.EnableSearch(aButtonSearch, aTextBoxSearch, aLabelSearch, false); LicensesDGV = db.GetByReviewStatus("Open", Config.DBDir_Name); BindingListView <License> SortableLicensesDGV = new BindingListView <License>(LicensesDGV); aDataGridViewLicenses.DataSource = SortableLicensesDGV; aLabelLicenseFoundInt.Text = aDataGridViewLicenses.Rows.Count.ToString(); } if (aComboboxSortBy.SelectedItem.ToString() == @"Search by Name\Id") { Utilities.EnableSearch(aButtonSearch, aTextBoxSearch, aLabelSearch, true); } if (aComboboxSortBy.SelectedItem.ToString() == "Search by Machine Name") { Utilities.EnableSearch(aButtonSearch, aTextBoxSearch, aLabelSearch, true); } if (aComboboxSortBy.SelectedItem.ToString() == "All Licenses") { Utilities.EnableSearch(aButtonSearch, aTextBoxSearch, aLabelSearch, false); LicensesDGV = db.GetAllData(Config.DBDir_Name); BindingListView <License> SortableLicensesDGV = new BindingListView <License>(LicensesDGV); aDataGridViewLicenses.DataSource = SortableLicensesDGV; aLabelLicenseFoundInt.Text = aDataGridViewLicenses.Rows.Count.ToString(); } DGVUtilities.SetSortation(SavedSortation, aDataGridViewLicenses); Utilities.CloseSQLConnection(); }
private void MoveForm_Shown(object sender, EventArgs e) { // GET DEFAULT DATA LicensesDGV = DataAccess_GDataTable.GetAllData(Config.DBDir_Name); // PUT DATA INTO SORTABLE LIST BindingListView <License> SortableLicensesDGV = new BindingListView <License>(LicensesDGV); // SET DGV.DATASOURCE aDataGridViewLicenses.DataSource = SortableLicensesDGV; // SET DEFAULT SORTATION DGVUtilities.SetSortationDefault(5, SortOrder.Descending, aDataGridViewLicenses); Utilities.CloseSQLConnection(); }
/// <summary> /// This is only used when the DB structure has changed. /// </summary> /// <param name="OldDBDir"></param> /// <param name="NewDBDir"></param> public void MoveDBtoNewDB(string OldDBDir, string NewDBDir) { DataAccess_GDataTable db = new DataAccess_GDataTable(); List <License> OldLicenseData = db.GetAllData(OldDBDir); for (int i = 0; i < OldLicenseData.Count; i++) { foreach (License _Lic in OldLicenseData) { if (_Lic.Id == i) { string _CompanyName = Utilities.CorrectApostropheForSQL(_Lic.CompanyName); string _FirstName = Utilities.CorrectApostropheForSQL(_Lic.FirstName); string _LastName = Utilities.CorrectApostropheForSQL(_Lic.LastName); string _ReviewStatus = _Lic.ReviewStatus; DateTime ExpDate = _Lic.ExpirationDate; int _PCCount = _Lic.PCCount; string _RenewalStatus = _Lic.RenewalStatus; bool _Active = _Lic.Active; string _Notes = Utilities.CorrectApostropheForSQL(_Lic.Notes); int _ID = _Lic.Id; bool _ChkBxWillCancel = _Lic.ChkBxWillCancel; bool _ChkBxUninstalled = _Lic.ChkBxUninstalled; bool _ChkBxDeleted = _Lic.ChkBxDeleted; // Create command for SQL server SqlConnection sqlConnection1 = new SqlConnection((Helper.CnnValCustom(NewDBDir))); SqlDataReader reader; SqlCommand command = new SqlCommand(); command.CommandText = $"INSERT INTO GDataTable (ReviewStatus, CompanyName, FirstName, LastName, ExpirationDate, PCCount, RenewalStatus, Active, Notes) VALUES ('{_ReviewStatus}', '{_CompanyName}', '{_FirstName}', '{_LastName}', '{ExpDate}', '{_PCCount}', '{_RenewalStatus}', '{_Active}', '{_Notes}','{_ChkBxWillCancel}','{_ChkBxUninstalled}','{_ChkBxDeleted}')"; command.CommandType = CommandType.Text; command.Connection = sqlConnection1; sqlConnection1.Open(); reader = command.ExecuteReader(); sqlConnection1.Close(); } } } }