public ActionResult Detail(String pfID)
{
var petfoodDetail = new PetFoodModel().getPetFoodByID(pfID);
ViewBag.relatedPetFood = new PetFoodModel().getPetFoodRelated(petfoodDetail.pf_id);
return(View(petfoodDetail));
}
private void btnViewDetail_ItemClick(object sender, ItemClickEventArgs e)
{
if (IDSelected != "")
{
DetailPetFoodForm vdf = new DetailPetFoodForm();
PetFoodModel pfm = new PetFoodModel();
PetFood f = pfm.getPetFood(IDSelected);
vdf.te_pfID.Text = f.pf_id;
vdf.te_pfName.Text = f.pf_name;
vdf.te_pfPriceSale.Text = f.pf_salePrice.ToString();
vdf.te_pfAmount.Text = f.pf_amount.ToString();
vdf.te_Type.Text = "Pet's Food";
if (f.pf_status == "Active")
{
vdf.te_pfStatus.ForeColor = Color.Green;
}
else
{
vdf.te_pfStatus.ForeColor = Color.Red;
}
vdf.te_pfStatus.Text = f.pf_status;
vdf.te_pfPrice.Enabled = false;
vdf.lblTitle.Text = "Pet's Food detail for '" + f.pf_name + "'";
String projectPath = Path.GetFullPath(Path.Combine(Application.StartupPath, "..\\.."));
String pathImage = projectPath + "\\img\\" + f.pf_image;
Image img = Image.FromFile(pathImage);
vdf.ptbImage.Image = pfm.ResizeImage(img, 440, 440);
vdf.ShowDialog();
}
else
{
MessageBox.Show("Please choose a food to view detail !!!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public PartialViewResult HeaderCart()
{
var cart = Session[cartSession];
var list = new List <CartItem>();
var listCartPetFood = new List <CartPetFoodItem>();
var listCartPet = new List <CartPetItem>();
var listCartPetToy = new List <CartPetToyItem>();
var listCartPetMedicine = new List <CartPetMedicineItem>();
if (cart != null)
{
list = (List <CartItem>)cart;
PetFoodModel pfm = new PetFoodModel();
foreach (var item in list)
{
//product is pet's food
if (item.productID.StartsWith("PFD"))
{
PetFood pf = pfm.getPetFoodByID(item.productID);
CartPetFoodItem cpfi = new CartPetFoodItem();
cpfi.Petfood = pf;
cpfi.Quantity = item.Quantity;
listCartPetFood.Add(cpfi);
}
//product is pet
else if (item.productID.StartsWith("PET"))
{
Pet p = pfm.getPetByID(item.productID);
CartPetItem cpi = new CartPetItem();
cpi.pet = p;
cpi.Quantity = item.Quantity;
listCartPet.Add(cpi);
}
//product os pet's medicine
else if (item.productID.StartsWith("PMD"))
{
PetMedicine pm = pfm.getPetMedicineByID(item.productID);
CartPetMedicineItem cpmi = new CartPetMedicineItem();
cpmi.petMedicine = pm;
cpmi.Quantity = item.Quantity;
listCartPetMedicine.Add(cpmi);
}
//Product is Pet's toys
else
{
PetToys pt = pfm.getPetToyByID(item.productID);
CartPetToyItem cpti = new CartPetToyItem();
cpti.petToy = pt;
cpti.Quantity = item.Quantity;
listCartPetToy.Add(cpti);
}
}
ViewBag.listCartP = listCartPet;
ViewBag.listCartPT = listCartPetToy;
ViewBag.listCartPM = listCartPetMedicine;
ViewBag.ListItem = list;
}
return(PartialView(listCartPetFood));
}
// GET: PetFood
public ActionResult Index(int page = 1, int pageSize = 12)
{
var productView = new ProductViewHome();
int totalRecord = 0;
// get list sale off pet food
ViewBag.viewPetFoodSaleOff = productView.getViewPetFoodSaleOff();
var allPetfood = new PetFoodModel().getAllPetFood(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(allPetfood));
}
//search and paging
public ActionResult Search(string keyword, int page = 1, int pageSize = 2)
{
var productView = new ProductViewHome();
int totalRecord = 0;
//get list pet food sale off
ViewBag.viewPetFoodSaleOff = productView.getViewPetFoodSaleOff();
//get list search
var allPetfood = new PetFoodModel().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(allPetfood));
}
private void PetFoodView_Load(object sender, EventArgs e)
{
PetFoodModel pfm = new PetFoodModel();
pf_idTextEdit.Text = pfm.getNextID();
pf_statusTextEdit.SelectedItem = "Active";
}
private void PetFoodStaff_Load(object sender, EventArgs e)
{
PetFoodModel pfm = new PetFoodModel();
bindingSourceFood.DataSource = pfm.GetAllPetFoodToArrayList();
gcFood.DataSource = bindingSourceFood;
}
private void pf_idTextEdit_Click(object sender, EventArgs e)
{
//get next id
PetFoodModel pfm = new PetFoodModel();
pf_idTextEdit.Text = pfm.getNextID();
//auto set status new item is Active
pf_statusTextEdit.SelectedItem = "Active";
}
//detail pet food page
public ActionResult Detail(String pfID)
{
var petFood = new PetFoodModel();
//get pet detail
var petfoodDetail = petFood.getPetFoodByID(pfID);
//get list relative pet food
ViewBag.relatedPetFood = petFood.getPetFoodRelated(petfoodDetail.pf_id);
ViewBag.petfoodDetail = petfoodDetail;
return(View());
}
private void bbiRestore_ItemClick(object sender, ItemClickEventArgs e)
{
if (pfIDSelected != "")
{
PetFoodModel pfm = new PetFoodModel();
pfm.RestorePetFood(pfIDSelected);
XtraMessageBox.Show("Restore successful !!!", "Successful", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
XtraMessageBox.Show("Please choose a food item to restore !!!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void bbiDelete_ItemClick(object sender, ItemClickEventArgs e)
{
if (pfIDSelected != "")
{
PetFoodModel pfm = new PetFoodModel();
//set status item selected to Inactive
pfm.DeletePetFood(pfIDSelected);
XtraMessageBox.Show("Delete successful !!!", "Successful", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
XtraMessageBox.Show("Please choose a food item to delete !!!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void btnDetail_ItemClick(object sender, ItemClickEventArgs e)
{
if (pfIDSelected != "")
{
//declare
DetailPetFoodForm vdf = new DetailPetFoodForm();
PetFoodModel pfm = new PetFoodModel();
var db = new PetStoreEntities();
PetFood f = db.PetFoods.Find(pfIDSelected);
var type = db.Types.Find(f.t_id);
//set data to Detail pet food form
vdf.te_pfID.Text = f.pf_id;
vdf.te_pfName.Text = f.pf_name;
vdf.te_pfPriceSale.Text = f.pf_salePrice.ToString();
vdf.te_pfAmount.Text = f.pf_amount.ToString();
vdf.te_Type.Text = type.t_name;
//change text color with status
if (f.pf_status == "Active")
{
vdf.te_pfStatus.ForeColor = Color.Green;
}
else
{
vdf.te_pfStatus.ForeColor = Color.Red;
}
//set data to detail form
vdf.te_pfStatus.Text = f.pf_status;
vdf.te_pfPrice.Enabled = true;
vdf.te_pfPrice.Text = f.pf_prices.ToString();
vdf.lblTitle.Text = f.pf_name;
//get image of item
String projectPath = Path.GetFullPath(Path.Combine(Application.StartupPath, "..\\.."));
String pathImage = projectPath + "\\img\\" + f.pf_image;
Image img = Image.FromFile(pathImage);
//Resize image 440x440 and set to picture box
vdf.ptbImage.Image = pfm.ResizeImage(img, 440, 440);
//show detail form
vdf.ShowDialog();
}
else
{
MessageBox.Show("Please choose a food to view detail !!!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void btnSaveEdit_ItemClick(object sender, ItemClickEventArgs e)
{
if (te_FoodName.Text != "" && te_FoodAmount.Text != "" &&
te_FoodPrice.Text != "" && te_FoodSalePrice.Text != "")
{
PetFoodModel pfm = new PetFoodModel();
String image = "";
String oldImageName = pfm.getPetFood(te_FoodID.Text).pf_image;
if (te_FoodImage.Text != "")
{
if (openDialog.FileName.EndsWith(".jpg"))
{
image = te_FoodID.Text + ".jpg";
}
else
{
image = te_FoodID.Text + ".png";
}
String projectPath = Path.GetFullPath(Path.Combine(Application.StartupPath, "..\\.."));
String oldFilePath = projectPath + "\\img\\" + oldImageName;
FileInfo f = new FileInfo(oldFilePath);
if (f.Exists)
{
File.Delete(oldFilePath);
}
String newFilepath = Path.GetFullPath(projectPath + "\\img\\" + image);
File.Copy(te_FoodImage.Text, newFilepath);
}
else
{
image = oldImageName;
}
pfm.UpdateFood(te_FoodID.Text, te_FoodName.Text, Convert.ToInt32(te_FoodPrice.Text),
Convert.ToInt32(te_FoodSalePrice.Text), Convert.ToInt32(te_FoodAmount.Text), 2, te_FoodStatus.Text, image);
XtraMessageBox.Show("Edit successful !!!", "Congratulation", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
else
{
XtraMessageBox.Show("Please fill in full information !!!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
/// <summary>
/// get list name of pet food 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 PetFoodModel().ListName(term);
return(Json(new
{
data = data,
status = true
}, JsonRequestBehavior.AllowGet));
}
else //input search is empty
{
return(Json(new
{
data = "",
status = true
}, JsonRequestBehavior.AllowGet));
}
}
private void pf_imageTextEdit_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")))
{
PetFoodModel pfm = new PetFoodModel();
if (openDialog.FileName.EndsWith(".jpg"))
{
pf_imageTextEdit.Text = pfm.getNextID() + ".jpg";
}
else
{
pf_imageTextEdit.Text = pfm.getNextID() + ".png";
}
}
else
{
XtraMessageBox.Show("Please choose a image with (*.jpg)/(*.png) file !!!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
// GET: Cart
public ActionResult Index()
{
var cart = Session[cartSession];
var list = new List <CartItem>();
var listCartPetFood = new List <CartPetFoodItem>();
if (cart != null)
{
list = (List <CartItem>)cart;
foreach (var item in list)
{
if (item.productID.StartsWith("PFD"))
{
EF.PetFood pf = new PetFoodModel().getPetFoodByID(item.productID);
CartPetFoodItem cpfi = new CartPetFoodItem();
cpfi.Petfood = pf;
cpfi.Quantity = item.Quantity;
listCartPetFood.Add(cpfi);
}
}
}
return(View(listCartPetFood));
}
private void pf_imageTextEdit_Click(object sender, EventArgs e)
{
//set type file choose
openDialog.Filter = "Image files (*.jpg)|*.jpg|Image files (*.png)|*.png|All files (*.*)|*.*";
openDialog.ShowDialog();
//check have choose file or not and file choose must be a image file
if (openDialog.FileName != "" && (openDialog.FileName.EndsWith(".jpg") || openDialog.FileName.EndsWith(".png")))
{
PetFoodModel pfm = new PetFoodModel();
//set text box Image with ID + ".jpg" or ".png" for save to database
if (openDialog.FileName.EndsWith(".jpg"))
{
pf_imageTextEdit.Text = pfm.getNextID() + ".jpg";
}
else
{
pf_imageTextEdit.Text = pfm.getNextID() + ".png";
}
}
else
{
XtraMessageBox.Show("Please choose a image with *.jpg or *.png file !!!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void pf_idTextEdit_Click(object sender, EventArgs e)
{
PetFoodModel pfm = new PetFoodModel();
pf_idTextEdit.Text = pfm.getNextID();
}
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);
}
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 btnSaveEdit_ItemClick(object sender, ItemClickEventArgs e)
{
if (te_FoodName.Text != "" && te_FoodAmount.Text != "" &&
te_FoodPrice.Text != "" && te_FoodSalePrice.Text != "")
{
PetFoodModel pfm = new PetFoodModel();
String image = "";
String oldImageName = pfm.getPetFood(te_FoodID.Text).pf_image;
if (te_FoodImage.Text != "")
{
//set text box image = ID + ".jpg" or ".png"
if (openDialog.FileName.EndsWith(".jpg"))
{
image = te_FoodID.Text + ".jpg";
}
else
{
image = te_FoodID.Text + ".png";
}
//get path app project
String projectPath = Path.GetFullPath(Path.Combine(Application.StartupPath, "..\\.."));
//old image file path
String oldFilePath = projectPath + "\\img\\" + oldImageName;
//delete old image file if exist
FileInfo f = new FileInfo(oldFilePath);
if (f.Exists)
{
File.Delete(oldFilePath);
}
//get solution path
String solutionPath = Directory.GetParent(projectPath).FullName;;
String oldWebFilePath = solutionPath + "\\PetStoreWebClient\\Assets\\images\\" + oldImageName;
//delete old image file if exist
FileInfo f2 = new FileInfo(oldWebFilePath);
if (f2.Exists)
{
File.Delete(oldWebFilePath);
}
//Get new image file path and copy it to image folder
String newFilepath = Path.GetFullPath(projectPath + "\\img\\" + image);
String newFileWebpath = Path.GetFullPath(solutionPath + "\\PetStoreWebClient\\Assets\\images\\" + image);
File.Copy(te_FoodImage.Text, newFileWebpath);
File.Copy(te_FoodImage.Text, newFilepath);
}
else
{
//get old image if dont change image
image = oldImageName;
}
//update pet food on database
var db = new PetStoreEntities();
var typeID = (int)db.Types.FirstOrDefault(x => x.t_name == selectedType).t_id;
pfm.UpdateFood(te_FoodID.Text, te_FoodName.Text, Convert.ToInt32(te_FoodPrice.Text),
Convert.ToInt32(te_FoodSalePrice.Text), Convert.ToInt32(te_FoodAmount.Text), typeID, te_FoodStatus.Text, image);
//message success
XtraMessageBox.Show("Edit successful !!!", "Congratulation", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
else
{
XtraMessageBox.Show("Please fill in full information !!!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
// GET: Cart
public ActionResult Index()
{
//get cart
var cart = Session[cartSession];
var list = new List <CartItem>();
//constructor lists
var listCartPetFood = new List <CartPetFoodItem>();
var listCartPet = new List <CartPetItem>();
var listCartPetToy = new List <CartPetToyItem>();
var listCartPetMedicine = new List <CartPetMedicineItem>();
//cart have item
if (cart != null)
{
list = (List <CartItem>)cart;//get item in session cart
PetFoodModel pfm = new PetFoodModel();
foreach (var item in list)
{
//product is pet's food
if (item.productID.StartsWith("PFD"))
{
PetFood pf = pfm.getPetFoodByID(item.productID);
CartPetFoodItem cpfi = new CartPetFoodItem();
cpfi.Petfood = pf;
cpfi.Quantity = item.Quantity;
//add to list pet food
listCartPetFood.Add(cpfi);
}
//product is pet
if (item.productID.StartsWith("PET"))
{
Pet p = pfm.getPetByID(item.productID);
CartPetItem cpi = new CartPetItem();
cpi.pet = p;
cpi.Quantity = item.Quantity;
//add to pet list
listCartPet.Add(cpi);
}
//product os pet's medicine
if (item.productID.StartsWith("PMD"))
{
PetMedicine pm = pfm.getPetMedicineByID(item.productID);
CartPetMedicineItem cpmi = new CartPetMedicineItem();
cpmi.petMedicine = pm;
cpmi.Quantity = item.Quantity;
//add to pet medicine list
listCartPetMedicine.Add(cpmi);
}
//Product is Pet's toys
if (item.productID.StartsWith("PTS"))
{
PetToys pt = pfm.getPetToyByID(item.productID);
CartPetToyItem cpti = new CartPetToyItem();
cpti.petToy = pt;
cpti.Quantity = item.Quantity;
//add to pet toy list
listCartPetToy.Add(cpti);
}
}
//set lists to ViewBag
ViewBag.listCartP = listCartPet;
ViewBag.listCartPT = listCartPetToy;
ViewBag.listCartPM = listCartPetMedicine;
}
return(View(listCartPetFood));
}
