public List<Visitor> GetAllZoneVisitorNumber(int zoneVisitorNumberId)
{
SqlConnection connection = new SqlConnection(databaseConString);
string query = "SELECT * FROM tbl_visitor WHERE visitor_zoneId LIKE '%" + zoneVisitorNumberId + "%'";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
List<Visitor> visitorList = new List<Visitor>();
while (reader.Read())
{
Visitor visitors = new Visitor();
visitors.VisitorId = int.Parse(reader["visitor_id"].ToString());
visitors.VisitorName = reader["visitor_name"].ToString();
visitors.VisitorEmail = reader["visitor_email"].ToString();
visitors.ContactNumber = reader["visitor_contactNo"].ToString();
visitorList.Add(visitors);
}
reader.Close();
connection.Close();
return visitorList;
}
private void saveButton_Click(object sender, EventArgs e)
{
if (visitorNameTextBox.Text == "" || visitorEmailTextBox.Text == "" || contactNumberTextBox.Text == "")
{
MessageBox.Show("All fields are required!");
}
else
{
Visitor visitors = new Visitor();
visitors.VisitorName = visitorNameTextBox.Text;
visitors.VisitorEmail = visitorEmailTextBox.Text;
visitors.ContactNumber = contactNumberTextBox.Text;
string selectZoneId = "";
foreach (Zone item in zoneCheckedListBox.CheckedItems)
{
selectZoneId += item.ZoneId.ToString() + ",";
}
visitors.VisitorZoneId = selectZoneId;
MessageBox.Show(visitorEntryManager.Save(visitors));
}
}
public Visitor GetVisitorEmail(string visitorEmail)
{
SqlConnection connection = new SqlConnection(databaseConString);
string query = "SELECT * FROM tbl_visitor WHERE visitor_email = '" + visitorEmail + "'";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
Visitor visitors = null;
while (reader.Read())
{
if (visitors == null)
{
visitors = new Visitor();
}
visitors.VisitorId = int.Parse(reader["visitor_id"].ToString());
visitors.VisitorEmail = reader["visitor_email"].ToString();
}
reader.Close();
connection.Close();
return visitors;
}
public int Insert(Visitor visitors)
{
SqlConnection connection = new SqlConnection(databaseConString);
string query = "INSERT INTO tbl_visitor VALUES ('" + visitors.VisitorName + "','" + visitors.VisitorEmail +
"','" + visitors.ContactNumber + "','" + visitors.VisitorZoneId + "')";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
int rowAffected = command.ExecuteNonQuery();
connection.Close();
return rowAffected;
}
public string Save(Visitor visitors)
{
bool checkVisitorEmail = IsCheckVisitorEmail(visitors.VisitorEmail);
if (checkVisitorEmail)
{
return "Email Allready Exists!";
}
if (visitorEntryGateway.Insert(visitors) > 0)
{
return "Added Successfully!";
}
else
{
return "Could Not Added";
}
}