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