private void button1_Click(object sender, EventArgs e)
{
try
{
if (!String.IsNullOrWhiteSpace(textBox1.Text))
{
ProcedureClassDataContext procedureContext = new ProcedureClassDataContext();
Procedure proc = new Procedure();
proc.procedure = textBox1.Text;
procedureContext.Procedures.InsertOnSubmit(proc);
procedureContext.SubmitChanges();
textBox1.Text = "";
Form1.GetProcedures();
loadProcedures();
}
else
{
MessageBox.Show("Cannot be empty...", "Error",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch
{
MessageBox.Show("Something went wrong, try again...", "Error",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
partial void DeleteProcedure(Procedure instance);
partial void UpdateProcedure(Procedure instance);
partial void InsertProcedure(Procedure instance);
partial void DeleteProcedure(Procedure instance);
partial void UpdateProcedure(Procedure instance);
partial void InsertProcedure(Procedure instance);
public static void GetProcedures()
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
string queryString = "SELECT * FROM Procedures";
using (SqlCommand command = new SqlCommand(queryString, connection))
{
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Procedure procedure = new Procedure();
procedure.procedure = (!reader.IsDBNull(reader.GetOrdinal("procedure"))) ? reader.GetString(0) : "null";
ProceduresList.Add(procedure);
}
}
}
}
}