private void button1_Click(object sender, EventArgs e) { String commandText = "UPDATE AddressSet SET Street=@street, City=@city, Territory=@territory, Country=@country, ZipCode=@zipcode WHERE AddressID=@param"; string sConnection = Properties.Settings.Default.BD2ConnectionString; SqlConnection conn = new SqlConnection(); conn.ConnectionString = sConnection; conn.Open(); try { SqlCommand command = new SqlCommand(commandText, conn); command.Parameters.AddWithValue("@street", textBox1.Text.ToString()); command.Parameters.AddWithValue("@city", textBox2.Text.ToString()); command.Parameters.AddWithValue("@territory", comboBox1.Text.ToString()); command.Parameters.AddWithValue("@country", comboBox2.Text.ToString()); command.Parameters.AddWithValue("@zipcode", Int32.Parse(textBox3.Text.ToString())); command.Parameters.AddWithValue("@param", DBMonitor.pomoc); command.ExecuteNonQuery(); conn.Close(); DBMonitor powrot = new DBMonitor(); powrot.Show(); this.Hide(); } catch (SqlException er) { String text = "There was an error reported by SQL Server, " + er.Message; MessageBox.Show(text, "ERROR"); } }
private void button2_Click(object sender, EventArgs e) { String commandText = "UPDATE HCOSet SET Name=@Name, Range=@Range, Level=@Level, SpecialType=@SpecialType, Beds=@Beds, Employees=@Employees, PhoneNumber=@PhoneNumber, Email=@Email, Website=@Website, AddressID=@AddressID WHERE HCOID=@param"; string sConnection = Properties.Settings.Default.BD2ConnectionString; SqlConnection conn = new SqlConnection(); conn.ConnectionString = sConnection; conn.Open(); try { SqlCommand command = new SqlCommand(commandText, conn); command.Parameters.AddWithValue("@Name", namebox1.Text.ToString()); command.Parameters.AddWithValue("@Range", comboBox1.Text.ToString()); command.Parameters.AddWithValue("@Level", Convert.ToInt16(comboBox2.Text.ToString())); command.Parameters.AddWithValue("@SpecialType", comboBox3.Text.ToString()); command.Parameters.AddWithValue("@Beds", bedsbox1.Text.ToString()); command.Parameters.AddWithValue("@Employees", textBox1.Text.ToString()); command.Parameters.AddWithValue("@PhoneNumber", Int32.Parse(textBox2.Text.ToString())); command.Parameters.AddWithValue("@Email", textBox3.Text.ToString()); command.Parameters.AddWithValue("@Website", textBox4.Text.ToString()); command.Parameters.AddWithValue("@AddressID", Int32.Parse(label13.Text.ToString())); command.Parameters.AddWithValue("@param", DBMonitor.pomoc); command.ExecuteNonQuery(); conn.Close(); DBMonitor powrot = new DBMonitor(); powrot.Show(); this.Hide(); } catch (SqlException er) { String text = "There was an error reported by SQL Server, " + er.Message; MessageBox.Show(text, "ERROR"); } }
private void button1_Click(object sender, EventArgs e) { this.Hide(); DBMonitor powrot = new DBMonitor(); powrot.Show(); }
private void button2_Click(object sender, EventArgs e) { String commandText = "UPDATE HCPSet SET FirstName=@firstname, MiddleName=@middlename, LastName=@lastname, Gender=@gender, AcademicTitle=@academictitle, Birthdate=@birthdate, PhoneNumber=@phonenumber, Email=@email, KOL=@kol, Specialty=@specialty, AddressID=@addressid, HCOID=@hcoid WHERE HCPID=@param"; string sConnection = Properties.Settings.Default.BD2ConnectionString; SqlConnection conn = new SqlConnection(); conn.ConnectionString = sConnection; conn.Open(); try { SqlCommand command = new SqlCommand(commandText, conn); command.Parameters.AddWithValue("@param", DBMonitor.pomoc); command.Parameters.AddWithValue("@firstname", textBox1.Text); command.Parameters.AddWithValue("@middlename", textBox2.Text); command.Parameters.AddWithValue("@lastname", textBox3.Text); command.Parameters.AddWithValue("@gender", comboBox1.Text); command.Parameters.AddWithValue("@academictitle", comboBox2.Text); command.Parameters.AddWithValue("@birthdate", dateTimePicker1.Value.Date); maskedTextBox1.TextMaskFormat = MaskFormat.ExcludePromptAndLiterals; command.Parameters.AddWithValue("@phonenumber", Convert.ToInt32(maskedTextBox1.Text.ToString())); command.Parameters.AddWithValue("@email", textBox4.Text); if (checkBox1.Checked) { command.Parameters.AddWithValue("@kol", true); } else { command.Parameters.AddWithValue("@kol", false); } command.Parameters.AddWithValue("@specialty", comboBox3.Text); command.Parameters.AddWithValue("@addressid", label12.Text); command.Parameters.AddWithValue("@hcoid", label11.Text); command.ExecuteNonQuery(); conn.Close(); DBMonitor powrot = new DBMonitor(); powrot.Show(); this.Hide(); } catch (SqlException er) { String text = "There was an error reported by SQL Server, " + er.Message; MessageBox.Show(text, "ERROR"); } }
private void button1_Click(object sender, EventArgs e) { String street = textBox1.Text.ToString(); String city = textBox2.Text.ToString(); String territory = comboBox1.Text.ToString(); String country = comboBox2.Text.ToString(); Int32 zipcode = Int32.Parse(textBox3.Text.ToString()); var adres = new Address { Street = street, City = city, Territory = territory, Country = country, ZipCode = zipcode }; using (var context = new MedDBContainer()) { context.AddressSet.Add(adres); context.SaveChanges(); } this.Hide(); DBMonitor nowy = new DBMonitor(); nowy.Show(); }
private void button2_Click(object sender, EventArgs e) { String commandText = "INSERT INTO HCPSet VALUES(@firstname, @middlename, @lastname, @gender, @academictitle, @birthdate, @phonenumber, @email, @kol, @specialty, @addressid, @hcoid)"; string sConnection = Properties.Settings.Default.BD2ConnectionString; SqlConnection conn = new SqlConnection(); conn.ConnectionString = sConnection; conn.Open(); try { SqlCommand command = new SqlCommand(commandText, conn); command.Parameters.AddWithValue("@firstname", textBox1.Text.ToString()); command.Parameters.AddWithValue("@middlename", textBox2.Text.ToString()); command.Parameters.AddWithValue("@lastname", textBox3.Text.ToString()); command.Parameters.AddWithValue("@gender", comboBox1.Text.ToString()); command.Parameters.AddWithValue("@academictitle", comboBox2.Text.ToString()); command.Parameters.Add("@birthdate", SqlDbType.Date).Value = dateTimePicker1.Value.Date; maskedTextBox1.TextMaskFormat = MaskFormat.ExcludePromptAndLiterals; command.Parameters.AddWithValue("@phonenumber", Convert.ToInt32(maskedTextBox1.Text.ToString())); command.Parameters.AddWithValue("@email", textBox4.Text.ToString()); command.Parameters.AddWithValue("@kol", Convert.ToBoolean(checkBox1.Checked.ToString())); command.Parameters.AddWithValue("@specialty", comboBox3.Text.ToString()); command.Parameters.AddWithValue("@addressid", Convert.ToInt32(label12.Text.ToString())); command.Parameters.AddWithValue("@hcoid", Convert.ToInt32(label11.Text.ToString())); command.ExecuteNonQuery(); conn.Close(); DBMonitor powrot = new DBMonitor(); powrot.Show(); this.Hide(); } catch (SqlException er) { String text = "There was an error reported by SQL Server, " + er.Message; MessageBox.Show(text, "ERROR"); } }
private void button1_Click(object sender, EventArgs e) { DBMonitor nowymonitor = new DBMonitor(); nowymonitor.Show(); }