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