public Dictionary <Guid, string> GetDictionary(ECommonObjectType objectType) { List <SqlParameter> paramList = new List <SqlParameter>() { new SqlParameter("@ObjectTypeId", objectType.GetHashCode()) }; return(this.GetDictionary(StoredProcs.Dictionary, paramList)); }
public DateTime?LastModified(ECommonObjectType objectType, Guid id) { List <SqlParameter> paramList = new List <SqlParameter>() { new SqlParameter("@ObjectTypeId", objectType.GetHashCode()), new SqlParameter("@Id", id) }; return(this.ExecuteScalarDateTime(StoredProcs.LastModified, paramList)); }
public Guid CreatedBy(ECommonObjectType objectType, Guid id) { List <SqlParameter> paramList = new List <SqlParameter>() { new SqlParameter("@ObjectTypeId", objectType.GetHashCode()), new SqlParameter("@Id", id) }; return(this.ExecuteScalarGuid(StoredProcs.CreatedBy, paramList).Value); }
public string Description(ECommonObjectType objectType, Guid id) { List <SqlParameter> paramList = new List <SqlParameter>() { new SqlParameter("@ObjectTypeId", objectType.GetHashCode()), new SqlParameter("@Id", id) }; return(this.ExecuteScalarString(StoredProcs.Description, paramList)); }
public Guid Id(ECommonObjectType objectType, string nameOrDisplay) { List <SqlParameter> paramList = new List <SqlParameter>() { new SqlParameter("@ObjectTypeId", objectType.GetHashCode()), new SqlParameter("@NameOrDisplay", nameOrDisplay) }; return(this.ExecuteScalarGuid(StoredProcs.Id, paramList).Value); }
public bool IsValidId(ECommonObjectType objectType, Guid id) { List <SqlParameter> paramList = new List <SqlParameter>() { new SqlParameter("@ObjectTypeId", objectType.GetHashCode()), new SqlParameter("@Id", id) }; return(this.ExecuteScalar(StoredProcs.IsValidId, paramList) == 1); }