private void bbiPrint_ItemClick(object sender, ItemClickEventArgs e)
{
int id;
GridControl gc = new GridControl();
gc.DataSource = dataGridView1.DataSource;
BillReport report = new BillReport();
report.Parameters["pGuest"].Value = txtGuest.Text;
report.Parameters["pAddress"].Value = txtAddress.Text;
report.Parameters["pDate"].Value = System.DateTime.Now;
report.Parameters["pTotal"].Value = total;
report.Parameters["pGift"].Value = cbbGift.SelectedItem;
using (var db = new PetStoreEntities())
{
var bill = new Bill();
bill.b_purchaseDate = System.DateTime.Now;
bill.b_address = txtAddress.Text;
bill.b_total = total;
bill.guest = txtGuest.Text;
bill.u_id = 24;
bill.g_id = cbbGift.SelectedValue.ToString();
db.Bills.Add(bill);
db.SaveChanges();
id = db.Bills.Last().b_id;
int d = 0;
foreach (var bd in list)
{
var billDetail = new BillDetail();
billDetail.b_id = id;
if (bd.StartsWith("PET"))
{
billDetail.p_id = bd;
}
else if (bd.StartsWith("PTS"))
{
billDetail.pt_id = bd;
}
else if (bd.StartsWith("PFD"))
{
billDetail.pf_id = bd;
}
else if (bd.StartsWith("PAS"))
{
billDetail.pa_id = bd;
}
else if (bd.StartsWith("PMD"))
{
billDetail.pm_id = bd;
}
billDetail.quantity = int.Parse(dataGridView1.Rows[d].Cells["Quantity"].Value.ToString());
db.BillDetails.Add(billDetail);
db.SaveChanges();
d++;
}
}
report.Parameters["pID"].Value = id;
report.GridControl = gc;
ReportPrintTool printTool = new ReportPrintTool(report);
printTool.ShowPreviewDialog();
resetTable();
}
private void bbiPrint_ItemClick(object sender, ItemClickEventArgs e)
{
if (txtGuest.Text.Equals(""))
{
MessageBox.Show("Please input guest name!", "Message");
}
else if (txtAddress.Text.Equals(""))
{
MessageBox.Show("Please input address!", "Message");
}
else
{
int id;
GridControl gc = new GridControl();
gc.DataSource = dataGridView1.DataSource;
BillReport report = new BillReport();
report.Parameters["pGuest"].Value = txtGuest.Text;
report.Parameters["pAddress"].Value = txtAddress.Text;
report.Parameters["pDate"].Value = System.DateTime.Now;
report.Parameters["pTotal"].Value = total;
report.Parameters["pGift"].Value = cbbGift.Text;
using (var db = new PetStoreEntities())
{
var bill = new Bill();
bill.b_purchaseDate = System.DateTime.Now;
bill.b_address = txtAddress.Text;
bill.b_total = total;
bill.u_id = 24;
bill.g_id = cbbGift.SelectedValue.ToString();
bill.b_status = "Active";
db.Bills.Add(bill);
db.SaveChanges();
}
using (var db = new PetStoreEntities())
{
var bill = from s in db.Bills orderby s.b_id descending select s;
id = 0;
foreach (var b in bill)
{
id = b.b_id;
break;
}
int index = 0;
foreach (var bd in list)
{
var billDetail = new BillDetail();
billDetail.b_id = id;
if (bd.StartsWith("PET"))
{
billDetail.p_id = bd;
}
else if (bd.StartsWith("PTS"))
{
billDetail.pt_id = bd;
}
else if (bd.StartsWith("PFD"))
{
billDetail.pf_id = bd;
}
else if (bd.StartsWith("PAS"))
{
billDetail.pa_id = bd;
}
else if (bd.StartsWith("PMD"))
{
billDetail.pm_id = bd;
}
int qty = int.Parse(dataGridView1.Rows[index].Cells["Quantity"].Value.ToString());
for (int i = 0; i < qty; i++)
{
db.BillDetails.Add(billDetail);
db.SaveChanges();
}
index++;
}
}
report.Parameters["pID"].Value = id;
report.GridControl = gc;
ReportPrintTool printTool = new ReportPrintTool(report);
printTool.AutoShowParametersPanel = true;
printTool.ShowPreviewDialog();
resetTable();
}
}
private void bbiAccept_ItemClick(object sender, ItemClickEventArgs e)
{
if (selectedID != -1)
{
Bill bill;
UserModel um = new UserModel();
using (var db = new PetStoreEntities())
{
var u = db.Bills.Find(selectedID);
bill = u;
u.b_status = "Acitve";
db.SaveChanges();
}
DataGridView grvPrint = new DataGridView();
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("Name", typeof(string)));
dt.Columns.Add(new DataColumn("Price", typeof(int)));
dt.Columns.Add(new DataColumn("Quantity", typeof(int)));
using (var db = new PetStoreEntities())
{
var list = db.BillDetails.Where(x => x.b_id == selectedID);
PetModel pm = new PetModel();
PetFoodModel pfm = new PetFoodModel();
PetMedicineModel pmm = new PetMedicineModel();
PetToyModel ptm = new PetToyModel();
PetAccessoryModel pam = new PetAccessoryModel();
int d = 0;
while (d != list.Count())
{
var bd = list.ToList()[d];
if (bd.p_id != null)
{
var p = pm.getPet(bd.p_id);
var qty = list.Where(x => x.p_id == bd.p_id).Count();
dt.Rows.Add(p.p_name, p.p_salePrice, qty);
d += qty;
}
else if (bd.pt_id != null)
{
var pt = ptm.getPetToy(bd.pt_id);
var qty = list.Where(x => x.pt_id == bd.pt_id).Count();
dt.Rows.Add(pt.pt_name, pt.pt_salePrice, qty);
d += qty;
}
else if (bd.pf_id != null)
{
var pf = pfm.getPetFood(bd.pf_id);
var qty = list.Where(x => x.pf_id == bd.pf_id).Count();
dt.Rows.Add(pf.pf_name, pf.pf_salePrice, qty);
d += qty;
}
else if (bd.pm_id != null)
{
var pmd = pmm.getPetMedicine(bd.pm_id);
var qty = list.Where(x => x.pm_id == bd.pm_id).Count();
dt.Rows.Add(pmd.pm_name, pmd.pm_salePrice, qty);
d += qty;
}
else if (bd.pa_id != null)
{
var pa = pam.getPetAccessory(bd.pa_id);
var qty = list.Where(x => x.pa_id == bd.pa_id).Count();
dt.Rows.Add(pa.pa_name, pa.pa_salePrice, qty);
d += qty;
}
}
}
grvPrint.DataSource = dt;
GridControl gc = new GridControl();
gc.DataSource = grvPrint.DataSource;
BillReport report = new BillReport();
report.Parameters["pGuest"].Value = um.getUName(bill.u_id);
report.Parameters["pAddress"].Value = bill.b_address;
report.Parameters["pDate"].Value = bill.b_purchaseDate;
report.Parameters["pTotal"].Value = bill.b_total;
report.Parameters["pID"].Value = bill.b_id;
SelectGift sg = new SelectGift();
sg.ShowDialog(this);
report.Parameters["pGift"].Value = sg.cbbGift.Text;
report.GridControl = gc;
ReportPrintTool printTool = new ReportPrintTool(report);
printTool.AutoShowParametersPanel = true;
printTool.ShowPreviewDialog();
load();
}
}
