public ActionResult DangNhap(FormCollection collection)
{
var sdt = collection["SDT"];
if (String.IsNullOrEmpty(sdt))
{
ViewData["Loi1"] = "* Bắt buộc";
}
else
{
QuanLy NV = data.QuanLies.SingleOrDefault(n => n.SDT == sdt);
if (NV != null)
{
Session["SDT"] = NV.SDT;
Session["MaNV"] = NV.MaNV;
Session["TenNhanVien"] = NV.TenNhanVien;
Session["MaChiNhanh"] = NV.MaChiNhanh;
var machinhanh = NV.MaChiNhanh;
ChiNhanh CN = data.ChiNhanhs.SingleOrDefault(n => n.MaChiNhanh == machinhanh);
Session["TenChiNhanh"] = CN.TenChiNhanh;
Session["NamSinh"] = NV.NamSinh;
return(RedirectToAction("Index", "ChiNhanh_Z9TheCoffee"));
}
else
{
ViewBag.ThongBao = "Số Điện Thoại không tồn tại";
}
}
return(View());
}
private void LoadSetting() // cài đặt begin
{
ChiNhanh chinhanh = new ChiNhanh();
tenchinhanh = chinhanh.getChiNhanh();
if (tenchinhanh == null)
{
MessageBox.Show("Lỗi CDSL! Không thể lấy danh sách chi nhánh");
return;
}
else if (tenchinhanh.Rows.Count == 0)
{
MessageBox.Show("Trong CSDL không có chi nhánh nào . ");
return;
}
foreach (DataRow dr in tenchinhanh.Rows)
{
Connection cnn = new Connection()
{
ChiNhanh = dr["ChiNhanh"].ToString(),
DataSource = dr["DATASOURCE"].ToString(),
MaCN = dr["MACN"].ToString(),
DIACHI = dr["DIACHI"].ToString(),
SoDT = dr["SoDT"].ToString()
};
Access.CnnList.Add(cnn);
}
}
public IHttpActionResult Create(TaoChiNhanh cNModel)
{
IHttpActionResult httpActionResult;
if (string.IsNullOrEmpty(cNModel.TenChiNhanh))
{
error.Add("Tên chi nhánh không được phép NULL");
}
if (error.Errors.Count == 0)
{
ChiNhanh chiNhanh = new ChiNhanh();
chiNhanh.ChiNhanhId = cNModel.ChiNhanhId;
chiNhanh.TenChiNhanh = cNModel.TenChiNhanh;
chiNhanh.NgayThanhLap = cNModel.NgayThanhLap;
chiNhanh.DiaChi = cNModel.DiaChi;
chiNhanh = db.ChiNhanhs.Add(chiNhanh);
db.SaveChanges();
ChiNhanhModel chiNhanh_Model = new ChiNhanhModel(chiNhanh);
httpActionResult = Ok(chiNhanh_Model);
}
else
{
httpActionResult = new ErrorActionResult(Request, HttpStatusCode.BadRequest, error);
}
return(httpActionResult);
}
//Tìm kiếm
public static List <MuonSachView> TimKiemTheoMaPhieu(string p)
{
List <MuonSachView> phieus = new List <MuonSachView>();
using (IDocumentSession session = store.OpenSession()) // Open a session for a default 'Database'
{
List <PhieuMuonSachSV> phieu = session
.Query <PhieuMuonSachSV>() // Query for Products
.Include(x => x.DocGia)
.Include(x => x.Sach)
.Include(x => x.ChiNhanh)
.Where(x => x.MaPhieu == p) // Filter
.ToList(); // Materialize query
foreach (PhieuMuonSachSV x in phieu)
{
DocGiaSV dg = session.Load <DocGiaSV>(x.DocGia);
ChiNhanh cn = session.Load <ChiNhanh>(x.ChiNhanh);
Sach s = session.Load <Sach>(x.Sach);
MuonSachView detail = new MuonSachView
{
MaPhieu = x.MaPhieu,
TenDG = dg.TenDG,
TenSach = s.TenSach,
TenChiNhanh = cn.TenChiNhanh,
SoLuongMuon = x.SoLuongMuon,
NgayMuon = x.NgayMuon
};
phieus.Add(detail);
}
}
return(phieus);
}
public async System.Threading.Tasks.Task <ActionResult> ThemGianHang(ThemGianHang gianhang)
{
var userstore = new UserStore <ApplicationUser>(db);
var userManager = new UserManager <ApplicationUser>(userstore);
var trans = db.Database.BeginTransaction();
//Chi nhánh
var chinhanh = new ChiNhanh {
MaCN = "GianHang-" + gianhang.UserName, Name = "GianHang-" + gianhang.UserName, DiaChi = gianhang.DiaChi, Email = gianhang.Email, SDT = gianhang.SDT, Date = DateTime.Now
};
db.ChiNhanhs.Add(chinhanh);
db.SaveChanges();
var user = new ApplicationUser {
UserName = gianhang.UserName, Email = gianhang.Email, Address = gianhang.DiaChi, Birthday = DateTime.Now, FullName = gianhang.FullName, PhoneNumber = gianhang.SDT, MaCN = "GianHang-" + gianhang.UserName, Active = true, Experience = 0, NgayDangKy = DateTime.Now
};
var result = await userManager.CreateAsync(user, gianhang.Password);
if (result.Succeeded)
{
var cn = new ChiNhanh {
MaCN = "GianHang-" + gianhang.UserName, Name = "GianHang-" + gianhang.UserName, DiaChi = gianhang.DiaChi, Email = gianhang.Email, SDT = gianhang.SDT, Date = DateTime.Now
};
Configuration.ThemCuaHang(user, chinhanh);
trans.Commit();
}
else
{
trans.Rollback();
}
return(View(gianhang));
}
public JsonResult AddChiNhanh(string UserName)
{
int result = 0;
var admin = kiemtra.getUser(UserName);
var chinhanh = new ChiNhanh {
MaCN = "ChiNhanh-" + admin.UserName, SoTaiKhoan = "0", Name = "HUTECH", Email = "h", DiaChi = "Đang cập nhật", SDT = "Đang cập nhật", Date = DateTime.Now
};
db.ChiNhanhs.Add(chinhanh);
try
{
db.SaveChanges();
admin.MaCN = "ChiNhanh-" + admin.UserName;
db = ShopEntities.CreateEntitiesForSpecificDatabaseName(chinhanh.MaCN);
db.Database.CreateIfNotExists();
db.ChiNhanhs.Add(chinhanh);
db.SaveChanges();
result = 1;
}
catch (Exception e)
{
log.Error("Đổi chi nhánh cho admin công ty lỗi: " + e.Message);
return(Json(new { result }));
}
return(Json(new { result }));
}
public ChiNhanhModel(ChiNhanh cn)
{
this.Id = cn.Id;
this.ChiNhanhId = cn.ChiNhanhId;
this.TenChiNhanh = cn.TenChiNhanh;
this.DiaChi = cn.DiaChi;
this.NgayThanhLap = cn.NgayThanhLap;
}
public ActionResult DeleteConfirmed(int id)
{
ChiNhanh chiNhanh = db.ChiNhanhs.Find(id);
db.ChiNhanhs.Remove(chiNhanh);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public bool Insert(ChiNhanh chinhanh)
{
try
{
cf.ChiNhanhs.Add(chinhanh);
cf.SaveChanges();
return(true);
}
catch { return(false); }
}
public ActionResult CreateChiNhanh(ChiNhanhModel model)
{
var chinhanh = new ChiNhanh();
chinhanh.TenChiNhanh = model.TenChiNhanh;
chinhanh.DiaChi = model.DiaChi;
chinhanh.GhiChu = model.GhiChu;
new ChiNhanhDao().Insert(chinhanh);
return(RedirectToAction("Index", "ChiNhanhAdmin"));
}
public ActionResult Edit([Bind(Include = "MaCN,TenCN,DiaChi,SoDT")] ChiNhanh chiNhanh)
{
if (ModelState.IsValid)
{
db.Entry(chiNhanh).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(chiNhanh));
}
public IActionResult Edit(ChiNhanh Model)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
context.ChiNhanhs.Update(Model);
context.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Include = "MaCN,TenCN,DiaChi,SoDT")] ChiNhanh chiNhanh)
{
if (ModelState.IsValid)
{
db.ChiNhanhs.Add(chiNhanh);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(chiNhanh));
}
public async Task <IActionResult> Create(ChiNhanh chiNhanh)
{
if (ModelState.IsValid)
{
_unitOfWork.chiNhanhRepository.Create(chiNhanh);
await _unitOfWork.Complete();
return(RedirectToAction(nameof(Index)));
}
return(View(chiNhanh));
}
public int AddChiNhanh(ChiNhanhModel cn)
{
var chinhanh = new ChiNhanh();
chinhanh.TenChiNhanh = cn.TenChiNhanh;
chinhanh.DiaChi = cn.DiaChi;
chinhanh.Lat = cn.Lat;
chinhanh.Lng = cn.Lng;
db.ChiNhanhs.Add(chinhanh);
db.SaveChanges();
return(chinhanh.Id);
}
public IHttpActionResult DeleteChiNhanh(int id)
{
ChiNhanh chiNhanh = db.ChiNhanhs.Find(id);
if (chiNhanh == null)
{
return(NotFound());
}
db.ChiNhanhs.Remove(chiNhanh);
db.SaveChanges();
return(Ok(chiNhanh));
}
// GET: ChiNhanhs/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ChiNhanh chiNhanh = db.ChiNhanhs.Find(id);
if (chiNhanh == null)
{
return(HttpNotFound());
}
return(View(chiNhanh));
}
//Load phiếu
public static List <MuonSachView> List(string id)
{
List <MuonSachView> res = new List <MuonSachView>();
using (IDocumentSession session = store.OpenSession())
{
List <PhieuMuonSachSV> sv;
if (id != null)
{
sv = session
.Query <PhieuMuonSachSV>()
.Where(x => x.Id == id)
.Include(x => x.DocGia)
.Include(x => x.Sach)
.Include(x => x.ChiNhanh)
.ToList <PhieuMuonSachSV>();
}
else
{
sv = session
.Query <PhieuMuonSachSV>()
.Include(x => x.DocGia)
.Include(x => x.Sach)
.Include(x => x.ChiNhanh)
.ToList <PhieuMuonSachSV>();
}
foreach (PhieuMuonSachSV pms in sv)
{
DocGiaSV dg = session.Load <DocGiaSV>(pms.DocGia);
ChiNhanh cn = session.Load <ChiNhanh>(pms.ChiNhanh);
Sach s = session.Load <Sach>(pms.Sach);
MuonSachView detail = new MuonSachView
{
Id = pms.Id,
MaPhieu = pms.MaPhieu,
TenDG = dg.TenDG,
TenSach = s.TenSach,
TenChiNhanh = cn.TenChiNhanh,
SoLuongMuon = pms.SoLuongMuon,
NgayMuon = pms.NgayMuon
};
res.Add(detail);
}
}
return(res);
}
public ActionResult Edit(ChiNhanh model)
{
if (ModelState.IsValid)
{
SetViewBag(model.ID);
var kq = new BrandDao().Update(model);
if (kq)
{
return(Redirect("/Admin/Brand/DSChiNhanh"));
}
}
SetViewBag();
return(View(model));
}
public IActionResult Edit(ChiNhanh Model)
{
//phân quyền
if (HttpContext.Session.GetString("TaiKhoanNv") == null)
{
return(RedirectToAction("Login", "NhanVien"));
}
//
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
context.ChiNhanhs.Update(Model);
context.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult ChiNhanh(ChiNhanh cn, HttpPostedFileBase pic)
{
ThongBaoMvc thongbao;
var chinhanh = db.ChiNhanhs.FirstOrDefault(x => x.MaCN.Equals(cn.MaCN));
if (pic != null)
{
var pathfile = Server.MapPath("~/Content/Images/") + cn.MaCN + "/" + Path.GetFileNameWithoutExtension(pic.FileName);
var job = new ImageJob(pic, pathfile, new Instructions("model=max;format=png;width=100;height=300;"));
job.CreateParentDirectory = true;// tạo folder nếu chưa có
job.AddFileExtension = true;
job.Build();
chinhanh.Logo = Path.GetFileNameWithoutExtension(pic.FileName) + ".png";
}
chinhanh.Name = cn.Name;
chinhanh.DiaChi = cn.DiaChi;
chinhanh.Email = cn.Email;
chinhanh.FaceBook = cn.FaceBook;
chinhanh.Fax = cn.Fax;
chinhanh.SDT = cn.SDT;
chinhanh.SoTaiKhoan = cn.SoTaiKhoan;
chinhanh.WebSite = cn.WebSite;
try
{
db.SaveChanges();
thongbao = new ThongBaoMvc {
CssClassName = "success", Message = "Thay đổi thông tin chi nhánh thành công."
};
TempData["ResultAction"] = thongbao;
return(View(chinhanh));
}
catch (Exception ex)
{
thongbao = new ThongBaoMvc {
CssClassName = "danger", Message = "Lỗi."
};
TempData["ResultAction"] = thongbao;
log.Error("Lỗi khi sửa thông tin chi nhánh: " + ex.Message);
}
return(View(cn));
}
public async Task <IActionResult> Edit(int id, ChiNhanh chinhanh)
{
if (id != chinhanh.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
_unitOfWork.chiNhanhRepository.Update(chinhanh);
await _unitOfWork.Complete();
return(RedirectToAction(nameof(Index)));
}
return(View(chinhanh));
}
public bool Update(ChiNhanh model)
{
try
{
var food = cf.ChiNhanhs.Find(model.ID);
food.Name = model.Name;
food.Image = model.Image;
food.Address = model.Address;
food.Description = model.Description;
cf.SaveChanges();
return(true);
}
catch { return(false); }
}
public IHttpActionResult Update(CapNhatChiNhanh cNModel)
{
IHttpActionResult httpActionResult;
ChiNhanh chiNhanh = db.ChiNhanhs.FirstOrDefault(x => x.Id == cNModel.Id);
if (chiNhanh == null)
{
error.Add("Không tìm thấy chi nhánh");
httpActionResult = new ErrorActionResult(Request, HttpStatusCode.BadRequest, error);
}
else
{
chiNhanh.TenChiNhanh = cNModel.TenChiNhanh ?? cNModel.TenChiNhanh;
chiNhanh.DiaChi = cNModel.DiaChi ?? cNModel.DiaChi;
db.Entry(chiNhanh).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
httpActionResult = Ok(new ChiNhanhModel(chiNhanh));
}
return(httpActionResult);
}
public async Task <ActionResult> Login(LoginViewModel model, string returnUrl)
{
if (!ModelState.IsValid)
{
return(View(model));
}
// This doesn't count login failures towards account lockout
// To enable password failures to trigger account lockout, change to shouldLockout: true
var result = await SignInManager.PasswordSignInAsync(model.UserName, model.Password, model.RememberMe, shouldLockout : false);
switch (result)
{
case SignInStatus.Success:
{
if (User.IsInRole("Staff"))
{
KiemTra kiemtra = new KiemTra();
var user = kiemtra.getUser(User.Identity.Name);
if (user.Active == false)
{
return(View(model));
}
}
if (User.IsInRole("Admin"))
{
KiemTra kiemtra = new KiemTra();
var user = kiemtra.getUser(User.Identity.Name);
if (user.Active == false && user.MaCN.Split('-')[0].Equals("ChiNhanh"))
{
return(View(model));
}
if (ShopEntities.CreateEntitiesForSpecificDatabaseName(user.MaCN).Database.CreateIfNotExists())
{
var chinhanh = db.ChiNhanhs.FirstOrDefault(x => x.MaCN.Equals(user.MaCN));
var cn = new ChiNhanh {
Date = chinhanh.Date, DiaChi = chinhanh.DiaChi, Email = chinhanh.Email, FaceBook = chinhanh.FaceBook, Fax = chinhanh.Fax, Logo = chinhanh.Logo, MaCN = chinhanh.MaCN, Name = chinhanh.Name, SDT = chinhanh.SDT, SoTaiKhoan = chinhanh.SoTaiKhoan, WebSite = chinhanh.WebSite
};
Configuration.ThemCuaHang(user, cn);
}
}
if (returnUrl != "")
{
return(RedirectToLocal(returnUrl));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
case SignInStatus.LockedOut:
return(View("Lockout"));
case SignInStatus.RequiresVerification:
return(RedirectToAction("SendCode", new { ReturnUrl = returnUrl, RememberMe = model.RememberMe }));
case SignInStatus.Failure:
default:
ModelState.AddModelError("", "Invalid login attempt.");
return(View(model));
}
}
public async Task <ActionResult> Register(RegisterViewModel model)
{
if (ModelState.IsValid)
{
int madangky = model.madangky.HasValue ? model.madangky.Value : 1;
//Chi nhánh
var chinhanh = new ChiNhanh {
MaCN = "GianHang-" + model.UserName, Name = "GianHang-" + model.UserName, DiaChi = model.Address, Email = model.Email, SDT = model.SDT, Date = DateTime.Now
};
db.ChiNhanhs.Add(chinhanh);
//Hợp đồng
var user = new ApplicationUser {
UserName = model.UserName, Email = model.Email, Address = model.Address, Birthday = model.Birthday, FullName = model.FullName, PhoneNumber = model.SDT, Active = true, Experience = 0, NgayDangKy = DateTime.Now
};
var result = await UserManager.CreateAsync(user, model.Password);
if (result.Succeeded)
{
db.SaveChanges();
user.MaCN = chinhanh.MaCN;
UserManager.AddToRole(user.Id, "Admin");
await SignInManager.SignInAsync(user, isPersistent : false, rememberBrowser : false);
var cn = new ChiNhanh {
MaCN = "GianHang-" + model.UserName, Name = "GianHang-" + model.UserName, DiaChi = model.Address, Email = model.Email, SDT = model.SDT, Date = DateTime.Now
};
var user1 = new ApplicationUser {
UserName = model.UserName, Email = model.Email, Address = model.Address, Birthday = model.Birthday, FullName = model.FullName, PhoneNumber = model.SDT, MaCN = "GianHang-" + model.UserName, Active = true, Experience = 0, NgayDangKy = DateTime.Now
};
Configuration.ThemCuaHang(user1, cn);
var hopdong = new HopDongChiNhanh {
MaCN = chinhanh.MaCN, MaLoaiGianHang = 1, BeginDate = DateTime.Now, EndDate = DateTime.Now.AddDays(7)
};
db.HopDongChiNhanhs.Add(hopdong);
db.SaveChanges();
if (madangky != 1)
{
DangKyBaoKim(madangky);
}
// For more information on how to enable account confirmation and password reset please visit http://go.microsoft.com/fwlink/?LinkID=320771
// Send an email with this link
// string code = await UserManager.GenerateEmailConfirmationTokenAsync(user.Id);
// var callbackUrl = Url.Action("ConfirmEmail", "Account", new { userId = user.Id, code = code }, protocol: Request.Url.Scheme);
// await UserManager.SendEmailAsync(user.Id, "Confirm your account", "Please confirm your account by clicking <a href=\"" + callbackUrl + "\">here</a>");
return(RedirectToAction("Index", "Home"));
}
AddErrors(result);
db.ChiNhanhs.Remove(chinhanh);
db.SaveChanges();
}
// If we got this far, something failed, redisplay form
return(View(model));
}
private void btnDangNhap_Click(object sender, EventArgs e)
{
try
{
CheckEmpty();
Connection cnn = Access.CnnList[comboBox1.SelectedIndex];
Access.DATA_SOURCE = cnn.DataSource;
Access.MACN = cnn.MaCN;
string username = tboxTaiKhoan.Text.Trim();
string password = tboxMatKhau.Text.Trim();
Access.USERNAME = username;
Access.PASSWORD = password;
if (!Access.Connect())
{
MessageBox.Show("Tài khoản hoặc mật khẩu của bạn đã sai !!!");
return;
}
else
{
try
{
string[] param = { username };
ChiNhanh chinhanh = new ChiNhanh();
reader = chinhanh.getLogin(param);
reader.Read();
if (reader.HasRows)
{
Console.WriteLine(reader["MANV"].ToString() + reader["HOTEN"].ToString() + reader["ROLE"].ToString());
Access.ROLE = reader["ROLE"].ToString();
Access.HOTEN = reader["HOTEN"].ToString();
Access.MANV = reader["MANV"].ToString();
if (Access.ROLE == "ChiNhanh")
{
MessageBox.Show("Đăng Nhập Thành Công");
Program.fmain.HienThiQuyen_ChiNhanh();
}
if (Access.ROLE == "CongTy")
{
MessageBox.Show("Đăng Nhập Thành Công");
Program.fmain.HienThiQuyen_CongTy();
}
if (Access.ROLE == "User")
{
MessageBox.Show("Đăng Nhập Thành Công");
Program.fmain.HienThiQuyen_User();
}
}
else
{
MessageBox.Show("Nhân viên này đã nghỉ. Không thể đăng nhập");
}
reader.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex + "Sai thông tin tài khoản");
}
}
}
catch
{
MessageBox.Show("Không Tồn Tại Server này!!!. Mời bạn chọn lại ");
}
}
public bool UpdateChiNhanh(ChiNhanh newCn, int idCH)
{
bool result = new ProjectDAO().UpdateChiNhanh(newCn, idCH);
return(result);
}
public bool AddChiNhanh(ChiNhanh newCn)
{
bool result = new ProjectDAO().AddChiNhanh(newCn);
return(result);
}
public void Insert(ChiNhanh chinhanh)
{
db.ChiNhanhs.Add(chinhanh);
db.SaveChanges();
}
