private void LoadData(DataClassesDatabaseDataContext db)
{
Meja_Class Meja_Class = new Meja_Class();
var ListMeja = db.TBMejas
.Where(item => item.IDMeja > 2)
.Select(item => new
{
item.IDMeja,
item.Nama,
item.IDStatusMeja,
Warna = WarnaMeja(item.IDStatusMeja.Value),
item.VIP,
item.Status,
}).ToArray();
var MejaReguler = ListMeja.Where(item => item.VIP == false);
if (MejaReguler.Count() > 0)
{
int barisReguler = (int)Math.Ceiling((double)MejaReguler.Count() / 10);
int[] resultReguler = new int[barisReguler];
for (int i = 0; i < barisReguler; i++)
{
resultReguler[i] = i + 1;
}
RepeaterReguler.DataSource = resultReguler.Select(item => new
{
baris = MejaReguler.Skip((item * 10) - 10).Take(10)
});
RepeaterReguler.DataBind();
}
var MejaVIP = ListMeja.Where(item => item.VIP == true);
if (MejaVIP.Count() > 0)
{
int barisVIP = (int)Math.Ceiling((double)MejaReguler.Count() / 5);
int[] resultVIP = new int[barisVIP];
for (int i = 0; i < barisVIP; i++)
{
resultVIP[i] = i + 1;
}
RepeaterVIP.DataSource = resultVIP.Select(item => new
{
baris = MejaVIP.Skip((item * 5) - 5).Take(5)
});
RepeaterVIP.DataBind();
}
}
private void LoadMeja(DataClassesDatabaseDataContext db)
{
var ListMeja = db.TBMejas
.Where(item => item.IDMeja > 2)
.Select(item => new
{
item.IDMeja,
item.Nama,
item.IDStatusMeja,
Warna = WarnaMeja(item.IDStatusMeja.Value),
item.VIP,
item.Status,
}).ToArray();
var MejaReguler = ListMeja.Where(item => item.VIP == false);
if (MejaReguler.Count() > 0)
{
int barisReguler = (int)Math.Ceiling((double)MejaReguler.Count() / 10);
int[] resultReguler = new int[barisReguler];
for (int i = 0; i < barisReguler; i++)
{
resultReguler[i] = i + 1;
}
RepeaterReguler.DataSource = resultReguler.Select(item => new
{
baris = MejaReguler.Skip((item * 10) - 10).Take(10)
});
RepeaterReguler.DataBind();
}
var MejaVIP = ListMeja.Where(item => item.VIP == true);
if (MejaVIP.Count() > 0)
{
int barisVIP = (int)Math.Ceiling((double)MejaReguler.Count() / 5);
int[] resultVIP = new int[barisVIP];
for (int i = 0; i < barisVIP; i++)
{
resultVIP[i] = i + 1;
}
RepeaterVIP.DataSource = resultVIP.Select(item => new
{
baris = MejaVIP.Skip((item * 5) - 5).Take(5)
});
RepeaterVIP.DataBind();
}
//TRANSAKSI TANPA MEJA
RepeaterTransaksi.DataSource = db.TBTransaksis
.Where(item => (item.IDMeja == 1 || item.IDMeja == 2) && item.IDStatusTransaksi == 2)
.Select(item => new
{
item.IDTransaksi,
Keterangan = item.Keterangan.ToString() + " " + item.IDTransaksi,
item.TanggalTransaksi
})
.OrderByDescending(item => item.TanggalTransaksi);
RepeaterTransaksi.DataBind();
}
