private void visitorSaveButton_Click(object sender, EventArgs e) { VisitorInfo visitorInfo = new VisitorInfo(); VisitorZoneManager visitorZoneManager = new VisitorZoneManager(); visitorInfo.Name = nameTextBox.Text; visitorInfo.Email = emailTextBox.Text; visitorInfo.ContactNumber = int.Parse(contactNoTextBox.Text); int visitorId = visitorInfoManager.Save(visitorInfo); if (visitorId > 0) { foreach (var index in zoneCheckedListBox.CheckedItems) { Zone zone = (Zone)index; VisitorZone visitorZone = new VisitorZone(); visitorZone.VisitorId = visitorId; visitorZone.ZoneId = zone.Id; visitorZoneManager.Save(visitorZone); } MessageBox.Show("Visitor Inserted Successfully! "); nameTextBox.Clear(); emailTextBox.Clear(); contactNoTextBox.Clear(); } else { MessageBox.Show("Error Occurs"); } }
public void Save(VisitorZone visitorZone) { SqlConnection connection = new SqlConnection(connectionString); string query = "INSERT INTO tbl_visitor_zone VALUES ('" + visitorZone.VisitorId + "','" + visitorZone.ZoneId + "')"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); command.ExecuteNonQuery(); connection.Close(); }
public void Save(VisitorZone visitorZone) { visitorZoneGateway.Save(visitorZone); }