public async Task <List <RolesubmodulesDTO> > GetRolesSubModulesbyModule(long Moduleid, string connectionString)
{
await Task.Run(() =>
{
_RolesubmodulesDTOList = new List <RolesubmodulesDTO>();
try
{
using (NpgsqlDataReader dataReader = NPGSqlHelper.ExecuteReader(connectionString, CommandType.Text, "select moduleid,modulename from tblmstmodules where parentmoduleid= " + Moduleid + " and statusid=" + Convert.ToInt32(Status.Active) + " order by modulename desc;"))
{
while (dataReader.Read())
{
RolesubmodulesDTO _RolesubmodulesDTO = new RolesubmodulesDTO
{
pSubmodulename = Convert.ToString(dataReader["modulename"]),
pSubmoduleId = Convert.ToInt64(dataReader["moduleid"])
};
_RolesubmodulesDTOList.Add(_RolesubmodulesDTO);
}
}
}
catch (Exception)
{
throw;
}
});
return(_RolesubmodulesDTOList);
}
public IActionResult SaveRoleSubModule([FromBody] RolesubmodulesDTO _RolesubmodulesDTO)
{
try
{
if (!string.IsNullOrEmpty(_RolesubmodulesDTO.pModulename) && !string.IsNullOrEmpty(_RolesubmodulesDTO.pSubmodulename))
{
if (_RolesDAL.SaveRoleSubModule(_RolesubmodulesDTO, Con))
{
return(Ok(true));
}
else
{
return(StatusCode(StatusCodes.Status304NotModified));
}
}
else
{
return(StatusCode(StatusCodes.Status406NotAcceptable));
}
}
catch (Exception)
{
return(StatusCode(StatusCodes.Status500InternalServerError));
throw;
}
}
public bool SaveRoleSubModule(RolesubmodulesDTO _RolesubmodulesDTO, 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,parentmoduleid,parentmodulename,statusid,createdby,createddate) VALUES ('" + ManageQuote(_RolesubmodulesDTO.pSubmodulename).Trim() + "', '', " + _RolesubmodulesDTO.pModuleId + ", '" + ManageQuote(_RolesubmodulesDTO.pModulename).Trim() + "'," + Convert.ToInt32(Status.Active) + ", " + _RolesubmodulesDTO.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);
}
