/// <summary> /// Xóa /// </summary> /// <modified> /// Author Date Comments /// TrungNQ 01/09/2017 Tạo mới /// </modified> /// <param name="id">Id bản ghi</param> /// <returns></returns> public JsonResult Delete(string id) { var obj = new tblGate(); var listPC = _tblPCService.GetAllByGateId(id); if (listPC.Any()) { var message = new MessageReport(); message.isSuccess = false; message.Message = FunctionHelper.GetLocalizeDictionary("Home", "notification")["Message_del_fail_computer"]; return(Json(message, JsonRequestBehavior.AllowGet)); } var result = _tblGateService.DeleteById(id, ref obj); if (result.isSuccess) { WriteLog.Write(result, GetCurrentUser.GetUser(), obj.GateID.ToString(), obj.GateName, "tblGate", ConstField.ParkingCode, ActionConfigO.Delete); } return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult Create(tblLockerPC obj, string TypeSelect, bool SaveAndCountinue = false) { ViewBag.urlValue = url ?? Request.Url.PathAndQuery; if (!ModelState.IsValid) { ModelState.AddModelError("", "Tạo dữ liệu không thành công. Hãy kiểm tra lại dữ liệu nhập vào"); return View(obj); } obj.Id = Guid.NewGuid().ToString(); var report = _tblLockerPCService.Create(obj); if (report.isSuccess) { WriteLog.Write(report, GetCurrentUser.GetUser(), obj.Id.ToString(), obj.PCName, "tblLockerPC", ConstField.LockerCode, ActionConfigO.Create); TempData["Success"] = "Thêm mới thành công"; if (SaveAndCountinue) { return RedirectToAction("Create", "tblPC"); } return Redirect(url); } else { ModelState.AddModelError("", "Tạo dữ liệu không thành công. Hãy kiểm tra lại dữ liệu nhập vào"); return View(obj); } }
public async Task <ActionResult> MesajimGoster(string id) { LoggedUserModel lgm = GetCurrentUser.GetUser(); List <object> nesneler = new List <object>(); var kl = db.kullanicilar.Where(e => e.flag == durumlar.aktif && e.firma_id == lgm.firma_id && e.id != lgm.id).ToListAsync(); var m = db.mesajlar.Where(e => e.flag != durumlar.silindi && e.url.Equals(id)).FirstOrDefaultAsync(); await Task.WhenAll(kl, m); List <kullanicilar> kullaniciList = kl.Result; mesajlar msj = m.Result; if (msj == null) { msj = new mesajlar(); } List <mesajlar> mesajList = db.mesajlar.Where(e => e.flag != durumlar.silindi && e.parent_url.Equals(msj.parent_url)).OrderByDescending(e => e.date).Take(mesajSize).ToList(); nesneler.Add(kullaniciList); nesneler.Add(msj); nesneler.Add(mesajList.OrderBy(e => e.date).ToList()); nesneler.Add(lgm); if (msj.alan_id == lgm.id) { mesajIslemleri.okunduIsaretle(msj.parent_url); } return(View(nesneler)); }
private void HistoryDeleteEventFormatCell(DataTable dtData, string excelcol, string filename = "", string sheetname = "", string comments = "", string titleSheet = "", string titleTime = "") { //Nội dung đầu trang var user = GetCurrentUser.GetUser(); var timeSearch = "Từ " + titleTime.Split(new[] { '-' })[0] + " đến " + titleTime.Split(new[] { '-' })[1]; var dtHeader = _tblSystemConfigService.getHeaderExcel(titleSheet, timeSearch, user.Username); //Header var listColumn = new List <SelectListModel>(); listColumn.Add(new SelectListModel { ItemText = "STT", ItemValue = "STT" }); listColumn.Add(new SelectListModel { ItemText = "Ngày xóa", ItemValue = "CardNo" }); listColumn.Add(new SelectListModel { ItemText = "Người xóa", ItemValue = "Mã thẻ" }); listColumn.Add(new SelectListModel { ItemText = "Số tiền", ItemValue = "Biển số" }); listColumn.Add(new SelectListModel { ItemText = "CardNo", ItemValue = "CardNo" }); listColumn.Add(new SelectListModel { ItemText = "Mã thẻ", ItemValue = "Mã thẻ" }); listColumn.Add(new SelectListModel { ItemText = "Biển số", ItemValue = "Biển số" }); listColumn.Add(new SelectListModel { ItemText = "Thời gian vào", ItemValue = "Thời gian vào" }); listColumn.Add(new SelectListModel { ItemText = "Thời gian ra", ItemValue = "Thời gian ra" }); listColumn.Add(new SelectListModel { ItemText = "Nhóm thẻ", ItemValue = "Nhóm thẻ" }); listColumn.Add(new SelectListModel { ItemText = "Khách hàng", ItemValue = "Khách hàng" }); listColumn.Add(new SelectListModel { ItemText = "Làn vào", ItemValue = "Làn vào" }); listColumn.Add(new SelectListModel { ItemText = "Làn ra", ItemValue = "Làn ra" }); listColumn.Add(new SelectListModel { ItemText = "Giám sát vào", ItemValue = "Giám sát vào" }); listColumn.Add(new SelectListModel { ItemText = "Giám sát ra", ItemValue = "Giám sát ra" }); //Xuất file ExportFile(dtData, listColumn, dtHeader, filename, sheetname, comments); }
private void FormatCell(DataTable dtData, string filename = "", string sheetname = "", string comments = "", string titleSheet = "") { var Dictionary = FunctionHelper.GetLocalizeDictionary("report", "reportIn"); var DictionarySearch = FunctionHelper.GetLocalizeDictionary("report", "reportSearch"); //Nội dung đầu trang var user = GetCurrentUser.GetUser(); var timeSearch = ""; var dtHeader = _tblSystemConfigService.getHeaderExcel(titleSheet, timeSearch, user.Username); //Header var listColumn = new List <SelectListModel>(); listColumn.Add(new SelectListModel { ItemText = Dictionary["stt"], ItemValue = "STT" }); listColumn.Add(new SelectListModel { ItemText = Dictionary["mainCard"], ItemValue = "Mã thẻ chính" }); listColumn.Add(new SelectListModel { ItemText = Dictionary["codeCard"], ItemValue = "Mã thẻ" }); listColumn.Add(new SelectListModel { ItemText = Dictionary["cardNo"], ItemValue = "CardNo" }); //Xuất file ExportFile(dtData, listColumn, dtHeader, filename, sheetname, comments); }
public JsonResult SaveDeleteEvent() { var host = Request.Url.Host; var result = new MessageReport(false, "Có lỗi xảy ra"); var list = GetSetFromSession(null); if (list != null && list.Count > 0) { var userid = GetCurrentUser.GetUser().Id; var check = _tblCardEventDeleteService.DeleteEvent(list, userid); if (check) { result = new MessageReport(true, "Xóa thành công"); Session[string.Format("{0}_{1}", SessionConfig.EventIdDelete108ParkingSession, host)] = new List <string>(); } else { result = new MessageReport(false, "Có lỗi xảy ra"); } } return(Json(result, JsonRequestBehavior.AllowGet)); }
public JsonResult Delete(string id) { var obj = new tblCamera(); //var listLand = _PK_LaneService.GetAllByCamera(id); //if (listLand.Any()) //{ // var message = new Result(); // message.Success = false; // message.Message = "Đang sử dụng trong làn vào ra. Không thể xóa"; // message.ErrorCode = 500; // return Json(message, JsonRequestBehavior.AllowGet); //} var result = _tblCameraService.DeleteById(id, ref obj); if (result.isSuccess) { WriteLog.Write(result, GetCurrentUser.GetUser(), obj.CameraID.ToString(), obj.CameraName, "tblCamera", ConstField.ParkingCode, ActionConfigO.Delete); } return(Json(result, JsonRequestBehavior.AllowGet)); }
public JsonResult sifreAyarlari(string current_password, string password, string password_control) { try { if (!password.Equals(password_control)) { return(Json(JsonSonuc.sonucUret(false, "Girdiğiniz şifreler eşleşmiyor. Lütfen şifrelerinizi kontrol edip tekrar deneyiniz."), JsonRequestBehavior.AllowGet)); } string sifre = HashWithSha.ComputeHash(current_password, "SHA512", Encoding.ASCII.GetBytes(current_password)); int id = GetCurrentUser.GetUser().id; kullanicilar dbUser = db.kullanicilar.Where(e => e.id == id && e.password == sifre && e.flag == durumlar.aktif).FirstOrDefault(); if (dbUser == null) { return(Json(JsonSonuc.sonucUret(false, "Mevcut şifreniz doğrulanamadi."), JsonRequestBehavior.AllowGet)); } if (!password.Equals("")) { dbUser.password = HashWithSha.ComputeHash(password, "SHA512", Encoding.ASCII.GetBytes(password)); } db.Entry(dbUser).State = EntityState.Modified; db.SaveChanges(); return(Json(JsonSonuc.sonucUret(true, "Şifreniz Güncellendi."), JsonRequestBehavior.AllowGet)); } catch (Exception e) { return(Json(JsonSonuc.sonucUret(false, "Bir hata oluştu. Lütfen daha sonra tekrar deneyiniz."), JsonRequestBehavior.AllowGet)); } }
public JsonResult silFirmaMusavir(string id) { try { firma_musavir fm = db.firma_musavir.Where(e => e.url.Equals(id)).FirstOrDefault(); if (fm == null) { return(Json(FormReturnTypes.basarisiz, JsonRequestBehavior.AllowGet)); } fm.flag = durumlar.silindi; db.Entry(fm).State = EntityState.Modified; if (fm.id == GetCurrentUser.GetUser().firma_id) { kullaniciIslemleri ki = new kullaniciIslemleri(); ki.resetLoginInfo(); } db.SaveChanges(); } catch (Exception) { return(Json(FormReturnTypes.basarisiz, JsonRequestBehavior.AllowGet)); } return(Json(FormReturnTypes.basarili, JsonRequestBehavior.AllowGet)); }
public ActionResult Update(tblAccessPC obj) { ViewBag.urlValue = url ?? Request.Url.PathAndQuery; if (!ModelState.IsValid) { return(View(obj)); } var oldobj = _tblAccessPCService.GetById(obj.PCID); if (oldobj == null) { return(View(obj)); } oldobj.Description = obj.Description; oldobj.Inactive = obj.Inactive; oldobj.IPAddress = obj.IPAddress; oldobj.PCName = obj.PCName; var report = _tblAccessPCService.Update(oldobj); if (report.isSuccess) { WriteLog.Write(report, GetCurrentUser.GetUser(), oldobj.PCID.ToString(), oldobj.PCName, "tblAccessPC", ConstField.AccessControlCode, ActionConfigO.Update); return(Redirect(url)); } else { ModelState.AddModelError("", "Tạo dữ liệu không thành công. Hãy kiểm tra lại dữ liệu nhập vào"); return(View(oldobj)); } }
/// <summary> /// Xóa /// </summary> /// <modified> /// Author Date Comments /// TrungNQ 04/08/2017 Tạo mới /// </modified> /// <param name="id"></param> /// <returns></returns> public JsonResult Delete(string id) { var obj = _UserService.GetById(id); if (obj.Admin) { var message = new MessageReport(); message.isSuccess = false; message.Message = FunctionHelper.GetLocalizeDictionary("Home", "notification")["Admin_account"]; return(Json(message, JsonRequestBehavior.AllowGet)); } var result = _UserService.DeleteById(id); if (result.isSuccess) { var name = FunctionHelper.getCurrentGroup(GroupID); WriteLog.Write(result, GetCurrentUser.GetUser(), obj.Id, obj.Username, "User", name, ActionConfigO.Delete); } return(Json(result, JsonRequestBehavior.AllowGet)); }
public JsonResult Delete(string id) { var obj = new tblCustomer(); //Check tồn tại trong cardcustomer var existedInCard = _tblCardService.GetAllByCustomerId(id); if (existedInCard.Any()) { var result1 = new MessageReport(); result1.Message = "Khách hàng đang sử dụng thẻ. Không thể xóa."; result1.isSuccess = false; } //Check tồn tại trong event //var existedInEvent = _PK_VehicleEventService.GetAllEventByCustomerId(id); //if (existedInEvent.Any()) //{ // var result1 = new Result(); // result1.ErrorCode = 500; // result1.Message = "Khách hàng đang tồn tại trong sự kiện. Không thể xóa."; // result1.Success = false; //} var result = _tblCustomerService.DeleteById(id, ref obj); if (result.isSuccess) { WriteLog.Write(result, GetCurrentUser.GetUser(), obj.CustomerID.ToString(), obj.CustomerCode, "tblCustomer", ConstField.AccessControlCode, ActionConfigO.Delete); } return(Json(result, JsonRequestBehavior.AllowGet)); }
/// <summary> /// Danh sách sidebar /// </summary> /// <param name="actionName">Tên action</param> /// <param name="controllerName">Tên controller</param> /// <param name="openTab">Mở tab lớn khi có chọn con</param> /// <returns></returns> public PartialViewResult Sidebar(string actionName = "Index", string controllerName = "Home", string openTab = "") { //All menuFunction //var list = CacheLayer.Get<List<MenuFunction>>(ConstField.AllListMenuFunctionCache); //if(list==null) //{ // list = _MenuFunctionService.GetAllActive().ToList(); // CacheLayer.Add(ConstField.AllListMenuFunctionCache, list, ConstField.TimeCache); //} // Current User var user = GetCurrentUser.GetUser(); // get all Role menu buy User var model = new List <MenuFunction>(); if (user != null) { model = _MenuFunctionService.GetAllMenuByPermisstion(user.Id, user.Admin).Distinct().ToList(); } var pageModel = new PageNameModel { ControllerName = controllerName, ActionName = actionName, OpenMenu = openTab }; ViewBag.PageModel = pageModel; return(PartialView(model)); }
public ActionResult Update(BM_ResidentGroup obj) { ViewBag.DDLMenu = GetMenuList(); if (!ModelState.IsValid) { return(View(obj)); } var oldObj = _BM_ResidentGroupService.GetById(obj.Id); if (oldObj == null) { return(View(obj)); } oldObj.Name = obj.Name; oldObj.Ordering = obj.Ordering; oldObj.ParentId = obj.ParentId; //Thực hiện cập nhật var result = _BM_ResidentGroupService.Update(oldObj); if (result.isSuccess) { WriteLog.Write(result, GetCurrentUser.GetUser(), obj.Id.ToString(), obj.Name, "BM_ResidentGroup", ConstField.ResidentCode, ActionConfigO.Update); return(RedirectToAction("Index", new { selectedId = obj.Id })); } else { ModelState.AddModelError("", result.Message); return(View(oldObj)); } }
public ActionResult Create(SelfHostConfig obj, string key, string pcs, bool SaveAndCountinue = false) { ViewBag.keyValue = key; ViewBag.pcsValue = pcs; ViewBag.pcsList = _tblAccessPCService.GetAllActive(); if (!ModelState.IsValid) { return(View(obj)); } obj.Id = Common.GenerateId(); obj.DateCreated = DateTime.Now; var result = _SelfHostConfigService.Create(obj); if (result.isSuccess) { WriteLog.Write(result, GetCurrentUser.GetUser(), obj.Id.ToString(), obj.Address, "SelfHostConfig", ConstField.AccessControlCode, ActionConfigO.Create); if (SaveAndCountinue) { TempData["Success"] = result.Message; return(RedirectToAction("Create", new { key = key, pcs = pcs, selectedId = obj.Id, page = 1 })); } return(RedirectToAction("Index", new { key = key, pcs = pcs, selectedId = obj.Id, page = 1 })); } else { ModelState.AddModelError("", result.Message); return(View(obj)); } }
private void PK_CustomerGroupFormatCell(List <tblCustomerGroupExcel> listData, string filename = "", string sheetname = "", string comments = "", string titleSheet = "", string titleTime = "") { //Nội dung đầu trang var user = GetCurrentUser.GetUser(); var timeSearch = ""; if (!string.IsNullOrWhiteSpace(titleTime)) { timeSearch = "Từ " + titleTime.Split(new[] { '-' })[0] + " đến " + titleTime.Split(new[] { '-' })[1]; } var dtHeader = _tblSystemConfigService.getHeaderExcel(titleSheet, timeSearch, user.Username); //Header var listColumn = new List <SelectListModel>(); listColumn.Add(new SelectListModel { ItemText = "STT", ItemValue = "STT" }); listColumn.Add(new SelectListModel { ItemText = "Nhóm khách hàng", ItemValue = "CustomerGroupName" }); //Chuyển dữ liệu về datatable DataTable dt = listData.ToDataTableNullable(); //Xuất file ExportFile(dt, listColumn, dtHeader, filename, sheetname, comments); }
public JsonResult CreateRole(Role obj, string lstId) { bool isSuccess = false; obj.Id = Common.GenerateId(); if (ModelState.IsValid) { isSuccess = _RoleService.Create(obj); } if (isSuccess) { MessageReport report = new MessageReport(true, FunctionHelper.GetLocalizeDictionary("Home", "notification")["addSuccess"]); WriteLog.Write(report, GetCurrentUser.GetUser(), obj.Id, obj.RoleName, "Role"); string[] ids = lstId.Split(new Char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); if (ids != null) { foreach (var item in ids) { RoleMenu objRoleMenu = new RoleMenu(); objRoleMenu.Id = Common.GenerateId(); objRoleMenu.RoleId = obj.Id; objRoleMenu.MenuId = item; _RoleMenuService.Create(objRoleMenu); } } } return(Json(isSuccess, JsonRequestBehavior.AllowGet)); }
public ActionResult Create(tblAccessDoor obj, string TypeSelect, bool SaveAndCountinue = false) { ViewBag.urlValue = url ?? Request.Url.PathAndQuery; ViewBag.Controllers = GetControllerList(); if (!ModelState.IsValid) { ModelState.AddModelError("", "Tạo dữ liệu không thành công. Hãy kiểm tra lại dữ liệu nhập vào"); return(View(obj)); } obj.DoorID = Guid.NewGuid(); var report = _tblAccessDoorService.Create(obj); if (report.isSuccess) { WriteLog.Write(report, GetCurrentUser.GetUser(), obj.DoorID.ToString(), obj.DoorName, "tblAccessDoor", ConstField.AccessControlCode, ActionConfigO.Create); TempData["Success"] = report.Message; if (SaveAndCountinue) { return(RedirectToAction("Create", new { ordering = obj.Ordering + 1 })); } return(Redirect(url)); } else { ModelState.AddModelError("", "Tạo dữ liệu không thành công. Hãy kiểm tra lại dữ liệu nhập vào"); return(View(obj)); } }
public JsonSonuc projeKullanicisiSil(int id) { try { LoggedUserModel lgm = GetCurrentUser.GetUser(); vrlfgysdbEntities db = new vrlfgysdbEntities(); kullanici_proje kp = db.kullanici_proje.Where(e => e.id.Equals(id)).FirstOrDefault(); kp.flag = durumlar.silindi; db.Entry(kp).State = EntityState.Modified; if (kp.proje_surec != null) { if (kp.proje_surec.tur == ProjeSurecTur.proje) { bildirimIslemleri.yeniBildirim(kp.kullanici_id, BildirimTurleri.proje, kp.proje_id, "", kp.proje_surec.isim + " isimli proje sizden alındı. İşlemi yapan yetkili " + lgm.ad + " " + lgm.soyad + "."); } else if (kp.proje_surec.tur == ProjeSurecTur.surec) { bildirimIslemleri.yeniBildirim(kp.kullanici_id, BildirimTurleri.surec, kp.proje_id, "", kp.proje_surec.isim + " isimli süreç sizden alındı. İşlemi yapan yetkili " + lgm.ad + " " + lgm.soyad + "."); } } db.SaveChanges(); } catch (Exception) { return(JsonSonuc.sonucUret(false, "İşlem sırasında bir hata oluştu. Lütfen tekrar deneyiniz.")); } return(JsonSonuc.sonucUret(true, "Kullanıcı silindi.")); }
/// <summary> /// lấy danh sách cardgroup được phân quyền theo user /// </summary> /// <param name="userid"></param> /// <returns></returns> public string GetAuthCardGroupIds() { var user = GetCurrentUser.GetUser(); var userid = user != null ? user.Id : ""; string cardgroupids = ""; if (user != null) { var objsystem = _tblSystemConfigService.GetDefault(); if (!string.IsNullOrEmpty(userid) && objsystem != null && objsystem.isAuthInView) { var user_auth = GetByUserId(userid); if (user_auth != null && !string.IsNullOrEmpty(user_auth.CardGroupIds)) { cardgroupids = user_auth.CardGroupIds; } else { cardgroupids = "NULL"; } } } return(cardgroupids); }
public ActionResult ayarlar() { int currenId = GetCurrentUser.GetUser().id; kullanicilar user = db.kullanicilar.Where(e => e.id == currenId).FirstOrDefault(); return(View(user)); }
public JsonSonuc projeSurecAktiflestir(string url) { try { vrlfgysdbEntities db = new vrlfgysdbEntities(); LoggedUserModel lgm = GetCurrentUser.GetUser(); proje_surec ps = db.proje_surec.Where(e => e.url.Equals(url)).FirstOrDefault(); if (ps == null) { return(JsonSonuc.sonucUret(false, "Proje/Süreç bulunamadı.")); } ps.durum = TamamlamaDurumlari.basladi; List <gorev_proje> projeGorevList = db.gorev_proje.Where(e => e.proje_id == ps.id && e.flag == durumlar.aktif && e.gorevler.flag == durumlar.aktif).ToList(); foreach (gorev_proje gp in projeGorevList) { gp.gorevler.durum = TamamlamaDurumlari.basladi; db.Entry(gp).State = EntityState.Modified; } db.Entry(ps).State = EntityState.Modified; db.SaveChanges(); } catch (Exception) { return(JsonSonuc.sonucUret(false, "İşlem sırasında bir hata oluştu. Lütfen tekrar deneyiniz.")); } return(JsonSonuc.sonucUret(true, "Proje/Süreç durumu güncellendi.")); }
public ActionResult Create(tblCustomerGroup obj, bool SaveAndCountinue = false) { //ViewBag ViewBag.DDLMenu = GetMenuList(); if (!ModelState.IsValid) { return(View(obj)); } obj.CustomerGroupID = Guid.NewGuid(); //Thực hiện thêm mới var result = _tblCustomerGroupService.Create(obj); if (result.isSuccess) { WriteLog.Write(result, GetCurrentUser.GetUser(), obj.CustomerGroupID.ToString(), obj.CustomerGroupName, "tblCustomerGroup", ConstField.AccessControlCode, ActionConfigO.Create); if (SaveAndCountinue) { TempData["Success"] = result.Message; return(RedirectToAction("Create", new { selectedId = obj.CustomerGroupID, parentid = obj.ParentID })); } return(RedirectToAction("Index", new { selectedId = obj.CustomerGroupID })); } else { return(View(obj)); } }
public ActionResult Create(tblPC obj, bool SaveAndCountinue = false, string group = "", string key = "", string gate = "") { ViewBag.Gates = GetGateList(); ViewBag.keyValue = key; ViewBag.groupValue = group; ViewBag.gateValue = gate; var DictionaryAction = FunctionHelper.GetLocalizeDictionary("Home", "notification"); // if (string.IsNullOrWhiteSpace(obj.ComputerName)) { ModelState.AddModelError("ComputerName", DictionaryAction["Computer_Name"]); return(View(obj)); } if (string.IsNullOrWhiteSpace(obj.IPAddress)) { ModelState.AddModelError("IPAddress", DictionaryAction["ip"]); return(View(obj)); } // var existedName = _tblPCService.GetByName(obj.IPAddress); if (existedName != null) { ModelState.AddModelError("IPAddress", DictionaryAction["ip_already_exists"]); return(View(obj)); } if (!ModelState.IsValid) { return(View(obj)); } obj.PCID = Guid.NewGuid(); //Thực hiện thêm mới var result = _tblPCService.Create(obj); if (result.isSuccess) { WriteLog.Write(result, GetCurrentUser.GetUser(), obj.PCID.ToString(), obj.ComputerName, "tblPC", ConstField.ParkingCode, ActionConfigO.Create); if (SaveAndCountinue) { TempData["Success"] = result.Message; return(RedirectToAction("Create", new { group = group, key = key, gate = obj.GateID, selectedId = obj.PCID })); } return(RedirectToAction("Index", new { group = group, key = key, gate = gate, selectedId = obj.PCID })); } else { return(View(obj)); } }
public ActionResult Create(tblCardGroup obj, bool SaveAndCountinue = false) { //Danh sách sử dụng ViewBag.Url = url; //Kiểm tra if (!ModelState.IsValid) { return(View(obj)); } if (string.IsNullOrEmpty(obj.CardGroupName)) { ModelState.AddModelError("CardGroupName", "Vui lòng nhập tên nhóm thẻ"); return(View(obj)); } var cgroup = _tblCardGroupService.GetByName(obj.CardGroupName); if (cgroup != null) { ModelState.AddModelError("CardGroupName", "Nhóm thẻ đã tồn tại"); return(View(obj)); } //Gán giá trị obj.CardGroupID = Guid.NewGuid(); obj.DayTimeFrom = ""; obj.DayTimeTo = ""; obj.TimePeriods = ""; obj.Costs = ""; //Thực hiện thêm mới var result = _tblCardGroupService.Create(obj); if (result.isSuccess) { WriteLog.Write(result, GetCurrentUser.GetUser(), obj.CardGroupID.ToString(), obj.CardGroupName, "tblCardGroup", ConstField.AccessControlCode, ActionConfigO.Create); if (SaveAndCountinue) { TempData["Success"] = result.Message; return(RedirectToAction("Create")); } if (!string.IsNullOrEmpty(url)) { return(Redirect(url)); } else { return(RedirectToAction("Index")); } } else { ModelState.AddModelError("", result.Message); return(View(obj)); } }
private void FormatCell(DataTable dtData, string filename = "", string sheetname = "", string comments = "", string titleSheet = "", string titleTime = "") { //Nội dung đầu trang var user = GetCurrentUser.GetUser(); var timeSearch = "Từ " + titleTime.Split(new[] { '-' })[0] + " đến " + titleTime.Split(new[] { '-' })[1]; var dtHeader = _tblSystemConfigService.getHeaderExcel(titleSheet, timeSearch, user.Username); //Header var listColumn = new List <SelectListModel>(); listColumn.Add(new SelectListModel { ItemText = "STT", ItemValue = "STT" }); listColumn.Add(new SelectListModel { ItemText = "Thời gian", ItemValue = "Thời gian" }); listColumn.Add(new SelectListModel { ItemText = "Mã thẻ", ItemValue = "Mã thẻ" }); listColumn.Add(new SelectListModel { ItemText = "User trên tb", ItemValue = "User trên tb" }); listColumn.Add(new SelectListModel { ItemText = "Nhóm thẻ", ItemValue = "Nhóm thẻ" }); listColumn.Add(new SelectListModel { ItemText = "Hành vi", ItemValue = "Hành vi" }); listColumn.Add(new SelectListModel { ItemText = "Chủ thẻ", ItemValue = "Chủ thẻ" }); listColumn.Add(new SelectListModel { ItemText = "Nhóm KH", ItemValue = "Nhóm KH" }); listColumn.Add(new SelectListModel { ItemText = "Địa chỉ", ItemValue = "Địa chỉ" }); listColumn.Add(new SelectListModel { ItemText = "NV thực hiện", ItemValue = "NV thực hiện" }); listColumn.Add(new SelectListModel { ItemText = "Thiết bị", ItemValue = "Thiết bị" }); listColumn.Add(new SelectListModel { ItemText = "EventType", ItemValue = "EventType" }); listColumn.Add(new SelectListModel { ItemText = "Hết hạn", ItemValue = "Hết hạn" }); //Chuyển dữ liệu về datatable // DataTable dt = listData.ToDataTableNullable(); //Xuất file ExportFile(dtData, listColumn, dtHeader, filename, sheetname, comments); }
public void resetLoginInfo() { vrlfgysdbEntities db = new vrlfgysdbEntities(); int id = GetCurrentUser.GetUser().id; FormsAuthentication.SignOut(); kullanicilar usr = db.kullanicilar.Where(e => e.id == id).FirstOrDefault(); if (usr != null) { LoggedUserModel loggedUser = new LoggedUserModel(); foreach (var property in loggedUser.GetType().GetProperties()) { try { var response = usr.GetType().GetProperty(property.Name).GetValue(usr, null).ToString(); if (response == null && property.PropertyType != typeof(int)) { if (response == null) { continue; } } else { PropertyInfo propertyS = loggedUser.GetType().GetProperty(property.Name); if (property.PropertyType == typeof(decimal)) { propertyS.SetValue(loggedUser, Convert.ChangeType(Decimal.Parse(response.Replace('.', ',')), property.PropertyType), null); } else if (property.PropertyType == typeof(int)) { if (response == null) { propertyS.SetValue(loggedUser, Convert.ChangeType(0, property.PropertyType), null); } else { propertyS.SetValue(loggedUser, Convert.ChangeType(Decimal.Parse(response.Replace('.', ',')), property.PropertyType), null); } } else { propertyS.SetValue(loggedUser, Convert.ChangeType(response, property.PropertyType), null); } } } catch (Exception) { } } Guid gd = new Guid(); gd = Guid.NewGuid(); string query = "select * from firma_musavir where flag = " + durumlar.aktif.ToString() + " and id = " + loggedUser.firma_id; FirmaMusavirModel fmm = db.Database.SqlQuery <FirmaMusavirModel>(query).FirstOrDefault(); loggedUser.fm = fmm; SetAuthCookie(gd.ToString(), true, loggedUser); } }
public JsonResult DeleteEventPRIDE(string id) { var result = new MessageReport(false, "Có lỗi xảy ra"); if (!string.IsNullOrEmpty(id)) { var obj = new tblActiveCard(); var activecard = _tblActiveCardService.GetById(id); if (activecard != null) { //đếm số thẻ trong hóa đơn var count = _tblActiveCardService.GetCountByOrderId(activecard.OrderId); var card = _tblCardService.GetByCardNumber(activecard.CardNumber); if (card != null) { if (Convert.ToDateTime(card.ExpireDate).Date == Convert.ToDateTime(activecard.NewExpireDate).Date) { if (count > 1) { var order = _OrderActiveCardService.GetById(activecard.OrderId); if (order != null) { order.Price = order.Price - activecard.FeeLevel; _OrderActiveCardService.Update(order); } } else if (count == 1) { _OrderActiveCardService.DeleteById(activecard.OrderId); } card.ExpireDate = activecard.OldExpireDate; _tblCardService.Update(card); result = _tblActiveCardService.DeleteById(id); } else { result = new MessageReport(false, "Không thể xóa"); } } } if (result.isSuccess) { WriteLog.Write(result, GetCurrentUser.GetUser(), id, "", "tblActiveCard", ConstField.ParkingCode, ActionConfigO.Delete); } return(Json(result, JsonRequestBehavior.AllowGet)); } else { return(Json("", JsonRequestBehavior.AllowGet)); } }
public ActionResult Index() { LoggedUserModel lgm = GetCurrentUser.GetUser(); string userQuery = "select k.id, k.flag, k.ad, k.soyad, k.email, k.tel, k.kullanici_turu, k.url, fm.firma_adi from kullanicilar as k " + "left join firma_musavir as fm on k.firma_id = fm.id and fm.flag = " + durumlar.aktif.ToString() + " where k.id != " + lgm.id + " and k.flag != " + durumlar.silindi.ToString(); List <KullaniciFirmaOzetModel> users = db.Database.SqlQuery <KullaniciFirmaOzetModel>(userQuery).ToList(); return(View(users)); }
private void PK_CustomerMapFormatCell(List <tblCustomer_ExcelTRANSERCO> listData, string filename = "", string sheetname = "", string comments = "", string titleSheet = "", string titleTime = "") { //Nội dung đầu trang var user = GetCurrentUser.GetUser(); var timeSearch = ""; if (!string.IsNullOrWhiteSpace(titleTime)) { timeSearch = "Từ " + titleTime.Split(new[] { '-' })[0] + " đến " + titleTime.Split(new[] { '-' })[1]; } var dtHeader = _tblSystemConfigService.getHeaderExcel(titleSheet, timeSearch, user.Username); //Header var listColumn = new List <SelectListModel>(); listColumn.Add(new SelectListModel { ItemText = "STT", ItemValue = "NumberRow" }); listColumn.Add(new SelectListModel { ItemText = "Mã khách hàng", ItemValue = "CustomerCode" }); listColumn.Add(new SelectListModel { ItemText = "Khách hàng", ItemValue = "CustomerName" }); listColumn.Add(new SelectListModel { ItemText = "Chứng minh thư", ItemValue = "CustomerIdentify" }); listColumn.Add(new SelectListModel { ItemText = "Mã hợp đồng", ItemValue = "ContractCode" }); listColumn.Add(new SelectListModel { ItemText = "Địa chỉ", ItemValue = "CustomerAddress" }); listColumn.Add(new SelectListModel { ItemText = "Số điện thoại", ItemValue = "CustomerMobile" }); listColumn.Add(new SelectListModel { ItemText = "Nhóm khách hàng", ItemValue = "CustomerGroupName" }); listColumn.Add(new SelectListModel { ItemText = "Mã thẻ (Số thẻ)", ItemValue = "Cards" }); listColumn.Add(new SelectListModel { ItemText = "Biển số", ItemValue = "Plates" }); listColumn.Add(new SelectListModel { ItemText = "Trạng thái", ItemValue = "Active" }); //Chuyển dữ liệu về datatable DataTable dt = listData.ToDataTableNullable(); //Xuất file ExportFile(dt, listColumn, dtHeader, filename, sheetname, comments); }