Esempio n. 1
0
        public async Task <List <RolemodulesDTO> > GetallRolesModules(string connectionString)
        {
            await Task.Run(() =>
            {
                _RolemodulesDTOList = new List <RolemodulesDTO>();
                try
                {
                    using (NpgsqlDataReader dataReader = NPGSqlHelper.ExecuteReader(connectionString, CommandType.Text, "select moduleid,modulename from tblmstmodules where coalesce(parentmoduleid,0)=0 and coalesce(parentmodulename,'')='' and statusid=" + Convert.ToInt32(Status.Active) + " order by modulename desc;"))
                    {
                        while (dataReader.Read())
                        {
                            RolemodulesDTO _RolemodulesDTO = new RolemodulesDTO
                            {
                                pModulename = Convert.ToString(dataReader["modulename"]),
                                pModuleId   = Convert.ToInt64(dataReader["moduleid"])
                            };
                            _RolemodulesDTOList.Add(_RolemodulesDTO);
                        }
                    }
                }
                catch (Exception)
                {
                    throw;
                }
            });

            return(_RolemodulesDTOList);
        }
        public IActionResult SaveRoleModule([FromBody] RolemodulesDTO _RolemodulesDTO)
        {
            try
            {
                if (!string.IsNullOrEmpty(_RolemodulesDTO.pModulename))
                {
                    if (_RolesDAL.SaveRoleModule(_RolemodulesDTO, Con))
                    {
                        return(Ok(true));
                    }
                    else
                    {
                        return(StatusCode(StatusCodes.Status304NotModified));
                    }
                }
                else
                {
                    return(StatusCode(StatusCodes.Status406NotAcceptable));
                }
            }
            catch (Exception)
            {
                return(StatusCode(StatusCodes.Status500InternalServerError));

                throw;
            }
        }
Esempio n. 3
0
        public bool SaveRoleModule(RolemodulesDTO _RolemodulesDTO, string Connectionstring)
        {
            bool Issaved = false;

            try
            {
                con = new NpgsqlConnection(Connectionstring);
                if (con.State != ConnectionState.Open)
                {
                    con.Open();
                }
                trans = con.BeginTransaction();
                _     = NPGSqlHelper.ExecuteNonQuery(trans, CommandType.Text, cmdText: "INSERT INTO tblmstmodules (modulename,moduledescription,statusid,createdby,createddate) VALUES ('" + ManageQuote(_RolemodulesDTO.pModulename).Trim() + "', ''," + Convert.ToInt32(Status.Active) + ", " + _RolemodulesDTO.pCreatedby + ", current_timestamp); ");
                trans.Commit();
                Issaved = true;
            }
            catch (Exception)
            {
                trans.Rollback();
                throw;
            }
            finally
            {
                if (con.State == ConnectionState.Open)
                {
                    con.Dispose();
                    con.Close();
                    con.ClearPool();
                    trans.Dispose();
                }
            }

            return(Issaved);
        }