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