private void LoadAbonements(int id)
{
cbAbonement.Items.Clear();
ArrayList al = DBLayer.Abonements.GetList();
for (int i = 0; i < al.Count; i++)
{
DBLayer.Abonements.WideDetails det = (DBLayer.Abonements.WideDetails)al[i];
Lib.ServiceFunctions.ListItem li = new FitnessProject.Lib.ServiceFunctions.ListItem();
li.ID = det.Id;
li.Name = det.Name;
if (rbFitness.Checked)
{
if (det.AbonementGroup == 0)
{
cbAbonement.Items.Add(li);
}
}
else
{
if (det.AbonementGroup == 1)
{
cbAbonement.Items.Add(li);
}
}
}
for (int i = 0; i < cbAbonement.Items.Count; i++)
{
Lib.ServiceFunctions.ListItem li = (Lib.ServiceFunctions.ListItem)cbAbonement.Items[i];
if (li.ID == id)
{
cbAbonement.SelectedIndex = i;
break;
}
}
}
private void LoadAbonements(string name = "")
{
lvAbonements.Items.Clear();
var al = DBLayer.Abonements.GetList();
if (!string.IsNullOrEmpty(name))
{
al = al.Where(a => a.Name.ToLower().Contains(name.ToLower())).ToList();
}
for (int i = 0; i < al.Count; i++)
{
DBLayer.Abonements.WideDetails det = (DBLayer.Abonements.WideDetails)al[i];
ListViewItem li = new ListViewItem();
li.Tag = det.Id;
li.Text = det.Name;
if (rbFitness.Checked)
{
if (det.AbonementGroup == 0)
{
lvAbonements.Items.Add(li);
}
}
else
{
if (det.AbonementGroup == 1)
{
lvAbonements.Items.Add(li);
}
}
}
}
public static List <DBLayer.Abonements.WideDetails> GetList()
{
string sql = "SELECT a.*, c.[Name] AS CoachName FROM Abonements AS a LEFT JOIN Coaches AS c ON c.Id = a.CoachId WHERE IsDeleted = 0";
DataTable dt = ZFort.DB.Execute.ExecuteString_DataTable(sql);
var al = new List <DBLayer.Abonements.WideDetails>();
foreach (DataRow dr in dt.Rows)
{
DBLayer.Abonements.WideDetails det = new DBLayer.Abonements.WideDetails();
if (!dr.IsNull("Id"))
{
det.Id = Convert.ToInt32(dr["Id"]);
}
det.Name = dr["Name"].ToString();
if (!dr.IsNull("Cost"))
{
det.Cost = Convert.ToDouble(dr["Cost"]);
}
if (!dr.IsNull("Length"))
{
det.Length = Convert.ToDouble(dr["Length"]);
}
if (!dr.IsNull("AbonementGroup"))
{
det.AbonementGroup = Convert.ToInt32(dr["AbonementGroup"]);
}
if (!dr.IsNull("LessonsCount"))
{
det.LessonsCount = Convert.ToInt32(dr["LessonsCount"]);
}
if (!dr.IsNull("IsSingle"))
{
det.IsSingle = Convert.ToBoolean(dr["IsSingle"]);
}
if (!dr.IsNull("CoachId"))
{
det.CoachId = Convert.ToInt32(dr["CoachId"]);
}
if (!dr.IsNull("AdditionalVisits"))
{
det.AdditionalVisits = Convert.ToInt32(dr["AdditionalVisits"]);
}
if (!dr.IsNull("IsUnlim"))
{
det.IsUnlim = Convert.ToBoolean(dr["IsUnlim"]);
}
if (!dr.IsNull("IsSpecial"))
{
det.IsSpecial = Convert.ToBoolean(dr["IsSpecial"]);
}
det.Time = dr["Time"].ToString();
det.CoachName = dr["CoachName"].ToString();
det.Weekdays = dr["Weekdays"].ToString();
al.Add(det);
}
return(al);
}
private void LoadData()
{
var al = DBLayer.Abonements.GetList();
DataTable dt = new DataTable();
dt.Columns.Add("Id", typeof(int));
dt.Columns.Add("Name");
dt.Columns.Add("Length", typeof(double));
dt.Columns.Add("Cost", typeof(double));
dt.Columns.Add("Type");
dt.Columns.Add("LessonsCount", typeof(int));
dt.Columns.Add("AdditionalVisits", typeof(int));
dt.Columns.Add("Single");
dt.Columns.Add("CoachName");
dt.Columns.Add("Unlim");
dt.Columns.Add("IsSpecial");
dt.Columns.Add("Time");
dt.Columns.Add("Weekdays");
for (int i = 0; i < al.Count; i++)
{
DBLayer.Abonements.WideDetails det = (DBLayer.Abonements.WideDetails)al[i];
DataRow dr = dt.Rows.Add();
dr["Id"] = det.Id;
dr["Name"] = det.Name;
dr["Length"] = det.Length;
dr["Cost"] = det.Cost;
dr["Weekdays"] = det.Weekdays;
if (det.AbonementGroup == 0)
{
dr["Type"] = "Тренажерный зал";
}
else
{
dr["Type"] = "Аэробный зал";
}
if (det.LessonsCount > 0)
{
dr["LessonsCount"] = det.LessonsCount;
}
if (det.IsSingle)
{
dr["Single"] = "Разовый";
}
if (det.IsUnlim)
{
dr["Unlim"] = "Безлимитный";
}
if (det.IsSpecial)
{
dr["IsSpecial"] = "Да";
}
dr["CoachName"] = det.CoachName;
dr["Time"] = det.Time;
dr["AdditionalVisits"] = det.AdditionalVisits;
}
grSources.DataSource = dt;
advBandedGridView1.BestFitColumns();
}
