Exemplo n.º 1
0
        /// <summary>
        /// Inserts the user entry exit.
        /// </summary>
        /// <param name="_UserEntryExit">The _ user entry exit.</param>
        /// <returns></returns>
        public ONSResult InsertUserEntryExit(UserEntryExit _UserEntryExit)
        {
            ONSResult _ONSResultSave = new ONSResult();

            try
            {
                using (TransactionScope transaction = new TransactionScope(TransactionScopeOption.Required, DBHelper.TransactionOptions))
                {
                    _ONSResultSave = ApplicationState.DAClient.InsertUserEntryExit(_UserEntryExit);
                    transaction.Complete();
                }
            }
            catch (Exception ex)
            {
                ErrorHandler _ErrorHandler = new ErrorHandler();
                _ErrorHandler.ONSERRORProcessing(ex);
            }
            return(_ONSResultSave);
        }
Exemplo n.º 2
0
        public ONSResult InsertUserEntryExit(UserEntryExit parameter)
        {
            ONSResult _ONSResultInsert = new ONSResult();

            try
            {
                _dataContext.UserEntryExits.InsertOnSubmit(parameter);
                _dataContext.SubmitChanges();

                _ONSResultInsert.ID        = parameter.UserEntryExitID;
                _ONSResultInsert.IsSuccess = true;
                _ONSResultInsert.Message   = "UserEntryExit inserted successfully.";
            }
            catch (Exception ex)
            {
                _ONSResultInsert.IsSuccess = false;
                _ONSResultInsert.Message   = ex.Message;
                _ErrorHandler.ONSERRORProcessing(ex);
            }
            return(_ONSResultInsert);
        }
Exemplo n.º 3
0
        public ONSResult UpdateUserEntryExit(UserEntryExit parameter)
        {
            ONSResult _ONSResultInsert = new ONSResult();

            try
            {
                List <UserEntryExit> list = new List <UserEntryExit>();
                var query = from a in _dataContext.UserEntryExits
                            where a.UserEntryExitID == parameter.UserEntryExitID
                            select a;
                list = query.ToList <UserEntryExit>();

                if (list.Count == 1)
                {
                    UserEntryExit obj = list[0];
                    if (!String.IsNullOrEmpty(parameter.UserEntryExitID))
                    {
                        obj.UserEntryExitID = parameter.UserEntryExitID;
                    }
                    if (!String.IsNullOrEmpty(parameter.Name))
                    {
                        obj.Name = parameter.Name;
                    }
                    if (!String.IsNullOrEmpty(parameter.EntryTime))
                    {
                        obj.EntryTime = parameter.EntryTime;
                    }
                    if (!String.IsNullOrEmpty(parameter.ExitTime))
                    {
                        obj.ExitTime = parameter.ExitTime;
                    }
                    if (parameter.EntryDate.HasValue)
                    {
                        obj.EntryDate = parameter.EntryDate.Value;
                    }
                    if (parameter.ExitDate.HasValue)
                    {
                        obj.ExitDate = parameter.ExitDate.Value;
                    }
                    if (!String.IsNullOrEmpty(parameter.CompanyId))
                    {
                        obj.CompanyId = parameter.CompanyId;
                    }
                    if (!String.IsNullOrEmpty(parameter.LocationId))
                    {
                        obj.LocationId = parameter.LocationId;
                    }
                    _dataContext.SubmitChanges();
                }
                _ONSResultInsert.IsSuccess = true;
                _ONSResultInsert.Message   = "IDNumber updated successfully.";
            }
            catch (Exception ex)
            {
                _ONSResultInsert.IsSuccess = false;
                _ONSResultInsert.Message   = ex.Message;
                _ErrorHandler.ONSERRORProcessing(ex);
            }

            return(_ONSResultInsert);
        }