private void LoadSources(int id)
{
ArrayList al = DBLayer.AdvertisingSource.GetList();
for (int i = 0; i < al.Count; i++)
{
DBLayer.AdvertisingSource.Details det = (DBLayer.AdvertisingSource.Details)al[i];
Lib.ServiceFunctions.ListItem li = new FitnessProject.Lib.ServiceFunctions.ListItem();
li.ID = det.Id;
li.Name = det.Name;
cbSource.Items.Add(li);
}
for (int i = 0; i < cbSource.Items.Count; i++)
{
Lib.ServiceFunctions.ListItem li = (Lib.ServiceFunctions.ListItem)cbSource.Items[i];
if (li.ID == id)
{
cbSource.SelectedIndex = i;
break;
}
}
}
public FrmEditAdvertisingSource(int id)
{
InitializeComponent();
this.Id = id;
this.Details = DBLayer.AdvertisingSource.GetDetails(id);
tbName.Text = this.Details.Name;
}
private void LoadData()
{
ArrayList al = DBLayer.AdvertisingSource.GetList();
DataTable dt = new DataTable();
dt.Columns.Add("Id", typeof(int));
dt.Columns.Add("Name");
for (int i = 0; i < al.Count; i++)
{
DBLayer.AdvertisingSource.Details det = (DBLayer.AdvertisingSource.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 AdvertisingSource");
ArrayList al = new ArrayList();
foreach (DataRow dr in dt.Rows)
{
DBLayer.AdvertisingSource.Details det = new DBLayer.AdvertisingSource.Details();
if (!dr.IsNull("Id"))
{
det.Id = Convert.ToInt32(dr["Id"]);
}
det.Name = dr["Name"].ToString();
al.Add(det);
}
return(al);
}
public static void Update(DBLayer.AdvertisingSource.Details det)
{
ZFort.DB.Execute.ExecuteString_void("UPDATE AdvertisingSource SET [Name] = '" + det.Name + "' WHERE [Id] = " + det.Id.ToString());
}
/*#region Check
*
* public static bool Check(string name, int id)
* {
*
* Database.Service serv = new Management.Database.Service();
*
* return serv.AdvertisingSource_Check(name, id);
* }
*
#endregion*/
#region Insert
public static void Insert(DBLayer.AdvertisingSource.Details det)
{
ZFort.DB.Execute.ExecuteString_void("INSERT INTO AdvertisingSource ([Name]) VALUES ('" + det.Name + "')");
}
