public Rollouts(Client client, DateTime date, SearchBy searchBy)
{
MySqlCommand cmd;
Rollout roll;
string dateField = (searchBy == SearchBy.RollDate) ? "rolledDate" : "scheduledDate";
date = date.Date; // Store date part, time part not needed.
using(MySqlConnection conn = (MySqlConnection)this.Conn){
conn.Open();
cmd = conn.CreateCommand();
cmd.CommandText = "SELECT * FROM " + _table + " WHERE clientId = @clientId AND " + dateField + " = @" + dateField;
cmd.Parameters.Add("@clientId", client.Id);
cmd.Parameters.Add("@" + dateField, date);
using(MySqlDataReader dr = cmd.ExecuteReader()){
if(!dr.HasRows && dateField == "scheduledDate"){
roll = new Rollout();
roll.Client = client;
roll.ScheduledDate = date;
roll.BusinessCollection = this;
List.Add(roll);
}else{
while (dr.Read()){
roll = new Rollout(dr);
roll.BusinessCollection = this;
List.Add(roll);
}
}
}
}
}
public Client Add(Client obj)
{
obj.BusinessCollection = this;
List.Add(obj); return obj;
}
public bool Contains(Client obj)
{
foreach(Client child in List) {
if (obj.Equals(child)){
return true;
}
}
return false;
}
private Clients()
{
Client obj;
using(MySqlConnection conn = Connections.Inst.item("HTS").MySqlConnection){
using (MySqlDataReader dr = MySqlDBLayer.LoadAll(conn, _table)){
while(dr.Read()) {
obj = new Client(dr);
obj.BusinessCollection = this;
List.Add(new Client(dr));
}
}
}
}