public List<visitor> LoadAllVisitors() { SqlConnection connection = new SqlConnection(conString); string query = "SELECT visitorName,visitorEmail,visitorCellNo FROM visitor"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); List<visitor> visitorList = new List<visitor>(); while (reader.Read()) { visitor aVisitor = new visitor(); aVisitor.visitorName = reader["visitorName"].ToString(); aVisitor.visitorEmail = reader["visitorEmail"].ToString(); aVisitor.visitorCellNo = int.Parse(reader["visitorCellNo"].ToString()); visitorList.Add(aVisitor); } reader.Close(); connection.Close(); return visitorList; }
public string Save(visitor aVisitor) { if (aFMSGateway.Save(aVisitor)>0) { return "Added Successfully!"; } else { return "Could Not Added!"; } }
public int Save(visitor aVisitor) { SqlConnection connection = new SqlConnection(conString); string query = "INSERT INTO visitor VALUES ('" + aVisitor.visitorName + "','" + aVisitor.visitorEmail + "','" + aVisitor.visitorCellNo + "')"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); int rowAffected = command.ExecuteNonQuery(); connection.Close(); return rowAffected; }