public string getRole(string MID) { string storedProc = "sp_getRole"; DynamicParameters param = new DynamicParameters(); param.Add("@MID", MID); string role = (string)dao.ExecuteScalar(System.Data.CommandType.StoredProcedure, sql: storedProc, parameters: param); return(role); }
public string getTokenStatus(string GUID, int MetaActive) { string sqlQuery = "sp_getTokenStatus"; DynamicParameters param = new DynamicParameters(); param.Add("@GUID", GUID); param.Add("@MetaActive", MetaActive); return(dao.ExecuteScalar(commandType: System.Data.CommandType.StoredProcedure, sql: sqlQuery, parameters: param).ToString()); }
public string CheckAssetMIDMapping(int MID, int AssetID) { string sqlQuery = "sp_CheckAssetMIDMapping"; DynamicParameters param = new DynamicParameters(); param.Add("@AssetID", AssetID); param.Add("@MID", MID); param.Add("@return", dbType: System.Data.DbType.String, direction: System.Data.ParameterDirection.Output, size: 5215585); dao.ExecuteScalar(commandType: System.Data.CommandType.StoredProcedure, sql: sqlQuery, parameters: param); string exists = param.Get <string>("return"); return(exists); }
public string SRCreatorMail(int SRID) { string query = "select EmailId from Users where id in ( Select user_id from ServiceRequest where id =" + SRID + ")"; return((string)dao.ExecuteScalar(System.Data.CommandType.Text, query)); }
public object ExecuteScalar(string sql) { return(dapper.ExecuteScalar(sql, CommandType.Text)); }