private void LoadData()
{
ArrayList al = DBLayer.Services.GetList();
DataTable dt = new DataTable();
dt.Columns.Add("Id", typeof(int));
dt.Columns.Add("Name");
dt.Columns.Add("Dimension");
dt.Columns.Add("CostPerUnit", typeof(double));
dt.Columns.Add("Type");
for (int i = 0; i < al.Count; i++)
{
DBLayer.Services.Services_WideDetails det = (DBLayer.Services.Services_WideDetails)al[i];
DataRow dr = dt.Rows.Add();
dr["Id"] = det.Id;
dr["Name"] = det.Name;
dr["Dimension"] = det.DimensionName;
dr["CostPerUnit"] = det.CostPerUnit;
string name = string.Empty;
switch (det.Type)
{
case 0:
name = "Солярий";
break;
case 1:
name = "Массаж";
break;
case 2:
name = "Сауна";
break;
case 3:
name = "Косметология";
break;
case 4:
name = "Аренда";
break;
}
dr["Type"] = name;
}
grGoods.DataSource = dt;
}
private void LoadServices()
{
ArrayList al = DBLayer.Services.GetList();
for (int i = 0; i < al.Count; i++)
{
DBLayer.Services.Services_WideDetails det = (DBLayer.Services.Services_WideDetails)al[i];
Lib.ServiceFunctions.ListItem liP = new FitnessProject.Lib.ServiceFunctions.ListItem();
liP.ID = det.Id;
liP.Name = det.Name;
cbProduct.Items.Add(liP);
}
}
public static ArrayList GetList()
{
string sql = "SELECT s.[Name], s.[Id], s.DimensionId, d.[Name] AS Dimension, s.CostPerUnit, s.[Type] ";
sql += " FROM Services AS s ";
sql += " INNER JOIN Dimensions AS d ON d.[Id] = s.[DimensionId] ";
DataTable dt = ZFort.DB.Execute.ExecuteString_DataTable(sql);
ArrayList al = new ArrayList();
foreach (DataRow dr in dt.Rows)
{
DBLayer.Services.Services_WideDetails det = new DBLayer.Services.Services_WideDetails();
if (!dr.IsNull("Id"))
{
det.Id = Convert.ToInt32(dr["Id"]);
}
det.Name = dr["Name"].ToString();
if (!dr.IsNull("CostPerUnit"))
{
det.CostPerUnit = Convert.ToDouble(dr["CostPerUnit"]);
}
if (!dr.IsNull("DimensionId"))
{
det.DimensionId = Convert.ToInt32(dr["DimensionId"]);
}
det.DimensionName = dr["Dimension"].ToString();
if (!dr.IsNull("Type"))
{
det.Type = Convert.ToInt32(dr["Type"]);
}
al.Add(det);
}
return(al);
}
