public DataSet GetTeamsByCompanyID(int company_id)
{
db_helper db = new db_helper(db_helper.ConnectionStr.HelpdeskConnStr);
return(db.ExecuteDataSet("Select T.id, T.description From t_team_company TC Inner Join t_team T On TC.team_id = T.id Where TC.company_id = " + company_id.ToString(), System.Data.CommandType.Text));
}
public DataSet GetAllUsers()
{
db_helper db = new db_helper(db_helper.ConnectionStr.vAppUsersConnStr);
return(db.ExecuteDataSet("Select Id, UserName From [Vantage_App_Users].[dbo].[AspNetUsers]", System.Data.CommandType.Text));
}
public DataSet GetAllCompanies()
{
db_helper db = new db_helper(db_helper.ConnectionStr.HelpdeskConnStr);
return(db.ExecuteDataSet("Select id, description From [VantageHelpdesk].[dbo].[t_company]", System.Data.CommandType.Text));
}
public DataSet GetMailSettings()
{
db_helper db = new db_helper(db_helper.ConnectionStr.vPortalConnStr);
return(db.ExecuteDataSet("select * from [VantagePortal].[dbo].[site_settings] where site_id = 1003 and setting_category = 'MAIL'", System.Data.CommandType.Text));
}