public ActionResult Index() { ViewBag.__auth = MySsAuthUsers.GetAuth(); Quan vm = new Quan(); return(View(vm)); }
public rs get_by_id(int id) { rs r; Quan quan = null; var data = __db.Quan.FirstOrDefault(f => f.Id == id); if (data != null) { quan = new Quan() { Id = data.Id, MaQuan = data.MaQuan, TenQuan = data.TenQuan, DiaChi = data.DiaChi, DienThoai = data.DienThoai, ImageThumbnail = Utils.site + data.ImageThumbnail + "?v=2", /*Ban = data.Ban.ToList().Select(s=>new Ban() * { * Id=s.Id, * TenBan = s.TenBan, * MaBan = s.MaBan, * }).ToList()*/ }; r = rs.T("Ok", quan); } else { r = rs.F("Không tìm thấy quán"); } return(r); }
// GET: Admin/Quans/Edit/5 public ActionResult Edit(int id) { var auth = MySsAuthUsers.GetAuth(); Quan entity = _QuanServ.GetEntry(id); QuanCRUD vm = new QuanCRUD(); vm.Id = entity.Id; vm.MaQuan = entity.MaQuan; vm.TenQuan = entity.TenQuan; if (string.IsNullOrWhiteSpace(vm.ImageThumbnail)) { vm.ImageThumbnail = "/Content/images/sample/shop2.png"; //model.Image; } else { vm.ImageThumbnail = entity.ImageThumbnail; } vm.DiaChi = entity.DiaChi; vm.DienThoai = entity.DienThoai; if (auth.RoleId == 1) { vm.DanhSachNhanVien = new List <User>(); } else { vm.DanhSachNhanVien = __db.Users.Where(w => w.OwnerId == auth.ID); } ViewBag.__auth = auth; vm.DanhSachNhanVienChon = entity.UserQuans.Select(s => s.UserID).ToList(); vm.BanArr = entity.BanArr; vm.ChuQuan = new FrmCreateUserVM(); return(View(vm)); }
public void Init() { Quan.Clear(); Comp_name.Clear(); OrderListData od = new OrderListData(); dataGridView1.DataSource = od.GetOrderShowList(); }
public IEnumerable <Quan> Get() { try { return(Quan.GetAll()); } catch { return(null); } }
public IEnumerable <Quan> Get(int id) { try { var ds = Quan.GetAll(); List <Quan> lts = new List <Quan>(); lts.Add(ds.FirstOrDefault(p => p.idquan == id)); return(lts); } catch { return(null); } }
private void SaveProductButton_Click(object sender, RoutedEventArgs e) { Product product = new Product(); product.Name = ProductName.Text; product.Kcal = float.Parse((ProductKCAL.Text).ToString()); product.Quantity = int.Parse((Quan.Text).ToString()); product.Unit = Unit.Text; DataBaseSolution.AddProduct(product); ProductName.Clear(); ProductKCAL.Clear(); Unit.ClearValue(NameProperty); Quan.Clear(); }
private void ButtonDSQuanGiaoNhau_OnClicked(object sender, EventArgs e) { LabelDuongGiaoNhau.Text = "Đang tải . . ."; Task.Run(async() => { try { var url = HttpService.Instance.GetDuongDiQuaQuan(_duong.StreetId); var result = await HttpService.Instance.GetAsync(url); if (result != null) { Device.BeginInvokeOnMainThread(async() => { var listQuan = Quan.DeserializeList(result); var listTenQuan = new List <string>(); foreach (var quan in listQuan) { listTenQuan.Add(quan.DistrictName); } await DisplayActionSheet("Danh sách quận đi qua:", "Cancel", "OK", listTenQuan.ToArray()); LabelDuongGiaoNhau.Text = ""; }); } else { Device.BeginInvokeOnMainThread(() => { LabelDuongGiaoNhau.Text = "Quá trình tải bị lỗi, xin thử lại"; }); } } catch (Exception ex) { Debug.WriteLine(ex); Device.BeginInvokeOnMainThread(() => { LabelDuongGiaoNhau.Text = "Quá trình tải bị lỗi, xin thử lại"; }); } }); }
public ActionResult SetBanChayQuan(int id) { rs r; try { Quan search = _QuanServ.GetEntry(id); //search.IsBanChay = !search.IsBanChay; _QuanServ.Save(); r = rs.T("Ok"); } catch (Exception ex) { r = rs.F("Lỗi: " + ex.Message); } return(Json(r, JsonRequestBehavior.DenyGet)); }
public ActionResult DeleteQ(int MaQuan)//Xóa quan { Quan q = db.Quan.Find(MaQuan); if (q == null) { return(HttpNotFound()); } foreach (var p in db.Phuong.ToList()) { if (p.MaQuan == MaQuan) { db.Phuong.Remove(p); } } db.Quan.Remove(q); db.SaveChanges(); return(RedirectToAction("Quan")); }
public ActionResult Delete(int id) { rs r; try { Quan Quan = _QuanServ.GetEntry(id); _QuanServ.Delete(Quan); _QuanServ.Save(); r = rs.T("Ok"); } catch (Exception ex) { r = rs.F("Lỗi: " + ex.Message); } return(Json(r, JsonRequestBehavior.DenyGet)); }
public ActionResult CreateQ(string TenQuan) { if (ModelState.IsValid) { Quan q = db.Quan.SingleOrDefault(x => x.TenQuan == TenQuan); if (q != null) { ModelState.AddModelError("", "Quận đã có"); } else { Quan t = new Quan(); t.TenQuan = TenQuan; db.Quan.Add(t); db.SaveChanges(); return(RedirectToAction("Quan")); } } return(RedirectToAction("Quan")); }
private void saveRepackBtn_Click(object sender, EventArgs e) { string repacked_name = productTxt.Text + " (Repacked by " + repackBy.Text + " " + unitTxt.Text + " )"; String query_select = "SELECT * from products where name = '" + repacked_name + "' AND archived = 'no' "; conn.Open(); MySqlCommand comm_select = new MySqlCommand(query_select, conn); MySqlDataAdapter adp = new MySqlDataAdapter(comm_select); conn.Close(); DataTable dt = new DataTable(); adp.Fill(dt); if (dt.Rows.Count == 1) { // DONT ADD A NEW PROFILE } else { //New product string query_new = "INSERT INTO products(name,description,price,volume,unit,expirable,date_added,date_modified,archived,reorder,medicine)" + "VALUES('" + repacked_name + "' ,'" + descTxt.Text + "','" + (decimal.Parse(origpriceTxt.Text) / int.Parse(repackedQuan.Text)) + "'," + repackBy.Value + ",'" + unitTxt.Text + "','" + expirable + "', current_timestamp(),current_timestamp(),'no'," + reorder + "," + medval + ")"; conn.Open(); MySqlCommand comm_new = new MySqlCommand(query_new, conn); comm_new.ExecuteNonQuery(); conn.Close(); } string query_inventory_duplicate = "SELECT expiration_date FROM product_inventory WHERE expiration_date = '" + exp + "' AND products_id = (SELECT id FROM products where name = '" + repacked_name + "')"; conn.Open(); MySqlCommand comm_inventory_duplicate = new MySqlCommand(query_inventory_duplicate, conn); MySqlDataAdapter adp_inventory_duplicate = new MySqlDataAdapter(comm_inventory_duplicate); conn.Close(); DataTable dt_inventory_duplicate = new DataTable(); adp_inventory_duplicate.Fill(dt_inventory_duplicate); if (dt_inventory_duplicate.Rows.Count > 0) { // Increment Quantity of existing instance string query_add_quantity = "UPDATE product_inventory set status = 'available', quantity = quantity + " + Quan.Value + " where products_id = (SELECT id FROM products where name = '" + repacked_name + "') AND expiration_date = '" + exp + "'"; conn.Open(); MySqlCommand comm_add_quantity = new MySqlCommand(query_add_quantity, conn); comm_add_quantity.ExecuteNonQuery(); conn.Close(); MessageBox.Show("update "); } else { // Add a new instance string query_inventory = "INSERT INTO product_inventory (products_id,quantity,expiration_date,status) VALUES((SELECT max(id) FROM products),'" + Quan.Value + "','" + exp + "', 'available')"; conn.Open(); MySqlCommand comm_inventory = new MySqlCommand(query_inventory, conn); comm_inventory.ExecuteNonQuery(); conn.Close(); } /* delete * string query_repack = "INSERT INTO inventory_repack (product_inventory_id,product_inventory_products_id,quantity,status,expiration_date) VALUES(" + pid + "," + prod_id + "," + (int)(repackedQuan.Value) + ", 'available','" + exp + "')"; * conn.Open(); * MySqlCommand comm_repack = new MySqlCommand(query_repack, conn); * comm_repack.ExecuteNonQuery(); * conn.Close(); */ string query_subtract_quantity = "UPDATE product_inventory set quantity = quantity - " + int.Parse(Quan.Text) + " where product_inventory.id = '" + pid + "'"; conn.Open(); MySqlCommand comm_subtract_quantity = new MySqlCommand(query_subtract_quantity, conn); comm_subtract_quantity.ExecuteNonQuery(); conn.Close(); string query_log = "INSERT INTO inventory_log (process_type,date,product,quantity,remarks,staff_id) VALUES('Stock Out (Repack)' , current_timestamp(),'" + productTxt.Text + "','" + Quan.Text + "', 'For Shelf', " + CaPY_SAD.Login.UserDisplayDetails.id + ")"; conn.Open(); MySqlCommand comm_log = new MySqlCommand(query_log, conn); comm_log.ExecuteNonQuery(); conn.Close(); string query_updateavail = "UPDATE product_inventory SET status = 'unavailable' WHERE quantity <= 0"; conn.Open(); MySqlCommand comm_updateavail = new MySqlCommand(query_updateavail, conn); comm_updateavail.ExecuteNonQuery(); conn.Close(); MessageBox.Show("Item Repacked"); loadInventoryData(); repackPanel.Visible = false; productTxt.Clear(); itemVol.Refresh(); repackBy.Refresh(); Quan.Refresh(); repackedQuan.Refresh(); }
protected override void Seed(VD.Data.vuong_cms_context context) { CacheServ.ClearAll(); return; context.HinhThucMuaHang.AddOrUpdate(HinhThucMuaHang.seed()); context.SaveChanges(); context.Roles.AddOrUpdate(Role.seed()); context.SaveChanges(); context.Quan.AddOrUpdate(Quan.seed()); context.SaveChanges(); //context.Ban.AddOrUpdate(Ban.seed()); context.SaveChanges(); context.TrangThaiGiaoHang.AddOrUpdate(TrangThaiGiaoHang.seed()); context.SaveChanges(); // context.TrangThaiThanhToan.AddOrUpdate(TrangThaiThanhToan.seed()); context.SaveChanges(); //httt context.HTTTs.AddOrUpdate(HTTT.seed()); context.SaveChanges(); //settings: context.Settings.AddOrUpdate(Setting.seed()); context.SaveChanges(); //role context.Roles.AddOrUpdate(Role.seed()); context.SaveChanges(); //flag context.Langs.AddOrUpdate(Lang.seed()); context.SaveChanges(); //Confs context.Confs.AddOrUpdate(Conf.seed()); context.SaveChanges(); //LogType context.LogType.AddOrUpdate(LogType.seed()); context.SaveChanges(); //UserStatus context.UserStatus.AddOrUpdate(UserStatus.seed()); context.SaveChanges(); //user context.Users.AddOrUpdate(User.seed()); context.SaveChanges(); //slider context.Slider.AddOrUpdate(Slider.seed()); context.SaveChanges(); //slider context.ProductCat.AddOrUpdate(ProductCat.seed()); context.SaveChanges(); //img context.ImgTmp.AddOrUpdate(ImgTmp.seed()); context.SaveChanges(); context.ImgTmpDetail.AddOrUpdate(ImgTmpDetail.seed()); context.SaveChanges(); //product context.Product.AddOrUpdate(Product.seed()); context.SaveChanges(); //contact context.ContactStatus.AddOrUpdate(ContactStatus.seed()); context.SaveChanges(); //article context.Category.AddOrUpdate(Category.seed()); context.SaveChanges(); context.Article.AddOrUpdate(Article.seed()); context.SaveChanges(); }
public JsonResult Search(SearchModel entity) { List <BaiViet> listBaiViet = new List <BaiViet>(); var res = db.BaiViets.ToList(); //Search Quan Quan q = db.Quans.Find(entity.idQuan); Phuong p = db.Phuongs.Find(entity.idPhuong); KieuBD k = db.KieuBDS.Find(entity.idBDS); LoaiBD l = db.LoaiBDS.Find(entity.idLoaiBDS); string temp = ""; if (q == null) { temp = ""; } else { temp = q.TenQuan; } if (p == null) { temp = temp; } else { temp += " " + p.TenPhuong; } if (l == null) { temp = temp; } else { temp += " " + l.TenLoai; } if (k == null) { temp = temp; } else { temp += " " + k.TenKieu; } var listNT = db.NhaTroes.SqlQuery("select * from NhaTro n where n.SoNha like N'%" + temp + "%'").ToList(); foreach (var item in res) { foreach (var item1 in listNT) { if (item.idNT == item1.idNT) { listBaiViet.Add(item); } } } //string tempJ = string.Empty; //tempJ = JsonConvert.SerializeObject(listBaiViet, Formatting.Indented, new JsonSerializerSettings //{ // ReferenceLoopHandling = ReferenceLoopHandling.Ignore //}); return(Json(listBaiViet, JsonRequestBehavior.AllowGet)); }
public JsonResult Create(QuanCRUD model) { var __auth = MySsAuthUsers.GetAuth(); rs r; using (TransactionScope tx = new TransactionScope()) { try { //chủ quán SimpleAES __aes = new SimpleAES(); User chuquan = new User(); //pass encode chuquan.Username = model.ChuQuan.Username; chuquan.Password = __aes.EncryptToString(model.ChuQuan.Password); chuquan.RoleId = 2;//chu quan chuquan.UserStatusId = 1; chuquan.Address = model.ChuQuan.Address; chuquan.GioiTinh = model.ChuQuan.GioiTinh; chuquan.Phone = model.ChuQuan.Phone; chuquan.Email = model.ChuQuan.Email; chuquan.Fullname = model.ChuQuan.Username; if (string.IsNullOrWhiteSpace(model.ImageThumbnail)) { chuquan.Image = "/Content/images/sample/shop2.png"; //model.Image; } else { chuquan.Image = model.ImageThumbnail; } __db.Users.Add(chuquan); __db.SaveChanges(); Quan quan = new Quan(); quan.MaQuan = model.MaQuan; quan.TenQuan = model.TenQuan; quan.UserQuans = new List <UserQuan>(); quan.UserId = chuquan.Id; //chuquan quan.DiaChi = model.DiaChi; quan.DienThoai = model.DienThoai; quan.BanArr = "1,2,3,4,5,6,7,8,9,10"; if (string.IsNullOrWhiteSpace(model.ImageThumbnail)) { quan.ImageThumbnail = "/Content/images/sample/account.png"; } else { quan.ImageThumbnail = model.ImageThumbnail; } //danh sach nhan vien quan ly foreach (var item in model.NhanVienIntIDs) { quan.UserQuans.Add(new UserQuan() { QuanID = quan.Id, UserID = item }); } __db.Quan.Add(quan); __db.SaveChanges(); chuquan.QuanDefaultId = quan.Id; __db.SaveChanges(); //product cat & product List <ProductCat> product_cat = new List <ProductCat>(); for (var i = 0; i < 2; i++) { var pc = new ProductCat() { QuanId = quan.Id, Name = "Danh mục mẫu" + (i + 1), Products = new Collection <Product>(), ImageThumbnail = Utils.RandomAnhSample("/Content/images/sample/cat", 1, 2, ".png") }; for (var j = 0; j < 2; j++) { pc.Products.Add(new Product() { ProductName = "Sản phẩm " + (j + 1), MaSo = "MSP-" + j + 1, Price = Utils.RandomGia(), ThumbnailImage = Utils.RandomAnhSample("/Content/images/sample/p", 1, 5, ".png"), }); } product_cat.Add(pc); } __db.ProductCat.AddRange(product_cat); __db.SaveChanges(); r = rs.T("Okay"); tx.Complete(); } catch (Exception ex) { r = rs.F("Lỗi: " + ex.Message); } } return(Json(r, JsonRequestBehavior.DenyGet)); }