public static HealthCardEPCRemaining LoadAll(DataRow row)
{
HealthCardEPCRemaining epcremaining = Load(row, "epcremaining_");
epcremaining.Field = IDandDescrDB.Load(row, "field_field_id", "field_descr");
return(epcremaining);
}
/// <summary>Returns Hashtable with key "HealthCardID" and value is an array "HealthCardEPCRemaining[]".</summary>
public static Hashtable GetHashtableByHealthCardIDs(int[] health_card_ids)
{
string sql = JoinedSql + " AND health_card_id IN (" + (health_card_ids.Length == 0 ? "0" : string.Join(", ", health_card_ids)) + ")";
Hashtable hash = new Hashtable();
DataTable tbl = DBBase.ExecuteQuery(sql).Tables[0];
for (int i = 0; i < tbl.Rows.Count; i++)
{
HealthCardEPCRemaining epcRemaining = LoadAll(tbl.Rows[i]);
if (hash[epcRemaining.HealthCardID] == null)
{
hash[epcRemaining.HealthCardID] = new ArrayList();
}
((ArrayList)hash[epcRemaining.HealthCardID]).Add(epcRemaining);
}
ArrayList keys = new ArrayList();
foreach (int key in hash.Keys)
{
keys.Add(key);
}
for (int i = 0; i < keys.Count; i++)
{
ArrayList item = (ArrayList)hash[(int)keys[i]];
hash[(int)keys[i]] = (HealthCardEPCRemaining[])item.ToArray(typeof(HealthCardEPCRemaining));
}
return(hash);
}
public static HealthCardEPCRemaining[] CloneList(HealthCardEPCRemaining[] list)
{
HealthCardEPCRemaining[] retList = new HealthCardEPCRemaining[list.Length];
for (int i = 0; i < list.Length; i++)
retList[i] = list[i].Clone();
return retList;
}
public HealthCardEPCRemainingChangeHistory(int health_card_epc_remaining_change_history_id, int health_card_epc_remaining_id, int staff_id, DateTime date, int pre_num_services_remaining, int post_num_services_remaining)
{
this.health_card_epc_remaining_change_history_id = health_card_epc_remaining_change_history_id;
this.health_card_epc_remaining = new HealthCardEPCRemaining(health_card_epc_remaining_id);
this.staff = new Staff(staff_id);
this.date = date;
this.pre_num_services_remaining = pre_num_services_remaining;
this.post_num_services_remaining = post_num_services_remaining;
}
public static HealthCardEPCRemaining[] GetByHealthCardID(int health_card_id, int field_id = -1)
{
DataTable tbl = GetDataTable_ByHealthCardID(health_card_id, field_id);
HealthCardEPCRemaining[] result = new HealthCardEPCRemaining[tbl.Rows.Count];
for (int i = 0; i < tbl.Rows.Count; i++)
result[i] = LoadAll(tbl.Rows[i]);
return result;
}
public static HealthCardEPCRemaining[] CloneList(HealthCardEPCRemaining[] list)
{
HealthCardEPCRemaining[] retList = new HealthCardEPCRemaining[list.Length];
for (int i = 0; i < list.Length; i++)
{
retList[i] = list[i].Clone();
}
return(retList);
}
public static HealthCardEPCRemaining[] GetByHealthCardID(int health_card_id, int field_id = -1)
{
DataTable tbl = GetDataTable_ByHealthCardID(health_card_id, field_id);
HealthCardEPCRemaining[] result = new HealthCardEPCRemaining[tbl.Rows.Count];
for (int i = 0; i < tbl.Rows.Count; i++)
{
result[i] = LoadAll(tbl.Rows[i]);
}
return(result);
}
public HealthCardEPCRemaining Clone()
{
HealthCardEPCRemaining o = new HealthCardEPCRemaining(
this.HealthCardEpcRemainingID,
this.HealthCardID,
this.Field.ID,
this.NumServicesRemaining,
this.DeletedBy,
this.DateDeleted);
o.field.Descr = this.Field.Descr;
return(o);
}
public HealthCardEPCRemaining Clone()
{
HealthCardEPCRemaining o = new HealthCardEPCRemaining(
this.HealthCardEpcRemainingID,
this.HealthCardID,
this.Field.ID,
this.NumServicesRemaining,
this.DeletedBy,
this.DateDeleted);
o.field.Descr = this.Field.Descr;
return o;
}
public static HealthCardEPCRemaining GetByOfferinSubtype(HealthCardEPCRemaining[] list, int fieldID)
{
for (int i = 0; i < list.Length; i++)
if (list[i].Field.ID == fieldID)
return list[i];
return null;
}
