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);
}
