public ActionResult XoaNhaPhanPhoi(int id)
{
if (Session["MaTKAdmin"] == null)
{
return(RedirectToAction("Login", "Admin"));
}
else
{
try
{
ShopEntities shop = new ShopEntities();
var npp = shop.NhaPhanPhois.SingleOrDefault(n => n.MaNhaPhanPhoi == id);
var ds = shop.SanPhams.Where(s => s.NhaPhanPhois.Any(e => e.MaNhaPhanPhoi == id)).ToList();
foreach (var item in ds)
{
npp.SanPhams.Remove(item);
shop.SaveChanges();
}
shop.NhaPhanPhois.Remove(npp);
shop.SaveChanges();
return(Json(JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
return(RedirectToAction("Index"));
}
}
}
public IPagedList <SanPham> KhoiTaoDanhSachSanPhamPhanPhoi(int id, string searchString, int?page)
{
ViewBag.CurrentFilter = searchString;
ShopEntities shop = new ShopEntities();
var npp = shop.NhaPhanPhois.Single(n => n.MaNhaPhanPhoi == id);
var dsSanPhamDangPhanPhoi = npp.SanPhams.Where(s => s.NhaPhanPhois.Any(e => e.MaNhaPhanPhoi == id)).ToList();
var dsSanPhamChuaPhanPhoi = shop.SanPhams.ToList();
foreach (var item in dsSanPhamDangPhanPhoi)
{
dsSanPhamChuaPhanPhoi.Remove(item);
}
List <SelectListItem> slSP = new List <SelectListItem>();
for (int i = 0; i < dsSanPhamChuaPhanPhoi.Count; i++)
{
SelectListItem sl = new SelectListItem()
{
Text = dsSanPhamChuaPhanPhoi[i].TenSanPham, Value = dsSanPhamChuaPhanPhoi[i].MaSanPham.ToString()
};
slSP.Add(sl);
}
ViewBag.SP = slSP;
int pageSize = 10;
int pageNumber = (page ?? 1);
dsSanPhamDangPhanPhoi.ToPagedList(pageNumber, pageSize);
return(dsSanPhamDangPhanPhoi.ToPagedList(pageNumber, pageSize));
}
public IPagedList <HoaDonNhap> KhoiTao(string searchString, int?page)
{
ViewBag.CurrentFilter = searchString;
ShopEntities shop = new ShopEntities();
var dsNhaPP = shop.NhaPhanPhois.ToList();
List <SelectListItem> slNhaPP = new List <SelectListItem>();
for (int i = 0; i < dsNhaPP.Count; i++)
{
SelectListItem sl = new SelectListItem()
{
Text = dsNhaPP[i].TenNhaPhanPhoi, Value = dsNhaPP[i].MaNhaPhanPhoi.ToString()
};
slNhaPP.Add(sl);
}
ViewBag.NPP = slNhaPP;
var dsHoaDonNhap = shop.HoaDonNhaps.OrderByDescending(s => s.MaHoaDon);
if (!String.IsNullOrEmpty(searchString))
{
dsHoaDonNhap = shop.HoaDonNhaps.Where(s => s.NhaPhanPhois.TenNhaPhanPhoi.Contains(searchString)).OrderByDescending(s => s.MaHoaDon);
}
int pageSize = 10;
int pageNumber = (page ?? 1);
dsHoaDonNhap.ToPagedList(pageNumber, pageSize);
return(dsHoaDonNhap.ToPagedList(pageNumber, pageSize));
}
public WarehouseController()
{
kiemtra = new KiemTra();
var user = kiemtra.getUser(kiemtra.HttpContext.User.Identity.Name);
db = ShopEntities.CreateEntitiesForSpecificDatabaseName(user.MaCN);
}
/// <summary>
/// 查询已提交的订单列表
/// </summary>
/// <param name="pid"></param>
/// <param name="userid"></param>
/// <returns></returns>
public object QueryOrder(int pid, int userid)
{
using (ShopEntities db = new ShopEntities())
{
return(db.ReceiveOrder.Where(o => o.Pid == pid && o.UserID == userid).ToList());
}
}
public ActionResult SuaSanPham(QuanLyHoaDonNhap qlhd, int id)
{
if (Session["MaTKAdmin"] == null)
{
return(RedirectToAction("Login", "Admin"));
}
else
{
try
{
ShopEntities shop = new ShopEntities();
var sp = shop.SanPhams.SingleOrDefault(s => s.MaSanPham == qlhd.ChiTietHoaDonNhap.MaSanPham);
var chiTietHoaDonNhap = new ChiTietHoaDonNhap();
chiTietHoaDonNhap.MaSanPham = qlhd.ChiTietHoaDonNhap.MaSanPham;
chiTietHoaDonNhap.MaHoaDon = maHoaDon;
chiTietHoaDonNhap.SoLuong = qlhd.ChiTietHoaDonNhap.SoLuong;
chiTietHoaDonNhap.DonViTinh = qlhd.ChiTietHoaDonNhap.DonViTinh;
chiTietHoaDonNhap.GiaNhap = qlhd.ChiTietHoaDonNhap.GiaNhap;
chiTietHoaDonNhap.TongTien = (qlhd.ChiTietHoaDonNhap.GiaNhap * qlhd.ChiTietHoaDonNhap.SoLuong);
shop.ChiTietHoaDonNhaps.Add(chiTietHoaDonNhap);
sp.SoLuong += qlhd.ChiTietHoaDonNhap.SoLuong;
shop.SaveChanges();
return(Json(true, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
return(RedirectToAction("Index"));
}
}
}
/// <summary>
/// 查询当前用户关联信息
/// </summary>
/// <returns></returns>
public object QueryBuyerUserInfo(int ID)
{
using (ShopEntities db = new ShopEntities())
{
var Query = (from a in db.BuyerUserInfo
join b in db.BuyerUser_Product on a.ID equals b.BuyerUserInfoID into temp
from x in temp.DefaultIfEmpty()
join c in db.Product on x.ProductID equals c.ID into temps
from y in temps.DefaultIfEmpty()
where a.ID == ID
select new
{
ID = a.ID,
UserName = a.UserName,
ProductImg = y.ProductImg,
PhoneNumber = a.PhoneNumber,
Email = a.Email,
WechatNumber = a.WechatNumber,
Level = a.Level,
GoodComment = (decimal?)y.GoodComment,
Collections = (int?)y.Collections,
CmtNum = (int?)y.CmtNum,
EnterpriseName = a.EnterpriseName,
EnterpriseTaxNumber = a.EnterpriseTaxNumber,
Money = a.Money,
Get = a.Get,
CollectionNum = a.CollectionNum
}).ToList();
return(Query);
}
}
/// <summary>
/// 批量修改 改custom
/// </summary>
/// <param name="datas"></param>
/// <returns></returns>
public bool Edits(List <DataDictionary> datas)
{
using (ShopEntities db = new ShopEntities())
{
var args = new DataDictionaryDataChangedArgs
{
DictionaryChangeType = ChangeType.Edit
};
foreach (var item in datas)
{
DataDictionary dataDictionary = db.DataDictionary.FirstOrDefault(s => s.DictionaryID == item.DictionaryID);
dataDictionary.Custom = item.Custom;
args.Add(dataDictionary);
}
try
{
db.SaveChanges();
}
catch (Exception)
{
return(false);
}
try
{
Task.Run(() => DataDictionaryDataChanged?.Invoke(null, args));
}
catch
{
}
InitList();
return(true);
}
}
/// <summary>
/// 根据电话号码搜索用户
/// </summary>
/// <param name="PhoneNumber"></param>
/// <returns></returns>
public BuyerUserInfo QueryPhoneUser(string PhoneNumber)
{
using (ShopEntities db = new ShopEntities())
{
return(db.BuyerUserInfo.SingleOrDefault(o => o.PhoneNumber.Equals(PhoneNumber)));
}
}
/// <summary>
/// 根据邮箱搜索用户
/// </summary>
/// <param name="email"></param>
/// <returns></returns>
public BuyerUserInfo QueryEmailUser(string email)
{
using (ShopEntities db = new ShopEntities())
{
return(db.BuyerUserInfo.SingleOrDefault(o => o.Email.Equals(email)));
}
}
/// <summary>
/// 根据用户名搜索用户
/// </summary>
/// <param name="UserName"></param>
/// <returns></returns>
public BuyerUserInfo QueryUserNameUser(string UserName)
{
using (ShopEntities db = new ShopEntities())
{
return(db.BuyerUserInfo.SingleOrDefault(o => o.UserName.Equals(UserName)));
}
}
/// <summary>
/// 获取买家个人账户信息
/// </summary>
/// <returns></returns>
public BuyerUserInfo GetBUInfo(BuyerUserInfo bus)
{
using (ShopEntities db = new ShopEntities())
{
return(db.BuyerUserInfo.SingleOrDefault(o => o.UserName.Equals(bus.UserName) && o.PassWord.Equals(bus.PassWord)));
}
}
public Order Get(int id)
{
using (ShopEntities entities = new ShopEntities())
{
return(entities.Orders.FirstOrDefault(e => e.OrderID == id));
}
}
public IEnumerable <Order> Get()
{
using (ShopEntities entities = new ShopEntities())
{
return(entities.Orders.ToList());
}
}
public IEnumerable <Product> Get()
{
using (ShopEntities entities = new ShopEntities())
{
return(entities.Products.ToList());
}
}
/// <summary>
/// 编辑子级字典
/// </summary>
/// <param name="changedDataDictionary">子级实体对象</param>
public void Edit(DataDictionary changedDataDictionary)
{
var args = new DataDictionaryDataChangedArgs
{
DictionaryChangeType = ChangeType.Edit
};
using (var db = new ShopEntities())
{
var entity = db.DataDictionary.Where(p => p.DictionaryID == changedDataDictionary.DictionaryID).FirstOrDefault() ?? throw new OperateException("不存在指定的的子级");
var dataDictionary = db.DataDictionary.Where(p => p.Value == changedDataDictionary.Value && p.FDictionaryID == entity.FDictionaryID).FirstOrDefault();
if (entity.Value != changedDataDictionary.Value && dataDictionary != null)
{
throw new OperateException("子级中存在相同值");
}
db.Entry(entity).State = EntityState.Detached;
db.Entry(db.DataDictionary.Attach(changedDataDictionary)).State = EntityState.Modified;
db.SaveChanges();
args.Add(changedDataDictionary);
}
try
{
Task.Run(() => DataDictionaryDataChanged?.Invoke(null, args));
}
catch
{
}
}
public Product Get(int id)
{
using (ShopEntities entities = new ShopEntities())
{
return(entities.Products.FirstOrDefault(e => e.ProductID == id));
}
}
/// <summary>
/// 网站启动的时候初始化字典
/// </summary>
public void InitList()
{
using (var db = new ShopEntities())
{
fdataDictionaries = db.FDataDictionary.Include("DataDictionary").ToList();
}
}
public ActionResult XoaHang(int id)
{
if (Session["MaTKAdmin"] == null)
{
return(RedirectToAction("Login", "Admin"));
}
else
{
try
{
ShopEntities shop = new ShopEntities();
var hang = shop.HangSanXuats.Single(s => s.MaHang == id);
var dsChiTietSP = shop.ChiTietSanPhams.Where(c => c.MaNhaSanXuat == id).ToList();
foreach (var item in dsChiTietSP)
{
var sp = shop.SanPhams.SingleOrDefault(s => s.MaSanPham == item.MaSanPham);
shop.ChiTietSanPhams.Remove(item);
shop.SanPhams.Remove(sp);
shop.SaveChanges();
}
shop.HangSanXuats.Remove(hang);
shop.SaveChanges();
return(Json(JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
return(RedirectToAction("Index"));
}
}
}
public ActionResult XoaHoaDonNhap(int id)
{
if (Session["MaTKAdmin"] == null)
{
return(RedirectToAction("Login", "Admin"));
}
else
{
try
{
ShopEntities shop = new ShopEntities();
var hoaDon = shop.HoaDonNhaps.Single(s => s.MaHoaDon == id);
var dsChiTiet = shop.ChiTietHoaDonNhaps.Where(c => c.MaHoaDon == id).ToList();
foreach (var item in dsChiTiet)
{
var sp = shop.SanPhams.SingleOrDefault(s => s.MaSanPham == item.MaSanPham);
if (sp != null)
{
sp.SoLuong = sp.SoLuong - item.SoLuong;
}
shop.ChiTietHoaDonNhaps.Remove(item);
shop.SaveChanges();
}
shop.HoaDonNhaps.Remove(hoaDon);
shop.SaveChanges();
return(Json(new { dt = true }, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
return(RedirectToAction("Index"));
}
}
}
public ActionResult LayCongTrinh(int maCongTrinh)
{
if (Session["MaTKAdmin"] == null)
{
return(RedirectToAction("Login", "Admin"));
}
else
{
try
{
ShopEntities shop = new ShopEntities();
JsonSerializerSettings jss = new JsonSerializerSettings {
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
};
CongTrinhNoiBat tt = shop.CongTrinhNoiBats.Single(t => t.MaCT == maCongTrinh);
var result = JsonConvert.SerializeObject(tt, Formatting.Indented, jss);
return(this.Json(result, JsonRequestBehavior.AllowGet));;
}
catch (Exception)
{
return(RedirectToAction("Index"));
}
}
}
public ActionResult XoaSanPham(int id)
{
if (Session["MaTKAdmin"] == null)
{
return(RedirectToAction("Login", "Admin"));
}
else
{
try
{
ShopEntities shop = new ShopEntities();
var ct = shop.ChiTietHoaDonNhaps.SingleOrDefault(c => c.Id == id);
var sp = shop.SanPhams.SingleOrDefault(s => s.MaSanPham == ct.MaSanPham);
sp.SoLuong = sp.SoLuong - ct.SoLuong;
shop.ChiTietHoaDonNhaps.Remove(ct);
shop.SaveChanges();
return(Json(JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
return(RedirectToAction("Index"));
}
}
}
public ActionResult DangKi(TaiKhoan tk)
{
ShopEntities shop = new ShopEntities();
if (ModelState.IsValid)
{
var tkk = shop.TaiKhoans.SingleOrDefault(t => t.Email.Trim().ToLower() == tk.Email.Trim().ToLower());
if (tkk != null)
{
ModelState.AddModelError("", "Email đã tồn tại");
}
else
{
if (KiemTraEmail(tk.Email) == false)
{
ModelState.AddModelError("", "Email không đúng định dạng");
}
else
{
TaiKhoan taiKhoan = new TaiKhoan();
taiKhoan.LoaiTaiKhoan = 2;
taiKhoan.TenTaiKhoan = tk.TenTaiKhoan;
taiKhoan.Email = tk.Email;
taiKhoan.MatKhau = tk.MatKhau;
shop.TaiKhoans.Add(taiKhoan);
shop.SaveChanges();
}
}
}
return(View("DangNhap"));
}
public ActionResult ThemHoaDonNhap(QuanLyHoaDonNhap qlhd)
{
if (Session["MaTKAdmin"] == null)
{
return(RedirectToAction("Login", "Admin"));
}
else
{
try
{
ShopEntities shop = new ShopEntities();
HoaDonNhap hoaDon = new HoaDonNhap();
hoaDon.MaNhaPhanPhoi = qlhd.HoaDonNhap.MaNhaPhanPhoi;
hoaDon.NgayTao = DateTime.Now;
hoaDon.KieuThanhToan = qlhd.HoaDonNhap.KieuThanhToan;
hoaDon.MaTaiKhoan = int.Parse(Session["MaTKAdmin"].ToString());
shop.HoaDonNhaps.Add(hoaDon);
shop.SaveChanges();
var hoaDonMoi = (from h in shop.HoaDonNhaps orderby h.MaHoaDon descending select h).FirstOrDefault();
return(RedirectToAction("ChiTietHoaDonNhap", new { id = hoaDonMoi.MaHoaDon }));
}
catch (Exception)
{
return(RedirectToAction("Index"));
}
}
}
//
// GET: /Manage/Index
public async Task <ActionResult> Index(ManageMessageId?message)
{
ViewBag.StatusMessage =
message == ManageMessageId.ChangePasswordSuccess ? "Your password has been changed."
: message == ManageMessageId.SetPasswordSuccess ? "Your password has been set."
: message == ManageMessageId.SetTwoFactorSuccess ? "Your two-factor authentication provider has been set."
: message == ManageMessageId.Error ? "An error has occurred."
: message == ManageMessageId.AddPhoneSuccess ? "Your phone number was added."
: message == ManageMessageId.RemovePhoneSuccess ? "Your phone number was removed."
: "";
var userId = User.Identity.GetUserId();
var customerDetail = new ShopEntities().CustomerDetails.Where(c => c.UserId.Equals(userId)).FirstOrDefault();
//if (customerDetail != null)
//{
// ViewBag.customerFullName = customerDetail.FirstName + " " + customerDetail.LastName;
//}
var model = new IndexViewModel
{
HasPassword = HasPassword(),
PhoneNumber = await UserManager.GetPhoneNumberAsync(userId),
TwoFactor = await UserManager.GetTwoFactorEnabledAsync(userId),
Logins = await UserManager.GetLoginsAsync(userId),
BrowserRemembered = await AuthenticationManager.TwoFactorBrowserRememberedAsync(userId),
CustomerDetails = customerDetail
};
return(View(model));
}
public ActionResult ThemVaoGioHang(int id, int soLuong)
{
ShopEntities db = new ShopEntities();
var p = db.SanPhams.SingleOrDefault(s => s.MaSanPham.Equals(id));
decimal? gia = 0;
gia = p.GiaGiam > 0 ? p.GiaGiam : p.Gia;
if (p != null)
{
ShoppingCart objCart = (ShoppingCart)Session["Cart"];
if (objCart == null)
{
objCart = new ShoppingCart();
}
ShoppingCart.ShoppingCartItem item = new ShoppingCart.ShoppingCartItem()
{
Image = p.AnhDaiDien,
ProductName = p.TenSanPham,
ProductID = p.MaSanPham,
Price = gia.ToString(),
Quanlity = soLuong,
Total = Convert.ToDouble(gia.ToString().Trim().Replace(",", string.Empty).Replace(".", string.Empty)) * soLuong
};
objCart.AddToCart(item);
Session["Cart"] = objCart;
}
JsonSerializerSettings jss = new JsonSerializerSettings {
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
};
var result = JsonConvert.SerializeObject("Thêm thành công", Formatting.Indented, jss);
return(this.Json(result, JsonRequestBehavior.AllowGet));;
}
/// <summary>
/// 删除父级
/// </summary>
/// <param name="id">父级ID</param>
public void DeleteF(int id)
{
var args = new DataDictionaryDataChangedArgs
{
DictionaryChangeType = ChangeType.Delete
};
using (var db = new ShopEntities())
{
var entity = db.FDataDictionary.FirstOrDefault(p => p.FDictionaryID == id) ?? throw new OperateException("数据库中不存在此父级");
List <DataDictionary> chirenData = entity.DataDictionary.ToList();
db.DataDictionary.RemoveRange(chirenData);
db.FDataDictionary.Remove(entity);
db.SaveChanges();
args.Add(entity);
foreach (var item in chirenData)
{
args.Add(item);
}
}
try
{
Task.Run(() => DataDictionaryDataChanged?.Invoke(null, args));
}
catch
{
}
}
public ActionResult ThemSanPhamPhanPhoi(string sppp)
{
if (Session["MaTKAdmin"] == null)
{
return(RedirectToAction("Login", "Admin"));
}
else
{
try
{
ShopEntities shop = new ShopEntities();
string[] dsSanPham = sppp.Split(',');
var npp = shop.NhaPhanPhois.SingleOrDefault(n => n.MaNhaPhanPhoi == maNPP);
if (dsSanPham.Length > 0)
{
foreach (string t in dsSanPham)
{
var id = int.Parse(t);
var sp = shop.SanPhams.SingleOrDefault(s => s.MaSanPham == id);
npp.SanPhams.Add(sp);
shop.SaveChanges();
}
}
//Response.Redirect("SanPhamPhanPhoi/?id=" + maNPP + "");
//return View("SanPhamPhanPhoi");
return(Json(new { dt = true }, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
return(RedirectToAction("Index"));
}
}
}
/// <summary>
/// 编辑父级字典
/// </summary>
/// <param name="changedDataDictionary">父级实体对象</param>
public void Edit(FDataDictionary changedDataDictionary)
{
var args = new DataDictionaryDataChangedArgs
{
DictionaryChangeType = ChangeType.Edit
};
using (var db = new ShopEntities())
{
var entity = db.FDataDictionary.Where(p => p.FDictionaryID == changedDataDictionary.FDictionaryID).FirstOrDefault() ?? throw new OperateException("指定的字典父级已删除");
var data = db.FDataDictionary.Where(p => p.Argument == changedDataDictionary.Argument).FirstOrDefault();
if (entity.Argument != changedDataDictionary.Argument && data != null)
{
throw new OperateException("已存在同值父级");
}
db.Entry(entity).State = EntityState.Detached;
db.Entry(db.FDataDictionary.Attach(changedDataDictionary)).State = EntityState.Modified;
db.SaveChanges();
args.Add(changedDataDictionary);
}
try
{
Task.Run(() => DataDictionaryDataChanged?.Invoke(null, args));
}
catch
{
}
}
public IPagedList <NhaPhanPhois> KhoiTao(string searchString, int?page)
{
ViewBag.CurrentFilter = searchString;
ShopEntities shop = new ShopEntities();
var dsNhaPP = shop.NhaPhanPhois.ToList();
var dsSanPham = shop.SanPhams.ToList();
List <SelectListItem> slSP = new List <SelectListItem>();
for (int i = 0; i < dsSanPham.Count; i++)
{
SelectListItem sl = new SelectListItem()
{
Text = dsSanPham[i].TenSanPham, Value = dsSanPham[i].MaSanPham.ToString()
};
slSP.Add(sl);
}
ViewBag.SP = slSP;
int pageSize = 10;
int pageNumber = (page ?? 1);
dsNhaPP.ToPagedList(pageNumber, pageSize);
return(dsNhaPP.ToPagedList(pageNumber, pageSize));
}
public SimpleMembershipInitializer()
{
Database.SetInitializer<ShopEntities>(null);
try
{
using (var context = new ShopEntities())
{
if (!context.Database.Exists())
{
// Create the SimpleMembership database without Entity Framework migration schema
((IObjectContextAdapter)context).ObjectContext.CreateDatabase();
}
WebSecurity.InitializeDatabaseConnection("Membership", "Admins", "ID", "Username", autoCreateTables: true);
if (!Roles.RoleExists("StorageOperator"))
Roles.CreateRole("StorageOperator");
if (!Roles.RoleExists("ShopOperator"))
Roles.CreateRole("ShopOperator");
if (!Roles.RoleExists("ShopManager"))
Roles.CreateRole("ShopManager");
if (!WebSecurity.UserExists("kote"))
WebSecurity.CreateUserAndAccount("kote", "123456");
if (!WebSecurity.UserExists("kikola"))
WebSecurity.CreateUserAndAccount("kikola", "123456");
if (!WebSecurity.UserExists("jilberta"))
WebSecurity.CreateUserAndAccount("jilberta", "123456");
if (!WebSecurity.UserExists("shota"))
WebSecurity.CreateUserAndAccount("shota", "123456");
if (!WebSecurity.UserExists("misha"))
WebSecurity.CreateUserAndAccount("misha", "123456");
if (!Roles.IsUserInRole("kote", "StorageOperator"))
Roles.AddUserToRole("kote", "StorageOperator");
if (!Roles.IsUserInRole("kikola", "ShopOperator"))
Roles.AddUserToRole("kikola", "ShopOperator");
if (!Roles.IsUserInRole("jilberta", "ShopManager"))
Roles.AddUserToRole("jilberta", "ShopManager");
if (!Roles.IsUserInRole("shota", "ShopOperator"))
Roles.AddUserToRole("shota", "ShopOperator");
if (!Roles.IsUserInRole("misha", "ShopOperator"))
Roles.AddUserToRole("misha", "ShopOperator");
}
}
catch (Exception ex)
{
throw new InvalidOperationException("The ASP.NET Simple Membership database could not be initialized. For more information, please see http://go.microsoft.com/fwlink/?LinkId=256588", ex);
}
}
