//======================================================================================================= //This method is called when the list needs to be refreshed. It is also the same method I call when the // user clicks the "View" button on frmMain //======================================================================================================= public static void ViewCurrent() { SqlCommand _LDBComm = new SqlCommand(); Program.PartWeights.Clear(); try { SqlConnection _LDBConn = new SqlConnection(); DataSet _DS = new DataSet(); SqlDataAdapter _Adap = new SqlDataAdapter(); _DS.Clear(); _Adap.Dispose(); _LDBConn = new SqlConnection { ConnectionString = LDBConn }; _LDBComm.Connection = _LDBConn; _LDBComm.CommandType = CommandType.StoredProcedure; _LDBComm.CommandText = "[dbo].[Get_All_Weights_SP]"; _Adap = new SqlDataAdapter(_LDBComm); _Adap.Fill(_DS); var allRows = _DS.Tables[0].Rows; LoadLists.LoadWeightsList(allRows); _LDBConn.Close(); } catch (Exception ex) { string extext = ex.Message; } DetachFile(); }
//======================================================================================================= //This method called when the user wants to narrow the current part list down to a specific department. // Its parameter is what is currently entered into the text box on frmView. If the user does not // enter any kind of string in the text box it assumes the user wants to view all records in the weight // table. If a department is not found in the table, a prompt will appear and tell the user that was // was an invaild department entered. //======================================================================================================= public static void NarrowToDept(string strDept) { SqlCommand _LDBComm = new SqlCommand(); try { SqlConnection _LDBConn = new SqlConnection(); DataSet _DS = new DataSet(); SqlDataAdapter _Adap = new SqlDataAdapter(); _DS.Clear(); _Adap.Dispose(); _LDBConn = new SqlConnection { ConnectionString = LDBConn }; _LDBComm.Connection = _LDBConn; _LDBComm.CommandType = CommandType.StoredProcedure; _LDBComm.CommandText = "[dbo].[Get_All_Dept_Weights_SP]"; _LDBComm.Parameters.AddWithValue("@strDept", strDept); _Adap = new SqlDataAdapter(_LDBComm); _Adap.Fill(_DS); var allRows = _DS.Tables[0].Rows; LoadLists.LoadWeightsList(allRows); _LDBConn.Close(); DetachFile(); } catch (Exception ex) { string extext = ex.Message; } }
//======================================================================================================= //This method is called when the user wants to view the currently archived list in the module table. I // decided to implement the archvie incase the user accidently selected the wrong entry when they went // to delete the entry. You can only permanently delete a record from the archive view //======================================================================================================= public async static void ViewArchive() { SqlCommand _LDBComm = new SqlCommand(); Program.ADAMMods.Clear(); try { SqlConnection _LDBConn = new SqlConnection(); DataSet _DS = new DataSet(); SqlDataAdapter _Adap = new SqlDataAdapter(); _DS.Clear(); _Adap.Dispose(); _LDBConn = new SqlConnection { ConnectionString = LDBConn }; _LDBComm.Connection = _LDBConn; _LDBComm.CommandType = CommandType.StoredProcedure; _LDBComm.CommandText = "[dbo].[Get_Archive_Modules_SP]"; _Adap = new SqlDataAdapter(_LDBComm); _Adap.Fill(_DS); var allRows = _DS.Tables[0].Rows; LoadLists.LoadADAMList(allRows); await System.Threading.Tasks.Task.Delay(100); _LDBConn.Close(); DetachFile(); } catch (Exception ex) { string errorText = ex.Message; } }
//======================================================================================================= //This method is called when the user wants to view the currently archived list in the weight table. I // decided to implement the archvie incase the user accidently selected the wrong entry when they went // to delete the entry. You can only permanently delete a record from the archive view //======================================================================================================= public static void ViewArchive() { SqlCommand _LDBComm = new SqlCommand(); Program.PartWeights.Clear(); try { SqlConnection _LDBConn = new SqlConnection(); DataSet _DS = new DataSet(); SqlDataAdapter _Adap = new SqlDataAdapter(); _DS.Clear(); _Adap.Dispose(); _LDBConn = new SqlConnection { ConnectionString = LDBConn }; _LDBComm.Connection = _LDBConn; _LDBComm.CommandType = CommandType.StoredProcedure; _LDBComm.CommandText = "[dbo].[Get_Archive_Weights_SP]"; _Adap = new SqlDataAdapter(_LDBComm); _Adap.Fill(_DS); var allRows = _DS.Tables[0].Rows; LoadLists.LoadWeightsList(allRows); _LDBConn.Close(); DetachFile(); _frmView.RefreshDGV(); _frmView.pnlDefault.Visible = false; _frmView.pnlUpdate.Visible = false; _frmView.pnlArchiveView.Visible = true; _frmView.btnViewArchive.Visible = false; } catch (Exception ex) { string errorText = ex.Message; } }