private void LoadList(int id)
{
ArrayList al = DBLayer.ChargeGroup.GetList();
for (int i = 0; i < al.Count; i++)
{
DBLayer.ChargeGroup.Details det = (DBLayer.ChargeGroup.Details)al[i];
Lib.ServiceFunctions.ListItem li = new FitnessProject.Lib.ServiceFunctions.ListItem();
li.ID = det.Id;
li.Name = det.Name;
cbChargesGroup.Items.Add(li);
}
if (id != 0)
{
for (int i = 0; i < cbChargesGroup.Items.Count; i++)
{
Lib.ServiceFunctions.ListItem li = (Lib.ServiceFunctions.ListItem)cbChargesGroup.Items[i];
if (li.ID == id)
{
cbChargesGroup.SelectedIndex = i;
break;
}
}
}
}
public FrmEditChargeGroup(int id)
{
InitializeComponent();
this.Id = id;
this.Details = DBLayer.ChargeGroup.GetDetails(id);
tbName.Text = this.Details.Name;
}
private void LoadData()
{
ArrayList al = DBLayer.ChargeGroup.GetList();
DataTable dt = new DataTable();
dt.Columns.Add("Id", typeof(int));
dt.Columns.Add("Name");
for (int i = 0; i < al.Count; i++)
{
DBLayer.ChargeGroup.Details det = (DBLayer.ChargeGroup.Details)al[i];
DataRow dr = dt.Rows.Add();
dr["Id"] = det.Id;
dr["Name"] = det.Name;
}
grSources.DataSource = dt;
}
public static ArrayList GetList()
{
DataTable dt = ZFort.DB.Execute.ExecuteString_DataTable("SELECT * FROM ChargeGroup WHERE IsPrimary = 0");
ArrayList al = new ArrayList();
foreach (DataRow dr in dt.Rows)
{
DBLayer.ChargeGroup.Details det = new DBLayer.ChargeGroup.Details();
if (!dr.IsNull("Id"))
{
det.Id = Convert.ToInt32(dr["Id"]);
}
det.Name = dr["Name"].ToString();
al.Add(det);
}
return(al);
}
