Ejemplo n.º 1
0
        public List <UserLoginPermissionDTO> SaveListData(List <UserLoginPermissionDTO> model)
        {
            log.MethodStart();

            var currentDateTime = DateTime.Now;
            List <UserLoginPermissionDTO> objReturn = new List <UserLoginPermissionDTO>();

            using (var trans = _db.Database.BeginTransaction())
            {
                try
                {
                    foreach (var item in model)
                    {
                        var objModel = new TCUserLoginPermission();

                        if (item.usp_status == "E")
                        {
                            objModel = _db.TCUserLoginPermissions.FirstOrDefault(x => x.usp_id == item.usp_id);
                        }

                        if (item.usp_status == "N")
                        {
                            objModel = _mapper.Map <TCUserLoginPermission>(item);

                            objModel.usp_createdate = currentDateTime;
                            objModel.usp_status     = objModel.usp_active == true ? "A" : "I";

                            _db.TCUserLoginPermissions.Add(objModel);
                        }
                        else if (item.usp_status == "E")
                        {
                            objModel.usp_arh_code = item.usp_arh_code;
                            objModel.usp_hos_code = item.usp_hos_code;
                            objModel.usp_rol_code = item.usp_rol_code;

                            objModel.usp_active     = item.usp_active;
                            objModel.usp_status     = objModel.usp_active == true ? "A" : "I";
                            objModel.usp_updateuser = item.usp_updateuser;
                            objModel.usp_updatedate = currentDateTime;

                            //_db.TCHospitals.Update(objModel);
                        }


                        _db.SaveChanges();
                    }

                    trans.Commit();
                }
                catch (Exception ex)
                {
                    // TODO: Handle failure
                    trans.Rollback();
                }
                finally
                {
                    trans.Dispose();
                }
            }

            log.MethodFinish();

            return(objReturn);
        }
Ejemplo n.º 2
0
        public UserLoginPermissionDTO SaveData(UserLoginPermissionDTO model)
        {
            log.MethodStart();

            var currentDateTime = DateTime.Now;
            var currentUser     = "";
            UserLoginPermissionDTO objReturn = new UserLoginPermissionDTO();

            using (var trans = _db.Database.BeginTransaction())
            {
                try
                {
                    var objModel = new TCUserLoginPermission();

                    if (model.usp_status == "E")
                    {
                        objModel = _db.TCUserLoginPermissions.FirstOrDefault(x => x.usp_id == model.usp_id);
                    }

                    if (model.usp_status == "N")
                    {
                        objModel = _mapper.Map <TCUserLoginPermission>(model);

                        objModel.usp_createdate = currentDateTime;
                        objModel.usp_status     = objModel.usp_active == true ? "A" : "I";

                        currentUser = objModel.usp_createuser;

                        _db.TCUserLoginPermissions.Add(objModel);
                    }
                    else if (model.usp_status == "E")
                    {
                        objModel.usp_rol_code   = model.usp_rol_code;
                        objModel.usp_arh_code   = model.usp_arh_code;
                        objModel.usp_hos_code   = model.usp_hos_code;
                        objModel.usp_active     = model.usp_active;
                        objModel.usp_status     = objModel.usp_active == true ? "A" : "I";
                        objModel.usp_updateuser = model.usp_updateuser;
                        objModel.usp_updatedate = currentDateTime;

                        currentUser = objModel.usp_updateuser;

                        //_db.TCHospitals.Update(objModel);
                    }

                    #region Save Log Process ...
                    _db.LogProcesss.Add(new LogProcess()
                    {
                        log_usr_id     = currentUser,
                        log_mnu_id     = "",
                        log_mnu_name   = "UserPermission",
                        log_tran_id    = objModel.usp_id.ToString(),
                        log_action     = (model.usp_status == "N" ? "New" : "Update"),
                        log_desc       = "Update UserPermission " + objModel.usp_usr_userName,
                        log_createuser = currentUser,
                        log_createdate = currentDateTime
                    });
                    #endregion

                    _db.SaveChanges();

                    trans.Commit();
                }
                catch (Exception ex)
                {
                    // TODO: Handle failure
                    trans.Rollback();
                }
                finally
                {
                    trans.Dispose();
                }
            }

            log.MethodFinish();

            return(objReturn);
        }