public MessageReport SaveProcess(Employee emp, SelectListModelUploadSubmit obj)
        {
            //
            var user = GetCurrentUser.GetUser();

            //
            var cardgroupid     = "";
            var userId          = user != null ? user.Id : "";
            var customerid      = "";
            var customergroupid = "";
            var controllerid    = obj.controllerid;
            var controllerids   = emp.ControllerIDs;
            var expiredate      = "2099/12/31";
            var desc            = obj.desc;

            //Lấy nhóm thẻ
            if (emp.CardNumber != "0")
            {
                var objCard = _tblCardService.GetCustomByCardNumber(emp.CardNumber);
                if (objCard != null)
                {
                    cardgroupid     = objCard.CardGroupID;
                    expiredate      = objCard.AccessExpireDate.ToString("yyyy/MM/dd");
                    customerid      = objCard.CustomerID;
                    customergroupid = objCard.CustomerGroupID;

                    if (obj.isusenewdate)
                    {
                        _tblCardService.UpdateCard(obj.actionV, userId, emp.CardNumber, emp.ExpireDate, true);
                    }
                }
            }

            if (emp.UserIDofFinger > 0)
            {
                //Lấy khách hàng
                var objCustomer = _tblCustomerService.GetByFingerID(emp.UserIDofFinger);
                if (objCustomer != null)
                {
                    if (obj.isusenewdate)
                    {
                        _tblCustomerService.UpdateCustomer(emp.UserIDofFinger.ToString(), emp.ExpireDate, true);
                    }
                }
            }

            var result = new MessageReport(false, "Có lỗi xảy ra");

            try
            {
                var str = new StringBuilder();
                str.AppendLine("INSERT INTO tblAccessUploadProcess(Date, CardNumber, UserIDofFinger, Actions, CardGroupID, UserID, AccessLevelID, CustomerID, CustomerGroupID, SuccessControllerIDs, TotalControllerIDs, EventType, AccessDateExpire, Description) VALUES (");

                str.AppendLine("GETDATE()");
                str.AppendLine(string.Format(", '{0}'", emp.CardNumber));
                str.AppendLine(string.Format(", '{0}'", emp.UserIDofFinger));
                str.AppendLine(string.Format(", '{0}'", obj.actionV));
                str.AppendLine(string.Format(", '{0}'", cardgroupid));
                str.AppendLine(string.Format(", '{0}'", userId));
                str.AppendLine(string.Format(", '{0}'", emp.AccessLevelID));
                str.AppendLine(string.Format(", '{0}'", customerid));
                str.AppendLine(string.Format(", '{0}'", customergroupid));
                str.AppendLine(string.Format(", '{0}'", controllerid));
                str.AppendLine(string.Format(", '{0}'", controllerids));
                str.AppendLine(string.Format(", '{0}'", obj.eventtype));
                str.AppendLine(string.Format(", '{0}'", expiredate));
                str.AppendLine(string.Format(", N'{0}'", desc));

                str.AppendLine(")");

                var t = ExcuteSQL.Execute(str.ToString());

                result.isSuccess = t;
                result.Message   = "Thêm mới thành công";

                if (obj.isusenewdate && emp.CardNumber != "0")
                {
                    var str1 = new StringBuilder();

                    str1.AppendLine("INSERT INTO tblAccessUploadProcess(Date, CardNumber, UserIDofFinger, Actions, CardGroupID, UserID, AccessLevelID, CustomerID, CustomerGroupID, SuccessControllerIDs, TotalControllerIDs, EventType, AccessDateExpire, Description) VALUES (");

                    str1.AppendLine("GETDATE()");
                    str1.AppendLine(string.Format(", '{0}'", emp.CardNumber));
                    str1.AppendLine(string.Format(", '{0}'", emp.UserIDofFinger));
                    str1.AppendLine(string.Format(", '{0}'", "EXTEND"));
                    str1.AppendLine(string.Format(", '{0}'", cardgroupid));
                    str1.AppendLine(string.Format(", '{0}'", userId));
                    str1.AppendLine(string.Format(", '{0}'", emp.AccessLevelID));
                    str1.AppendLine(string.Format(", '{0}'", customerid));
                    str1.AppendLine(string.Format(", '{0}'", customergroupid));
                    str1.AppendLine(string.Format(", '{0}'", controllerid));
                    str1.AppendLine(string.Format(", '{0}'", controllerids));
                    str1.AppendLine(string.Format(", '{0}'", obj.eventtype));
                    str1.AppendLine(string.Format(", '{0}'", expiredate));
                    str1.AppendLine(string.Format(", N'{0}'", desc));

                    str1.AppendLine(")");

                    ExcuteSQL.Execute(str1.ToString());
                }
            }
            catch (Exception ex)
            {
                result.isSuccess = false;
                result.Message   = ex.Message;
            }

            return(result);
        }