public ActionResult AddOrEdit(int id = 0)
{
if (id == 0)
{
using (WebDBEntities db = new WebDBEntities())
{
ViewBag.Action = "New User";
return(View(new UserViewModel()));
}
}
else
{
using (WebDBEntities db = new WebDBEntities())
{
UserViewModel sub = new UserViewModel();
var menu = db.tbl_User.Where(x => x.userID == id).FirstOrDefault();
sub.userID = menu.userID;
sub.username = menu.username;
sub.password = menu.password;
sub.fullname = menu.fullname;
sub.email = menu.email;
ViewBag.Action = "Edit User";
return(View(sub));
}
}
}
public ActionResult AddOrEdit(int id = 0)
{
if (id == 0)
{
using (WebDBEntities db = new WebDBEntities())
{
ViewBag.Categories = db.tbl_Category.ToList();
return(View(new ProductViewModel()));
}
}
else
{
using (WebDBEntities db = new WebDBEntities())
{
ViewBag.Categories = db.tbl_Category.ToList();
tbl_Product item = db.tbl_Product.Where(i => i.productID == id).FirstOrDefault();
ProductViewModel itemvm = new ProductViewModel();
itemvm.productID = item.productID;
itemvm.categoryID = Convert.ToInt32(item.categoryID);
itemvm.title = item.title;
itemvm.unitPrice = item.unitPrice;
itemvm.sellingPrice = item.sellingPrice;
itemvm.description = item.description;
itemvm.photo = item.photo;
return(View(itemvm));
}
}
}
public ActionResult AddOrEdit(UserViewModel sm)
{
using (WebDBEntities db = new WebDBEntities())
{
if (sm.userID == 0)
{
tbl_User tb = new tbl_User();
tb.username = sm.username;
tb.password = sm.password;
tb.fullname = sm.fullname;
tb.email = sm.email;
db.tbl_User.Add(tb);
db.SaveChanges();
return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
tbl_User tbm = db.tbl_User.Where(m => m.userID == sm.userID).FirstOrDefault();
tbm.username = sm.username;
tbm.password = sm.password;
tbm.fullname = sm.fullname;
tbm.email = sm.email;
db.SaveChanges();
return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult Login(LoginViewModel l, string ReturnUrl = "")
{
using (WebDBEntities db = new WebDBEntities())
{
var users = db.tbl_User.Where(a => a.username == l.username && a.password == l.password).FirstOrDefault();
if (users != null)
{
Session.Add("username", users.username);
FormsAuthentication.SetAuthCookie(l.username, true);
if (Url.IsLocalUrl(ReturnUrl))
{
return(Redirect(ReturnUrl));
}
else
{
Session.Add("userid", users.userID);
if (users.tbl_UserRole.Where(r => r.roleID == 1).FirstOrDefault() != null)
{
return(RedirectToAction("DashBoard", "Admin"));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
}
else
{
ModelState.AddModelError("", "Invalid User");
}
}
return(View());
}
private void saveBtn_Click(object sender, RoutedEventArgs e)
{
int newFGID;
decimal newPrice;
WebDBEntities db = new WebDBEntities();
Finished_Goods fg = new Finished_Goods();
if (priceBox.Text == 0.00.ToString("C") || !decimal.TryParse(priceBox.Text.Trim('$'), out newPrice) || newPrice <= 0)
{
errBox.Content = "Error: Please input a price that is greater than 0 and is numeric.";
return;
}
if (descBox.Text == "")
{
errBox.Content = "Error: Please input a description.";
return;
}
if (packBox.Text == "")
{
errBox.Content = "Error: Please input a package type.";
return;
}
if (!int.TryParse(fgidBox.Text, out newFGID) || newFGID < 0)
{
errBox.Content = "Error: Please input an FGID that is numerical and greater than 0.";
return;
}
fg.Price = (double)newPrice;
fg.FGID = newFGID;
fg.Description = descBox.Text;
fg.Packaging = packBox.Text;
if (db.Finished_Goods.Find(newFGID) != null)
{
if (isNew)
{
errBox.Content = "Error: There is already a product with that ID.";
return;
}
else
{
// Delete current element based on its previous FGID
db.Finished_Goods.Remove(db.Finished_Goods.Find(db.Finished_Goods.ToArray().ElementAt(curPos).FGID));
db.SaveChanges();
}
}
db.Finished_Goods.Add(fg);
try
{
db.SaveChanges();
}
catch (Exception)
{
errBox.Content = "Error: There is already a product with that ID.";
return;
}
errBox.Content = "Item saved.";
}
public ActionResult ViewOrder_Post(int id)
{
using (WebDBEntities db = new WebDBEntities())
{
tbl_Order sm = db.tbl_Order.Where(x => x.orderID == id).FirstOrDefault();
sm.delivayStatus = "Confirmed";
db.SaveChanges();
return(RedirectToAction("ManageOrder", "Order"));
}
}
public ActionResult Delete(int id)
{
using (WebDBEntities db = new WebDBEntities())
{
tbl_User sm = db.tbl_User.Where(x => x.userID == id).FirstOrDefault();
db.tbl_User.Remove(sm);
db.SaveChanges();
return(Json(new { success = true, message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddOrEdit(ProductViewModel ivm)
{
using (WebDBEntities db = new WebDBEntities())
{
if (ivm.productID == 0)
{
tbl_Product itm = new tbl_Product();
itm.categoryID = Convert.ToInt32(ivm.categoryID);
itm.title = ivm.title;
itm.unitPrice = ivm.unitPrice;
itm.sellingPrice = ivm.sellingPrice;
itm.description = ivm.description;
HttpPostedFileBase fup = Request.Files["photo"];
if (fup != null)
{
if (fup.FileName != "")
{
fup.SaveAs(Server.MapPath("~/ProductImages/" + fup.FileName));
itm.photo = fup.FileName;
}
}
itm.isSpecial = ivm.isSpecial;
db.tbl_Product.Add(itm);
db.SaveChanges();
ViewBag.Message = "Created Successfully";
}
else
{
tbl_Product itm = db.tbl_Product.Where(i => i.productID == ivm.productID).FirstOrDefault();
itm.categoryID = Convert.ToInt32(ivm.categoryID);
itm.title = ivm.title;
itm.unitPrice = ivm.unitPrice;
itm.sellingPrice = ivm.sellingPrice;
itm.description = ivm.description;
HttpPostedFileBase fup = Request.Files["Photo"];
if (fup != null)
{
if (fup.FileName != "")
{
fup.SaveAs(Server.MapPath("~/ProductImages/" + fup.FileName));
itm.photo = fup.FileName;
}
}
db.SaveChanges();
ViewBag.Message = "Updated Successfully";
}
ViewBag.Categories = db.tbl_Category.ToList();
return(View(new ProductViewModel()));
}
}
public JsonResult GetData()
{
using (WebDBEntities db = new WebDBEntities())
{
db.Configuration.LazyLoadingEnabled = false;
List <UserViewModel> lst = new List <UserViewModel>();
var userList = db.tbl_User.ToList();
foreach (var item in userList)
{
lst.Add(new UserViewModel()
{
userID = item.userID, username = item.username, password = item.password, fullname = item.fullname, email = item.email
});
}
return(Json(new { data = lst }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetData()
{
using (WebDBEntities db = new WebDBEntities())
{
db.Configuration.LazyLoadingEnabled = false;
List <ProductViewModel> lstitem = new List <ProductViewModel>();
var lst = db.tbl_Product.Include("tbl_Category").ToList();
foreach (var item in lst)
{
lstitem.Add(new ProductViewModel()
{
productID = item.productID, categoryName = item.tbl_Category.categoryName, title = item.title, unitPrice = item.unitPrice, sellingPrice = item.sellingPrice, photo = item.photo, description = item.description
});
}
return(Json(new { data = lstitem }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetData()
{
using (WebDBEntities db = new WebDBEntities())
{
db.Configuration.LazyLoadingEnabled = false;
List <OrderViewModel> lstorder = new List <OrderViewModel>();
var empList = db.tbl_Order.ToList();
foreach (var item in empList)
{
lstorder.Add(new OrderViewModel()
{
orderID = item.orderID, firstname = item.firstname, lastname = item.lastname, address = item.address, phone = item.phone, total = item.total.ToString(), orderDate = item.orderDate.ToString(), delivayStatus = item.delivayStatus
});
}
return(Json(new { data = lstorder }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetData()
{
using (WebDBEntities db = new WebDBEntities())
{
db.Configuration.LazyLoadingEnabled = false;
List <CategoryViewModel> lst = new List <CategoryViewModel>();
var catList = db.tbl_Category.ToList();
foreach (var item in catList)
{
lst.Add(new CategoryViewModel()
{
categoryID = item.categoryID, categoryName = item.categoryName
});
}
return(Json(new { data = lst }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddOrEdit(tbl_Category sm)
{
using (WebDBEntities db = new WebDBEntities())
{
if (sm.categoryID == 0)
{
db.tbl_Category.Add(sm);
db.SaveChanges();
return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
db.Entry(sm).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult ViewOrder(int id)
{
using (WebDBEntities db = new WebDBEntities())
{
List <OrderDetailViewModel> lstod = new List <OrderDetailViewModel>();
var empList = db.tbl_OrderDetail.Where(x => x.orderID == id).ToList();
foreach (tbl_OrderDetail item in empList)
{
lstod.Add(new OrderDetailViewModel()
{
productID = Convert.ToInt32(item.productID), title = item.tbl_Product.title, quantity = Convert.ToInt32(item.quantity), unitPrice = Convert.ToDecimal(item.unitPrice)
});
}
Session.Add("itemlist", lstod);
Session.Add("orderID", id);
return(View(lstod));
}
}
private void saveBtn_Click(object sender, RoutedEventArgs e)
{
int newRMID;
decimal newCost;
WebDBEntities db = new WebDBEntities();
Raw_Materials rm = new Raw_Materials();
if (costBox.Text == 0.00.ToString("C") || !decimal.TryParse(costBox.Text.Trim('$'), out newCost) || newCost <= 0)
{
errBox.Content = "Error: Please input a cost that is greater than 0 and is numeric.";
return;
}
if (descBox.Text == "")
{
errBox.Content = "Error: Please input a description.";
return;
}
if (!int.TryParse(idBox.Text, out newRMID) || newRMID < 0)
{
errBox.Content = "Error: Please input an RMID that is numerical and greater than 0.";
return;
}
rm.Cost = newCost;
rm.RMID = newRMID;
rm.Description = descBox.Text;
if (db.Raw_Materials.Find(newRMID) != null)
{
if (isNew)
{
errBox.Content = "Error: There is already a material with that ID.";
return;
}
else
{
// Delete current element based on its previous RMID
db.Raw_Materials.Remove(db.Raw_Materials.Find(db.Raw_Materials.ToArray().ElementAt(curPos).RMID));
db.SaveChanges();
}
}
db.Raw_Materials.Add(rm);
db.SaveChanges();
errBox.Content = "Item saved.";
}
public ActionResult AddOrEdit(int id = 0)
{
if (id == 0)
{
using (WebDBEntities db = new WebDBEntities())
{
// ViewBag.Menus = db.tblMenus.ToList();
return(View(new tbl_Category()));
}
}
else
{
using (WebDBEntities db = new WebDBEntities())
{
// ViewBag.Menus = db.tblMenus.ToList();
return(View(db.tbl_Category.Where(x => x.categoryID == id).FirstOrDefault()));
}
}
}
public void loadData(int pos = 0)
{
WebDBEntities db = new WebDBEntities();
var data = db.Raw_Materials.ToArray();
if (pos >= data.Length)
{
pos = 0;
}
if (pos <= -1)
{
pos = data.Length - 1;
}
var cur = data.ElementAt(pos);
idBox.Text = cur.RMID.ToString();
costBox.Text = cur.Cost.Value.ToString("C");
descBox.Text = cur.Description;
curPos = pos;
}
public void loadData(int pos = 0)
{
WebDBEntities db = new WebDBEntities();
var data = db.Finished_Goods.ToArray();
if (pos >= data.Length)
{
pos = 0;
}
if (pos <= -1)
{
pos = data.Length - 1;
}
var cur = data.ElementAt(pos);
fgidBox.Text = cur.FGID.ToString();
costBox.Text = cur.Price.Value.ToString("C");
matGrid.ItemsSource = cur.Recipes;
curPos = pos;
}
private void delBtn_Click(object sender, RoutedEventArgs e)
{
WebDBEntities db = new WebDBEntities();
Raw_Materials rm = new Raw_Materials();
if (isNew)
{
idBox.Text = 0000.ToString();
descBox.Text = "";
costBox.Text = "$0.00";
errBox.Content = "";
return;
}
else
{
db.Raw_Materials.Remove(db.Raw_Materials.Find(db.Raw_Materials.ToArray().ElementAt(curPos).RMID));
db.SaveChanges();
loadData(curPos);
errBox.Content = "";
}
}
public ActionResult AddOrEdit(CategoryViewModel sm)
{
using (WebDBEntities db = new WebDBEntities())
{
if (sm.categoryID == 0)
{
tbl_Category tb = new tbl_Category();
tb.categoryName = sm.categoryName;
db.tbl_Category.Add(tb);
db.SaveChanges();
return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
tbl_Category tbm = db.tbl_Category.Where(m => m.categoryID == sm.categoryID).FirstOrDefault();
tbm.categoryName = sm.categoryName;
db.SaveChanges();
return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet));
}
}
}
private void addBtn_Click(object sender, RoutedEventArgs e)
{
WebDBEntities db = new WebDBEntities();
int newFGID;
decimal newPrice;
if (priceBox.Text == 0.00.ToString("C") || !decimal.TryParse(priceBox.Text.Trim('$'), out newPrice) || newPrice <= 0)
{
errBox.Content = "Error: Please create a finished good before adding materials.";
return;
}
if (descBox.Text == "")
{
errBox.Content = "Error: Please create a finished good before adding materials.";
return;
}
if (packBox.Text == "")
{
errBox.Content = "Error: Please create a finished good before adding materials.";
return;
}
if (!int.TryParse(fgidBox.Text, out newFGID) || newFGID < 0)
{
errBox.Content = "Error: Please create a finished good before adding materials.";
return;
}
try
{
Finished_Goods fg = db.Finished_Goods.Find(newFGID);
}
catch (Exception)
{
errBox.Content = "Error: Please save the finished good before adding materials.";
}
AddMaterials am = new AddMaterials(newFGID);
am.ShowDialog();
}
private void delBtn_Click(object sender, RoutedEventArgs e)
{
WebDBEntities db = new WebDBEntities();
Finished_Goods fg = new Finished_Goods();
if (isNew)
{
fgidBox.Text = 0000.ToString();
descBox.Text = "";
priceBox.Text = "$0.00";
packBox.Text = "";
errBox.Content = "";
return;
}
else
{
db.Finished_Goods.Remove(db.Finished_Goods.Find(db.Finished_Goods.ToArray().ElementAt(curPos).FGID));
db.SaveChanges();
loadData(curPos);
errBox.Content = "";
}
}
public void loadData(int pos = 0)
{
WebDBEntities db = new WebDBEntities();
var data = db.Finished_Goods.ToArray();
if (pos >= data.Length)
{
pos = 0;
}
if (pos <= -1)
{
pos = data.Length - 1;
}
var cur = data.ElementAt(pos);
fgidBox.Text = cur.FGID.ToString();
priceBox.Text = cur.Price.Value.ToString("C");
descBox.Text = cur.Description;
matGrid.ItemsSource = cur.Recipes;
packBox.Text = cur.Packaging;
curPos = pos;
isNew = false;
}
public ActionResult GetCityList(string stateID)
{
//trả về kiểu json khi gọi từ ajax
List <Page> lstcity = new List <Page>();
int stateiD = Convert.ToInt32(stateID);
using (WebDBEntities cITYSTATEEntities = new WebDBEntities())
{
// lấy danh sách bảng Page theo MenuId chuyền vào
lstcity = (cITYSTATEEntities.Pages.Where(x => x.MenuId == stateiD)).ToList <Page>();
}
// gặp lỗi lấy dữ liệu ở đây thì thêm Configuration.LazyLoadingEnabled = false; vào file context.cs :
//public WebDBEntities()
//: base("name=WebDBEntities")
//{
// Configuration.LazyLoadingEnabled = false;
//}
JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer();
string result = javaScriptSerializer.Serialize(lstcity);
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult AddOrEdit(int id = 0)
{
if (id == 0)
{
using (WebDBEntities db = new WebDBEntities())
{
ViewBag.Action = "New Category";
return(View(new CategoryViewModel()));
}
}
else
{
using (WebDBEntities db = new WebDBEntities())
{
CategoryViewModel sub = new CategoryViewModel();
var menu = db.tbl_Category.Where(x => x.categoryID == id).FirstOrDefault();
sub.categoryID = menu.categoryID;
sub.categoryName = menu.categoryName;
ViewBag.Action = "Edit Category";
return(View(sub));
}
}
}
