// 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);
}
