public async Task <List <WorkGroupinrolesDTO> > GetallWorkGroupsinRoles(string connectionString) { await Task.Run(() => { _WorkgroupList = new List <WorkGroupinrolesDTO>(); try { using (NpgsqlDataReader dataReader = NPGSqlHelper.ExecuteReader(connectionString, CommandType.Text, "select groupid,groupname from tblmstgroup where statusid=" + Convert.ToInt32(Status.Active) + ";")) { while (dataReader.Read()) { WorkGroupinrolesDTO _WorkGroupinrolesDTO = new WorkGroupinrolesDTO { pGroupname = Convert.ToString(dataReader["groupname"]), pGroupid = Convert.ToInt64(dataReader["groupid"]) }; _WorkgroupList.Add(_WorkGroupinrolesDTO); } } } catch (Exception) { throw; } }); return(_WorkgroupList); }
public IActionResult SaveWorkGroupinRole([FromBody] WorkGroupinrolesDTO _WorkGroupinrolesDTO) { try { if (!string.IsNullOrEmpty(_WorkGroupinrolesDTO.pGroupname)) { if (_RolesDAL.SaveWorkGroupinRole(_WorkGroupinrolesDTO, Con)) { return(Ok(true)); } else { return(StatusCode(StatusCodes.Status304NotModified)); } } else { return(StatusCode(StatusCodes.Status406NotAcceptable)); } } catch (Exception) { return(StatusCode(StatusCodes.Status500InternalServerError)); throw; } }
public bool SaveWorkGroupinRole(WorkGroupinrolesDTO _WorkGroupinrolesDTO, 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, "INSERT INTO tblmstgroup (groupname,groupdescription,issystemgroup,statusid,createdby,createddate) VALUES ('" + ManageQuote(_WorkGroupinrolesDTO.pGroupname).Trim().ToUpper() + "', '', 'N', " + Convert.ToInt32(Status.Active) + ", " + _WorkGroupinrolesDTO.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); }