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);
}
