private void dataGrid_UnloadingRow(object sender, DataGridRowEventArgs e) { if (((DataGrid)sender).SelectedItem != null || ((DataGrid)sender).CurrentItem == null) { return; } JobApplicationKeywords myJobApplicationkeywords = (JobApplicationKeywords)((DataGrid)sender).CurrentItem; keywordManager.Delete(myJobApplicationkeywords.Id); }
public void Upsert(JobApplicationKeywords myKeyword) { SqlConnection thisConnection = null; if (String.IsNullOrEmpty(ConnectionString1.SqlConnString)) { return; } else { thisConnection = new SqlConnection(ConnectionString1.SqlConnString); } //Create Command object SqlCommand nonqueryCommand = thisConnection.CreateCommand(); try { // Open Connection thisConnection.Open(); Console.WriteLine("Connection Opened"); // Create INSERT statement with Keywordd parameters nonqueryCommand.CommandText = " IF NOT EXISTS(SELECT* FROM dbo.JobApplicationKeywords WHERE ID = @Id)" + "INSERT INTO [dbo].[JobApplicationKeywords] " + //" ([Id] " + " ([Keyword] " + " ,[Enabled]) " + " VALUES " + //" (@Id " + " (@Keyword " + " ,@Enabled) " + " ELSE " + "UPDATE [dbo].[JobApplicationKeywords] " + " SET [Keyword] = @Keyword " + " ,[Enabled] = @Enabled " + " WHERE Id = @Id " + " "; // Add Parameters to Command Parameters collection nonqueryCommand.Parameters.Add("@Id", SqlDbType.Int); nonqueryCommand.Parameters.Add("@Keyword", SqlDbType.VarChar, 500); nonqueryCommand.Parameters.Add("@Enabled", SqlDbType.Bit); // Prepare command for repeated execution nonqueryCommand.Prepare(); // Data to be inserted nonqueryCommand.Parameters["@Id"].Value = myKeyword.Id; nonqueryCommand.Parameters["@Keyword"].Value = myKeyword.Keyword; nonqueryCommand.Parameters["@Enabled"].Value = myKeyword.Enabled; Console.WriteLine("Executing {0}", nonqueryCommand.CommandText); Console.WriteLine("Number of rows affected : {0}", nonqueryCommand.ExecuteNonQuery()); } catch (SqlException ex) { // Display error Console.WriteLine("Error: " + ex.ToString()); } finally { // Close Connection thisConnection.Close(); Console.WriteLine("Connection Closed"); } }
public ObservableCollection <JobApplicationKeywords> GetKeywords() { ObsCollJobApplicationKeywords = new ObservableCollection <JobApplicationKeywords>(); // ******************************************************************** // Code Generated by Ideal Tools Organizer at http://idealautomate.com // ******************************************************************** // Define Query String string queryString = "Select * from jobapplicationkeywords " + ""; // Define .net fields to hold each column selected in query Int32 int_jobapplicationkeywords_Id; String str_jobapplicationkeywords_Keyword; Boolean bool_jobapplicationkeywords_Enabled; // Define a datatable that we will define columns in to match the columns // selected in the query. We will use sqldatareader to read the results // from the sql query one row at a time. Then we will add each of those // rows to the datatable - this is where you can modify the information // returned from the sql query one row at a time. Finally, we will // bind the table to the gridview. DataTable dt = new DataTable(); if (!String.IsNullOrEmpty(ConnectionString1.SqlConnString)) { using (SqlConnection connection = new SqlConnection(ConnectionString1.SqlConnString)) { SqlCommand command = new SqlCommand(queryString, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); // Define a column in the table for each column that was selected in the sql query // We do this before the sqldatareader loop because the columns only need to be // defined once. DataColumn column = null; column = new DataColumn("jobapplicationkeywords_Id", Type.GetType("System.Int32")); dt.Columns.Add(column); column = new DataColumn("jobapplicationkeywords_Keyword", Type.GetType("System.String")); dt.Columns.Add(column); column = new DataColumn("jobapplicationkeywords_Enabled", Type.GetType("System.Boolean")); dt.Columns.Add(column); // Read the results from the sql query one row at a time while (reader.Read()) { // define a new datatable row to hold the row read from the sql query DataRow dataRow = dt.NewRow(); // Move each field from the reader to a holding field in .net // ******************************************************************** // The holding field in .net is where you can alter the contents of the // field // ******************************************************************** // Then, you move the contents of the holding .net field to the column in // the datarow that you defined above JobApplicationKeywords _jobapplicationkeywords = new JobApplicationKeywords(); if (!(reader.IsDBNull(0))) { int_jobapplicationkeywords_Id = reader.GetInt32(0); dataRow["jobapplicationkeywords_Id"] = int_jobapplicationkeywords_Id; _jobapplicationkeywords.Id = int_jobapplicationkeywords_Id; } if (!(reader.IsDBNull(1))) { str_jobapplicationkeywords_Keyword = reader.GetString(1); dataRow["jobapplicationkeywords_Keyword"] = str_jobapplicationkeywords_Keyword; _jobapplicationkeywords.Keyword = str_jobapplicationkeywords_Keyword; } if (!(reader.IsDBNull(2))) { bool_jobapplicationkeywords_Enabled = reader.GetBoolean(2); dataRow["jobapplicationkeywords_Enabled"] = bool_jobapplicationkeywords_Enabled; _jobapplicationkeywords.Enabled = bool_jobapplicationkeywords_Enabled; } // Add the row to the datatable dt.Rows.Add(dataRow); ObsCollJobApplicationKeywords.Add(_jobapplicationkeywords); } // Call Close when done reading. reader.Close(); } } // assign the datatable as the datasource for the gridview and bind the gridview return(ObsCollJobApplicationKeywords); }