//search and paging public ActionResult Search(string keyword, int page = 1, int pageSize = 2) { var productView = new ProductViewHome(); int totalRecord = 0; //get list pet toy sale off ViewBag.viewPetToySaleOff = productView.getViewPeTToySaleOff(); //get list search var allPettoy = new PetToyModel().Search(keyword, ref totalRecord, page, pageSize); ViewBag.keyword = keyword; ViewBag.Total = totalRecord; ViewBag.Page = page; int maxPage = 5;//maximum page display on website int totalPage = 0; totalPage = (int)Math.Ceiling((double)totalRecord / pageSize); ViewBag.totalPage = totalPage; ViewBag.maxPage = maxPage; // first page ViewBag.first = 1; //last page ViewBag.last = totalPage; //next page ViewBag.next = page + 1; //prev page ViewBag.prev = page - 1; return(View(allPettoy)); }
private void gcToys_Load(object sender, EventArgs e) { PetToyModel ptm = new PetToyModel(); petStoreDataSet2BindingSource.DataSource = ptm.GetAllPetToysToArrayList(); gcToys.DataSource = petStoreDataSet2BindingSource; }
// GET: PetToy public ActionResult Index(int page = 1, int pageSize = 4) { var productView = new ProductViewHome(); int totalRecord = 0; // get list sale off pet toy ViewBag.viewPetToySaleOff = productView.getViewPeTToySaleOff(); var allPettoy = new PetToyModel().getAllPetToys(ref totalRecord, page, pageSize); ViewBag.Total = totalRecord; ViewBag.Page = page; int maxPage = 5;//maximum page link display on website int totalPage = 0; //caculator total page totalPage = (int)Math.Ceiling((double)totalRecord / pageSize); ViewBag.totalPage = totalPage; ViewBag.maxPage = maxPage; // first page ViewBag.first = 1; //last page ViewBag.last = totalPage; //next page ViewBag.next = page + 1; //prev page ViewBag.prev = page - 1; return(View(allPettoy)); }
private void btnrefresh_ItemClick(object sender, ItemClickEventArgs e) { PetToyModel ptm = new PetToyModel(); petStoreDataSet2BindingSource.DataSource = ptm.GetAllPetToysToArrayList(); gcToys.DataSource = petStoreDataSet2BindingSource; }
//detail pet toy page public ActionResult Detail(String ptID) { var petToy = new PetToyModel(); //get pet detail var pettoyDetail = petToy.getPetToyByID(ptID); //get list relative pet medicine ViewBag.relatedPetToy = petToy.getPetToyRelated(pettoyDetail.pt_id); ViewBag.pettoyDetail = pettoyDetail; return(View()); }
private void bbiRestore_ItemClick(object sender, ItemClickEventArgs e) { if (ptIDSelected != "") { PetToyModel ptm = new PetToyModel(); ptm.RestorePetToys(ptIDSelected); XtraMessageBox.Show("Restore successful !!!", "Successful", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { XtraMessageBox.Show("Please choose Toys item to restore !!!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
//get path of image, just accept image file private void pt_imageTextEdit_Properties_Click(object sender, EventArgs e) { openDialog.Filter = "Image files (*.jpg)|*.jpg|Image files (*.png)|*.png|All files (*.*)|*.*"; openDialog.ShowDialog(); if (openDialog.FileName != "" && (openDialog.FileName.EndsWith(".jpg") || openDialog.FileName.EndsWith(".png"))) { PetToyModel ptm = new PetToyModel(); if (openDialog.FileName.EndsWith(".jpg")) { pt_imageTextEdit.Text = ptm.getNextID() + ".jpg"; } else { pt_imageTextEdit.Text = ptm.getNextID() + ".png"; } } else { XtraMessageBox.Show("Please choose a image with (*.jpg)/(*.png) file !!!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
private void btnDetail_ItemClick(object sender, ItemClickEventArgs e) { if (ptIDSelected != "") { DetailToys dts = new DetailToys(); PetToyModel ptm = new PetToyModel(); PetToy toy = ptm.getPetToy(ptIDSelected); dts.txtToysId.Text = toy.pt_id; dts.txtToysName.Text = toy.pt_name; dts.txtToySaleprices.Text = toy.pt_salePrice.ToString(); dts.txtAmount.Text = toy.pt_amount.ToString(); dts.txtDescript.Text = toy.pt_description; if (toy.pt_status == "Active") { dts.txtstatus.ForeColor = Color.Green; } else { dts.txtstatus.ForeColor = Color.Red; } dts.txtstatus.Text = toy.pt_status; dts.lblDetail.Text = "Pet's Toys detail for '" + toy.pt_name + "'"; String projectPath = Path.GetFullPath(Path.Combine(Application.StartupPath, "..\\..")); String pathImage = projectPath + "\\img\\" + toy.pt_image; Image img = Image.FromFile(pathImage); dts.ptbimage.Image = ptm.ResizeImage(img, 200, 200); dts.ShowDialog(); } else { MessageBox.Show("Please choose a Toys to view detail !!!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
private void pt_idTextEdit_Properties_Click(object sender, EventArgs e) { PetToyModel ptm = new PetToyModel(); pt_idTextEdit.Text = ptm.getNextID(); }
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(); } }
private void barButtonItem1_ItemClick(object sender, ItemClickEventArgs e) { 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; } } } DetailBill dbf = new DetailBill(); dbf.grvDetail.DataSource = dt; dbf.ShowDialog(this); }