// reload data private void btnRefresh_ItemClick(object sender, ItemClickEventArgs e) { PetMedicineModel pmm = new PetMedicineModel(); petStoreDataSet3BindingSource.DataSource = pmm.GetAllPetMedicineToArrayList(); gcMedicine.DataSource = petStoreDataSet3BindingSource; }
//load data private void PetMedicineStaff_Load(object sender, EventArgs e) { PetMedicineModel pmm = new PetMedicineModel(); medicinedataBindingSource.DataSource = pmm.GetAllPetMedicineToArrayList(); gcMedicine.DataSource = medicinedataBindingSource; }
//load data to grid view private void PetMedicineView_Load(object sender, EventArgs e) { PetMedicineModel pmm = new PetMedicineModel(); pm_idTextEdit.Text = pmm.getNextID(); pm_statusTextEdit.SelectedItem = "Active"; }
//search and paging public ActionResult Search(string keyword, int page = 1, int pageSize = 2) { var productView = new ProductViewHome(); int totalRecord = 0; //get list pet medcine sale off ViewBag.viewPetMedicineSaleOff = productView.getViewPetMedicineSaleOff(); //get list search var allPetmedicine = new PetMedicineModel().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(allPetmedicine)); }
// GET: PetMedicine public ActionResult Index(int page = 1, int pageSize = 4) { var productView = new ProductViewHome(); int totalRecord = 0; // get list sale off pet medicine ViewBag.viewPetMedicineSaleOff = productView.getViewPetMedicineSaleOff(); var allPetmedicine = new PetMedicineModel().getAllPetMedicine(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(allPetmedicine)); }
private void barButtonItem2_ItemClick(object sender, ItemClickEventArgs e) { PetMedicineModel pmm = new PetMedicineModel(); petStoreDataSet3BindingSource.DataSource = pmm.GetAllPetMedicineToArrayList(); gridControl1.DataSource = petStoreDataSet3BindingSource; }
private void pm_imageTextEdit_Properties_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e) { OpenFileDialog openDialog = new OpenFileDialog(); 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"))) { PetMedicineModel pmm = new PetMedicineModel(); if (openDialog.FileName.EndsWith(".jpg")) { pm_imageTextEdit.Text = pmm.getNextID() + ".jpg"; } else { pm_imageTextEdit.Text = pmm.getNextID() + ".png"; } } else { XtraMessageBox.Show("Please choose a image with (*.jpg)/(*.png) file !!!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); } String fileName = openDialog.FileName; pm_imageTextEdit.Text = fileName; PictureBox ptbPetMedi = new PictureBox();//tạo 1 cái picturebox mới string filepath = fileName; ptbPetMedi.Image = Image.FromFile(filepath.ToString());//gán cái hình ảnh cho cái picturebox mới đó // objpt.SizeMode = PictureBoxSizeMode.AutoSize; }
private void gridView_RowClick(object sender, RowClickEventArgs e) { PetMedicineModel pmm = new PetMedicineModel(); int idx = gridView.FocusedRowHandle; pmId_selected = gridView.GetRowCellValue(idx, "pm_id").ToString(); // ptbPetMedicines.Image = Image.FromFile(GetImage.); }
//detail pet medicine page public ActionResult Detail(String pmID) { var petMedicine = new PetMedicineModel(); //get pet detail var petmedicineDetail = petMedicine.getPetMedicineByID(pmID); //get list relative pet medicine ViewBag.relatedPetMedicine = petMedicine.getPetMedicineRelated(petmedicineDetail.pm_id); ViewBag.petmedicineDetail = petmedicineDetail; return(View()); }
private void bbiRestore_ItemClick(object sender, ItemClickEventArgs e) { if (pmId_selected != "") { PetMedicineModel pmm = new PetMedicineModel(); pmm.RestorePetMedicine(pmId_selected); XtraMessageBox.Show("Restore successful !!!", "Successful", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { XtraMessageBox.Show("Please choose a Accessories item to delete !!!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
//get path for image Text box, just accept image file private void pm_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"))) { PetMedicineModel pmm = new PetMedicineModel(); if (openDialog.FileName.EndsWith(".jpg")) { pm_imageTextEdit.Text = pmm.getNextID() + ".jpg"; } else { pm_imageTextEdit.Text = pmm.getNextID() + ".png"; } } else { XtraMessageBox.Show("Please choose a image with (*.jpg)/(*.png) file !!!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
/// <summary> /// get list name of pet toy have keyword search /// </summary> /// <param name="term"></param> /// <returns></returns> public JsonResult ListName(string term) { if (term != "") //check have enter input search { //get list name var data = new PetMedicineModel().ListName(term); return(Json(new { data = data, status = true }, JsonRequestBehavior.AllowGet)); } else //input search is empty { return(Json(new { data = "", status = true }, JsonRequestBehavior.AllowGet)); } }
//button detail to show datail product private void btnDetail_ItemClick(object sender, ItemClickEventArgs e) { if (pmIDSelected != "") { DetailMedicine dmd = new DetailMedicine(); PetMedicineModel pmm = new PetMedicineModel(); PetMedicine med = pmm.getPetMedicine(pmIDSelected); dmd.txtPmdId.Text = med.pm_id; dmd.txtPmdName.Text = med.pm_name; dmd.txtPmdSaleprices.Text = med.pm_salePrice.ToString(); dmd.txtPmdAmount.Text = med.pm_amount.ToString(); dmd.txtPmdDescript.Text = med.pm_description; if (med.pm_status == "Active") { dmd.txtPmdStatus.ForeColor = Color.Green; } else { dmd.txtPmdStatus.ForeColor = Color.Red; } dmd.txtPmdStatus.Text = med.pm_status; dmd.lbldetail.Text = "Pet's Medicine detail for '" + med.pm_name + "'"; String projectPath = Path.GetFullPath(Path.Combine(Application.StartupPath, "..\\..")); String pathImage = projectPath + "\\img\\" + med.pm_image; Image img = Image.FromFile(pathImage); dmd.ptbimage.Image = pmm.ResizeImage(img, 200, 200); dmd.ShowDialog(); } else { MessageBox.Show("Please choose a Medicine to view detail !!!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
private void pm_idTextEdit_Properties_Click(object sender, EventArgs e) { PetMedicineModel pmm = new PetMedicineModel(); pm_idTextEdit.Text = pmm.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); }