public JsonResult RegisterLockerWithCardNumber(string lockerid, string cardnumber)
{
var result = new MessageReport(false, "Có lỗi xảy ra");
try
{
var objLocker = _tblLockerService.GetById(lockerid);
if (objLocker != null)
{
var objCard = _tblCardService.GetByCardNumber(cardnumber);
if (objCard != null)
{
objLocker.LockerType = "1"; //Cố định
objLocker.CardNumber = objCard.CardNumber;
objLocker.CardNo = objCard.CardNo;
result = _tblLockerService.Update(objLocker);
}
}
}
catch (Exception ex)
{
result = new MessageReport(false, ex.Message);
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public JsonResult DeleteEvent(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)
{
var subid = activecard.SubId;
var card = _tblCardService.GetByCardNumber(activecard.CardNumber);
if (card != null)
{
if (Convert.ToDateTime(card.ExpireDate).Date == Convert.ToDateTime(activecard.NewExpireDate).Date)
{
card.ExpireDate = activecard.OldExpireDate;
_tblCardService.Update(card);
result = _tblActiveCardService.DeleteById(id);
}
else
{
result = new MessageReport(false, "Không thể xóa");
}
//xóa chi tiết gia hạn
if (result.isSuccess)
{
_tblActiveCardService.DeleteExtendBySubId(subid);
}
}
}
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 HttpResponseMessage ExtendCardByOrder(HttpRequestMessage request, PMC_CustomerOrder model)
{
var result = new MessageReport(false, "Có lỗi xảy ra");
//Check Auth
var objAuth = _API_AuthService.GetDefault();
if (objAuth != null)
{
if (objAuth.AccessToken != model.AccessToken)
{
result = new MessageReport(false, "Token không khớp");
//Trả lại response
return(CreateHttpResponse(request, () =>
{
var response = request.CreateResponse(result.isSuccess ? HttpStatusCode.OK : HttpStatusCode.BadRequest, result);
return response;
}));
}
}
//Xử lý logic gia hạn
var obj = _tblCardService.GetByCardNumber(model.CardNumber);
if (obj != null)
{
string dateextend = Convert.ToDateTime(obj.ExpireDate).AddDays(model.DayExtend).ToString("MM/dd/yyyy");
var money = model.Money.ToString().Replace(".", "").Replace(",", "");
var isSuccess = _tblCardService.AddCardExpireByListCardNumber("'" + model.CardNumber + "'", int.Parse(money), dateextend, "Từ APP", false);
if (isSuccess)
{
//result = new MessageReport(true, FunctionHelper.GetLocalizeDictionary("Home", "notification")["updateSuccess"]);
result = new MessageReport(true, "Gia hạn thành công");
}
else
{
//result = new MessageReport(false, FunctionHelper.GetLocalizeDictionary("Home", "notification")["updateFailed"]);
result = new MessageReport(false, "Gia hạn thất bại");
}
}
else
{
result = new MessageReport(false, "Thẻ không tồn tại");
}
//Trả lại response
return(CreateHttpResponse(request, () =>
{
var response = request.CreateResponse(result.isSuccess ? HttpStatusCode.OK : HttpStatusCode.BadRequest, result);
return response;
}));
}
public ActionResult ReportEvent(string KeyWord = "", string status = "", string controllerid = "", string cardgroup = "", string fromdate = "", string todate = "", int page = 1, string chkExport = "0", string datefrompicker = "")
{
var totalItem = 0;
var pageSize = 20;
var user = GetCurrentUser.GetUser();
string CustomerID = "";
if (!string.IsNullOrWhiteSpace(fromdate) && !string.IsNullOrWhiteSpace(todate))
{
datefrompicker = fromdate + "-" + todate;
}
#region Excel
//Excel
if (chkExport.Equals("1"))
{
////Query lấy dữ liệu
var listExcel = _ReportService.GetReportEventExcel(KeyWord, status, controllerid, fromdate, todate, cardgroup);
if (listExcel != null && listExcel.Rows.Count > 0)
{
foreach (DataRow dr in listExcel.Rows)
{
var customer = new tblCustomer();
var cg = new tblCardGroup();
if (!string.IsNullOrEmpty(dr["CardNumber"].ToString()))
{
var card = _tblCardService.GetByCardNumber(dr["CardNumber"].ToString());
if (card != null)
{
if (!string.IsNullOrEmpty(card.CustomerID))
{
customer = _tblCustomerService.GetById(Guid.Parse(card.CustomerID));
}
}
}
if (!string.IsNullOrEmpty(dr["CardGroupID"].ToString()))
{
cg = _tblCardGroupService.GetById(Guid.Parse(dr["CardGroupID"].ToString()));
}
if (!string.IsNullOrEmpty(dr["ControllerID"].ToString()))
{
var controller = _tblAccessControllerService.GetById(Guid.Parse(dr["ControllerID"].ToString()));
var door = _tblAccessDoorService.GetByController_Readerindex(dr["ControllerID"].ToString(), dr["ReaderIndex"].ToString());
dr["ControllerName"] = controller != null ? controller.ControllerName : "";
dr["DoorName"] = door != null ? door.DoorName : "";
}
dr["CustomerName"] = customer != null ? customer.CustomerName : "";
dr["CardGroupName"] = cg != null ? cg.CardGroupName : "";
dr["Address"] = customer != null ? customer.Address : "";
}
}
listExcel.Columns.Remove("RowNumber");
listExcel.Columns.Remove("ControllerID");
listExcel.Columns.Remove("ReaderIndex");
listExcel.Columns.Remove("CardGroupID");
//Xuất file theo format
ReportEventFormatCell(listExcel, "Sự_kiện_quẹt_thẻ", "Sheet1", "", "Sự kiện quẹt thẻ", datefrompicker);
return(RedirectToAction("ReportEvent"));
}
#endregion
#region Giao diện
var list = _ReportService.GetReportEvent(KeyWord, status, controllerid, fromdate, todate, page, pageSize, ref totalItem, cardgroup);
var gridModel = PageModelCustom <ReportEvent_Access> .GetPage(list, page, pageSize, totalItem);
ViewBag.CardGroups = GetCardGroupListMonth().ToList();
ViewBag.CardGroupDT = GetCardGroupListMonth().ToDataTableNullable();
ViewBag.CardGroupId = cardgroup;
ViewBag.Controllers = GetControllerList().ToList();
ViewBag.ControllerDT = GetControllerList().ToDataTableNullable();
ViewBag.ControllerID = controllerid;
ViewBag.Status = status;
ViewBag.StatusDDL = FunctionHelper.StatusEventAccess();
ViewBag.Doors = GetDoor();
ViewBag.DateFromPickerValue = datefrompicker;
ViewBag.KeyWord = KeyWord;
ViewBag.fromdateValue = fromdate;
ViewBag.todateValue = !string.IsNullOrWhiteSpace(todate) ? Convert.ToDateTime(todate).ToString("dd/MM/yyyy HH:mm:59") : DateTime.Now.ToString("dd/MM/yyyy 23:59:59");
return(View(gridModel));
#endregion
}
public ActionResult Create(tblCardSubmit tblCard, HttpPostedFileBase FileUpload, string key, string cardgroups, string customergroups, string active, string fromdate, string todate, string isCheckByTime = "0", bool SaveAndCountinue = false)
{
ViewBag.CardGroups = GetListCardGroup();
ViewBag.lcustomergroups = GetMenuList();
ViewBag.CardGroups = GetListCardGroup();
ViewBag.lcustomergroups = GetMenuList();
ViewBag.keyValue = key;
ViewBag.cardgroupsValue = cardgroups;
ViewBag.customergroupsValue = customergroups;
ViewBag.activeValue = active;
ViewBag.fromdateValue = fromdate;
ViewBag.todateValue = todate;
ViewBag.isCheckByTimeValue = isCheckByTime;
if (!ModelState.IsValid)
{
return(View(tblCard));
}
// valid thẻ
if ((string.IsNullOrEmpty(tblCard.CardNo) || string.IsNullOrWhiteSpace(tblCard.CardNo)) || (string.IsNullOrWhiteSpace(tblCard.CardNumber) || string.IsNullOrEmpty(tblCard.CardNumber)) || (string.IsNullOrWhiteSpace(tblCard.CardNumber)))
{
if ((string.IsNullOrEmpty(tblCard.CardNo) || string.IsNullOrWhiteSpace(tblCard.CardNo)))
{
ModelState.AddModelError("", "Hãy nhập lại mã thẻ");
}
if ((string.IsNullOrWhiteSpace(tblCard.CardNumber) || string.IsNullOrEmpty(tblCard.CardNumber)))
{
ModelState.AddModelError("", "Hãy nhập lại Số thẻ ");
}
if (string.IsNullOrWhiteSpace(tblCard.CardNumber))
{
ModelState.AddModelError("", "NHập lại ID ");
}
return(View(tblCard));
}
// check mã thẻ có tồn tại k
var cardNumber = _itblCardService.GetByCardNumber(tblCard.CardNumber.Trim());
if (cardNumber != null)
{
ModelState.AddModelError("CardNumber", "mã thẻ đã tồn tại");
return(View(tblCard));
}
// map
var map = new tblCard()
{
CardID = Guid.NewGuid(),
CardNo = tblCard.CardNo,
CardNumber = tblCard.CardNumber.Trim(),
CardGroupID = tblCard.CardGroupID,
CustomerID = GetOrSetCustomer(tblCard, FileUpload),
AccessLevelID = "",
ChkRelease = false,
ImportDate = DateTime.Now,
DateRegister = Convert.ToDateTime(tblCard.DtpDateRegisted),
DateRelease = Convert.ToDateTime(tblCard.DtpDateReleased),
ExpireDate = Convert.ToDateTime(tblCard.DtpDateExpired),
DateActive = Convert.ToDateTime(tblCard.DtpDateActive),
Description = !string.IsNullOrWhiteSpace(tblCard.CardDescription) ? tblCard.CardDescription : "",
IsDelete = false,
IsLock = tblCard.CardInActive,
Plate1 = tblCard.Plate1,
Plate2 = tblCard.Plate2,
Plate3 = tblCard.Plate3,
VehicleName1 = tblCard.VehicleName1,
VehicleName2 = tblCard.VehicleName2,
VehicleName3 = tblCard.VehicleName3,
DVT = tblCard.DVT,
AccessExpireDate = Convert.ToDateTime("2099/12/31"),
DateCancel = DateTime.Now,
isAutoCapture = tblCard.IsAutoCapture
};
//thực hiện thêm mới
var result = _itblCardService.Create(map);
if (result.isSuccess)
{
return(RedirectToAction("Index", new { key = key, cardgroups = cardgroups, customergroups = customergroups, fromdate = fromdate, todate = todate, active = active, isCheckByTime = isCheckByTime, selectedId = tblCard.CardID }));
}
else
{
ModelState.AddModelError("", result.Message);
return(View(tblCard));
}
}